Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW DO I USE THE GETSAVEASFILENAME METHOD?
When using the InitialFilename argument, I would like to combine the contents
of several cells and a text constant to form the InitialFilename. For example, I want the filename to be a string consisting of: "C" + "cell1" + "cell2". If the contents of "cell1" are '50000' and "cell2" are the text letter 'A', then the InitialFilename argument would be: C50000A.xls. What is the code for this in Excel 2003 VBA? Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with getsaveasfilename | Excel Discussion (Misc queries) | |||
GetSaveasFileName | Excel Programming | |||
GetSaveAsFileName | Excel Programming | |||
GetSaveAsFilename method | Excel Programming | |||
GetSaveAsFilename | Excel Programming |