Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File save as
Ian,
Filter is a built-in function in VBA, and therefore a reserved word. Change your variable name to something else. -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Ian Mangelsdorf" wrote in message om... I have a section of code that worked OK with Excel 97, however when I run it with 2000 or XP I get errors along the lines of "Compiler error Augument not optional. Is there an easy way of updating this code so that the code will save the file in a given (by the user) location with a given (by the user) name Cheers Ian 'save new job 'set up filters filter = "Excel Files (*.xls), *.xls," ' Display *.sub by default filterindex = 1 ' Set dialog caption Title = "Save File As" savefileas = Application.GetSaveAsFilename(Well.Text, filter, _ filterindex, Title) If savefileas = False Then Exit Sub End If ThisWorkbook.SaveAs Filename:=savefileas |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File save as
Thanks all
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) | |||
'document not saved' for 'save' or 'save as' an EXCEL file | Excel Discussion (Misc queries) | |||
Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions |