Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
sStr = Thisworkbook.Path & "\" & activecell.value & ".xls"
fname = application.GetSaveAsFileName( InitialFileName:=sStr) -- Regards, Tom Ogilvy "Bill Sturdevant" wrote in message ... I am trying to create a button that will pick a value from a specified cell and put up a Save As dialog pre-filled with the name of the file as Value-I-Picked.xls and the suggested path as the path of the workbook I originally opened. Where can I find suggestions for appropriate code? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save as dialog | Excel Discussion (Misc queries) | |||
how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
VBA code to show a save as dialog does not work | Excel Programming | |||
Changing Save As Type in Save as dialog box | Excel Programming | |||
Save As Dialog | Excel Programming |