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

[AGrayson84]

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.

[Bernie Deitrick]

Replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.