+ Reply to Thread
Results 1 to 2 of 2

VBA - Modify existing code that exports range to file, to prompt for location to save file

  1. #1
    Registered User
    Join Date
    12-20-2016
    Location
    United States
    MS-Off Ver
    2016
    Posts
    28

    VBA - Modify existing code that exports range to file, to prompt for location to save file

    Hi everyone, I have some VBA code that is used to export a specific cell range to a .PS1 file, which basically makes a PowerShell output file that I can run to do some scripts. I have the below VBA that designates the filename and the file location, but I would like to alter the script to prompt the user for the file location, while retaining the filename designation along with everything else in the VBA code. Would anyone mind helping me alter my below code to prompt for the file location? Thank you in advance.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2003, 2010, 2016 (Windows)
    Posts
    4,721

    Re: VBA - Modify existing code that exports range to file, to prompt for location to save

    Replace

    Please Login or Register  to view this content.
    with

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. SAP Exports file location
    By BryceVBA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2017, 02:55 PM
  2. Replies: 4
    Last Post: 04-05-2016, 12:19 AM
  3. Replies: 1
    Last Post: 02-27-2014, 01:01 PM
  4. Macro to prompt user for file name and save in location
    By Fungijus in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-21-2011, 02:16 PM
  5. Modify Default Open/Save to Current File Location
    By msmithdynamicsgp in forum Excel General
    Replies: 0
    Last Post: 09-21-2011, 04:55 PM
  6. Save as macro with location prompt but fixed file name ?
    By Simon-ch in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-31-2008, 07:52 AM

Tags for this Thread

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