Setting a dynamic path for VBA

[skaswani]

Setting a dynamic path for VBA


Hello
How are You all


I have a problem regarding following issue, please kindly help me, thanks


Daily I have to update some files of Xls & what I do is that I make new folder with the Today’s date , i.e last time I made 17-may-07 , on next day I’ll copy the same files into new folder 18-may-07 …

I want make a macro that suppose dailyreport.xls file open automatically with the master file spouse shares.xls files

I try to do

Please Login or Register  to view this content.

But it gives me debug error as its unable to recognize the folder name, but thing is Both files are in same folder!


Please kindly share your knowledge!

Thanks
Regards,

[mudraker]

When using macros to open files it is always best to include the full path as well as the file name

If the file is in the same folder as the workbook that is running the macro you could use

Please Login or Register  to view this content.