Hi all, I am having hard time putting this together.. Was hoping someone would be able to help.
is there a way to set up a macro in excel VBA to download a txt file where the filename changes based on the business day? The only thing that would change is the date..I need to download daily files for previous business day in a shared drive
so for example, for 15th I would download the file: "name_02142011"
I have the ftp details, but also looking to download the file on a shared drive
Any help would be greatly appreciated
Thanks so much
Danny
Bookmarks