+ Reply to Thread
Results 1 to 3 of 3

Save file into 2 folders using one command

  1. 09-14-2008, 08:43 AM #1
    JamesT1
    JamesT1 is offline
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    418

    Save file into 2 folders using one command

    Hi all

    Is it possible using a one command button to save a file into its current file and another file at the same time

    thanks
    Reply With QuoteRegister To Reply
  2. 09-14-2008, 08:57 AM #2
    mudraker
    mudraker is offline
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    have a look at

    http://www.exceltip.com/st/Save_a_wo...Excel/474.html

    The 2nd macro can be modified to save to a different drive & folder than A drive
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.
    Reply With QuoteRegister To Reply
  3. 09-14-2008, 12:06 PM #3
    JamesT1
    JamesT1 is offline
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    418
    mudraker

    works a treat, thank you for your help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to save emailed file in Lotus Notes with changing filename
    By liquidskin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2008, 02:53 PM
  2. macro to import text file
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2008, 09:08 AM
  3. Adding date to file save as
    By Dylan&Hayden in forum Excel General
    Replies: 2
    Last Post: 07-16-2008, 06:03 PM
  4. Using String as filename in Save As not recognised by Dir
    By NoCanDo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-20-2008, 05:49 PM
  5. Save file with certin Criteria
    By parteegolfer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2006, 12:26 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1