how to choose where to save an output file

[polina]

Hi

I was wondering if anyone knows how implement the following:

I send the table to the excel spreadsheet file. The location of the excel file is hardcoded. However it is sort of limiting for the user in case she/he wants to save the file in their own directory. So I want to give that option to the users so they can choose the directory they want

Please let me know if there is a way to do that

Thanks

 

[sambo]

The attatched Module will let you select a folder when you open the Excel workbook.
You need to make sure that the code from this module is copied and pasted into the "ThisWorkbook" code Module of your excel book.

the variable myDir is public and can be used from anywhere in the excel book by calling ThisWorkbook.myDir.
Making this variable public allows you to use it from anywhere in your workbook modules.

Look in the ThisWorkbook Module of "folderselect.xls" for the code you need

The folder selection window should popup when the Excel workbook is opened if this code is inserted correctly.

Good Luck...