+ Reply to Thread
Results 1 to 3 of 3

Vba save csv file but ask for file name or select file name from folder

  1. #1
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    Vba save csv file but ask for file name or select file name from folder

    I have written about six Macros to do some things with a worksheet and they work fine
    I wish to reduce all but one Macro to do same thing, but I need to select a file to svae from the folder in the code
    I will attach the code and I hope someone can help me change the code to select a file then continue the Macro
    Any help is always appreciated here !!
    Regards
    Graham
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-30-2017
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    7

    Re: Vba save csv file but ask for file name or select file name from folder

    Hi there Gramhamfeeley,

    Would you be able to provide me with an excel workbook on which this macro runs on?

    When you say
    I need to select a file to svae from the folder in the code
    what exactly do you mean? Do you want to select a specific folder and then let the macro pick up on the file path?

    Thanks,

    Jim

  3. #3
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    Re: Vba save csv file but ask for file name or select file name from folder

    Yes Jim first thanks for a reply now I will try to make this clear
    File folder is :C:\Users\Grah\Documents\Racing\
    vba will open folder and i then select a csv file to save as
    Msgbog or Inputbox asks for a filename to select

    then when file name is resolved then macro continues to save
    Hope this is clearer
    Graham
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to select a file instead of selecting the file's destination path/folder
    By dedark05 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-30-2016, 10:17 PM
  2. Replies: 1
    Last Post: 12-01-2016, 10:57 AM
  3. Vba to save a file to a folder with the file name plus a sequential number
    By Lsxtrkiller in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2016, 04:07 PM
  4. [SOLVED] User input to select file and save copy in hidden folder
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2013, 10:24 AM
  5. [SOLVED] macro to save file to specific folder with file name from cell reference
    By mezza89 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2013, 11:32 AM
  6. [SOLVED] Need help to save file to new folder and delete old file using same file name
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2012, 11:16 PM
  7. Replies: 0
    Last Post: 04-16-2012, 10:57 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1