Hi All,, This is my first post,,,
We have clients that are remote and we are looking for them to save a input file on our FTP, with a differnt name,,, and oviously differnt location then the cleints.
We are wanting to add the macro/vb code to a buttom on the clients file.....
So,,,
Client - (Inputfile.xlsm) to be saved on out FTP as (Datafile.xlsm) and then the Datafile.xlsm is closed and Inputfile is to stay open......
Thanks for the help....
Doug
Hi, Doug,
instead of using avariable for the original workbook and SaveAs and the clsoing and opening again have a look at SaveCopyAs which should do what you want but leave you in the original workbook.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks