ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   'Save as' window in VBA (https://www.excelbanter.com/excel-discussion-misc-queries/246942-save-window-vba.html)

cluckers

'Save as' window in VBA
 
How do you get the "save as" pop to occur in VBA. Thix way if the save as
location written in VBA is not available/working it can go to an error
handling where they can pick the location/name in the save as window

thanks

Mike H

'Save as' window in VBA
 
Hi,

Application.GetSaveAsFilename

Mike

"cluckers" wrote:

How do you get the "save as" pop to occur in VBA. Thix way if the save as
location written in VBA is not available/working it can go to an error
handling where they can pick the location/name in the save as window

thanks



All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com