Opening and saving a text file.

[CJPHX]

I am looking for a way to have an excel macro to grab a .txt file form on of my company's servers and save it with a new name in a different directory. Currently this file is updated every morning and always has the same name WCUSP.txt(it always opens with notepad). Every morning I go and open this file and save it to my department's local drive with todays date so that we have historical data. So today's file would be saved as WCUSP11062010.txt. This txt file is used in a query in another macro and right now I have to go out to the server and manually save the file. I would like my macro to grab this file and save it for me before running the rest of the macro.

[JBeaucaire]

I'm no networking guru, so you'll have to play with the pathname references to get them right, but this is the syntax for copying a file from one place to another.

Please Login or Register  to view this content.

[CJPHX]

Sorry for the long delay had some time off. Thank you JB that worked perfectly. I was busy trying to open the file and then save it again but your suggestion worked perfectly.