+ Reply to Thread
Results 1 to 2 of 2

Save file in new location and then close that file and go back to the first file

  1. #1
    Registered User
    Join Date
    09-25-2012
    Location
    Regina SK
    MS-Off Ver
    Excel 2007
    Posts
    5

    Save file in new location and then close that file and go back to the first file

    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

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,017

    Re: Save file in new location and then close that file and go back to the first file

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1