| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As
I am a newby at programming Excel.
How do you program to bring up the "Save As" box? Orf Bartrop |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As
This should help:
Code:
Sub sv_as()
fileSaveName = Application.GetSaveAsFilename( _
fileFilter:="Excel File (*.xls), *.xls")
ActiveWorkbook.saveas (fileSaveName)
End Sub
I am a newby at programming Excel. How do you program to bring up the "Save As" box? Orf Bartrop |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As
Thank you, works well. However, at present it selects My Documents folder and I would like it to select a particulat folder. How do I nominate that folder rather than have to select it from the dialog box? Orf *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As
Use
chdrive "d:\Development" chdir "d:\Development" -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Orf Bartrop" wrote in message ... Thank you, works well. However, at present it selects My Documents folder and I would like it to select a particulat folder. How do I nominate that folder rather than have to select it from the dialog box? Orf *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
| Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() | Excel Discussion (Misc queries) | |||
| Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
| Why system asks me to save change even after I call save method(VB.NET) | Excel Programming | |||
Linear Mode
