date in file name

T

tommod

Hi,
I'm trying to build a macro that runs automatically creating a pivot table
when I charge external data in a workbook, without opening the workbook. Is
this possible or I have to looking for another solution?
Thx
t
 
M

Myrna Larson

How do you propose to "know" that the data in the other workbook has been
changed?

Assuming you have a solution to that problem, your macro can open the source
workbook without it becoming visible, create the table, then close the
workbook.
 
Top