+ Reply to Thread
Results 1 to 8 of 8

Save an active csv file into a given directory

  1. 01-02-2017, 07:18 PM #1
    plans
    plans is offline
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    596

    Save an active csv file into a given directory

    Hello,
    I have an active .csv workbook;
    I want to save it as an excel file in a given directory.
    I am trying this script:
    Please Login or Register  to view this content.
    I am getting a Run-time error 1004
    What is wrong here?
    Thanks
    Reply With QuoteRegister To Reply
  2. 01-02-2017, 07:23 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Save an active csv file into a given directory

    Are you trying to save as an Excel file or a CSV file?
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 01-02-2017, 07:33 PM #3
    plans
    plans is offline
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    596

    Re: Save an active csv file into a given directory

    as an Excel file.
    Thanks
    Reply With QuoteRegister To Reply
  4. 01-02-2017, 07:58 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Save an active csv file into a given directory 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 01-02-2017, 08:13 PM #5
    plans
    plans is offline
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    596

    Re: Save an active csv file into a given directory

    The problem I have is that the :
    Please Login or Register  to view this content.
    is a variable so I can not type in the directory because each time is different; only the 
    Please Login or Register  to view this content.
    is fixed.
    Thanks
    Reply With QuoteRegister To Reply
  6. 01-02-2017, 08:42 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Save an active csv file into a given directory 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 01-02-2017, 09:11 PM #7
    plans
    plans is offline
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    596

    Re: Save an active csv file into a given directory

    Thank you!
    Reply With QuoteRegister To Reply
  8. 01-03-2017, 12:46 PM #8
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Save an active csv file into a given directory

    You're welcome.
    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. [SOLVED] Need to loop a macro to save images to file - but save to user defined directory.
    By superfurry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2015, 07:49 AM
  2. [SOLVED] save file in directory
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-13-2014, 02:12 PM
  3. [SOLVED] Return the directory/folder of the active file
    By Tony Valko in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-13-2014, 09:03 PM
  4. URGENT Save file (not file that working in; path/file name variable) to another directory
    By marchtm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-27-2013, 12:13 PM
  5. Save .csv file as an Excel file while allowing user to choose directory and filename
    By SBMC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2013, 03:10 PM
  6. save pdf to Active directory and name as cell value
    By Scott Taylor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2013, 01:00 PM
  7. Prompt user for directory and filename; then save file in directory with file name
    By sgreni in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2009, 07:08 PM

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