>>>You can prompt user to enter the file name in, say, text box, and then use textbox.value in .workbook.saveas(...) statement.
>>>
>>>Good Luck
>>
>>Hi Yuri,
>>
>>I was thinking about it as well.
>>
>>Alternatively, do you know how to call Excel.SaveAs dialog interactively?
>
>Usually you need something like:
>
>oExcel.Application.Dialogs(DialogNumber).Show
>
>You can go to Excel VBA help to find out what is exact number for SAveAs dialog
Yuri,
Somehow I can not figure out how to invoke Help for VBA. I'm trying to follow these instructions
Excel
----------------------------------------------------------
On the Developer tab, click Visual Basic.
I don't see the Developer tab
Click the Microsoft Office Button, and then click Excel Options.
Click Popular, and then select the Show Developer tab in the Ribbon check box.
Note The Ribbon is part of the Microsoft Office Fluent user interface
On the Help menu, click Microsoft Visual Basic Help.
In the Type words to search for box, type the method, property, function, statement, or object for which you want help, or type a query.
--------------------------------------
But on the step 2 I now don't see Help menu.
Attached is the screen right now - how can I invoke VBA Help?
If it's not broken, fix it until it is.
My Blog