date in file name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Pivot Table Macro 1
Pivot Table Comparison 1
Auto insert of a pivot table? 1
Can a pivot table be redirected to an external source? 1
XL2000 - Linking Named Ranges 1
PivotTable auto-refresh with external data 4
Workbook pivot table design function 6

Back
Top