Saving file to same folder where macro is located

**UAL225** · 05-02-2019, 02:25 PM

Hi,

How do I get the below to save in the same folder the file is located in? If this is located in desktop/macro folder how can I have this output to also save in that same folder rather than My Documents?

Please Login or Register  to view this content.

**Fluff13** · 05-02-2019, 03:02 PM

How about

Please Login or Register  to view this content.

Saving file to same folder where macro is located

LinkBack

Thread Tools

Rate This Thread

Display

Saving file to same folder where macro is located

Re: Saving file to same folder where macro is located

Thread Information

Users Browsing this Thread

Similar Threads

How to fetch a cell from a different excel file, which is closed & in a different folder

appending a text file from the same folder where excel file is located

VBA-print as pdf w/ filename from a cell, & print in folder excel file is located

Need a macro to save an active file in another folder as a name that is located in a cell

Reduce processing time for saving excel sheets located in a folder

Get 3 cell values from all the excel files located in folder & make table in master file

Macro - Open up file based on search filter located in folder with various subfolders

Bookmarks

Bookmarks

Posting Permissions