| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
date in file name
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 |
|
#2
|
|||
|
|||
|
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. On Mon, 26 Sep 2005 09:17:04 -0700, tommod wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert the date the file was last modified | Excel Discussion (Misc queries) | |||
| Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
| Using other workbooks.. | Excel Worksheet Functions | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
