Hey,
I have written a rather long macro for excel which will daily bring in our recon file and then use it to refresh several pivot tables. My macro automatically runs through a perl script, however once the refresh begins in excel, I must manually select the files. I was wondering if there is a macro i can write which will, for example, automatically refresh the pivot table with a file named "refresh.txt" in the same directory as the workbook (meaning I don't want to have to write c:\documents and settings... etc, but rather just current directory\refresh.txt
thanks for the help!!
I have written a rather long macro for excel which will daily bring in our recon file and then use it to refresh several pivot tables. My macro automatically runs through a perl script, however once the refresh begins in excel, I must manually select the files. I was wondering if there is a macro i can write which will, for example, automatically refresh the pivot table with a file named "refresh.txt" in the same directory as the workbook (meaning I don't want to have to write c:\documents and settings... etc, but rather just current directory\refresh.txt
thanks for the help!!