SaveAs method

pm · May 13th, 2002, 11:23 AM

when I use a saveas method on a MAC , does the user have to specify the .xls extension?
i get a 1004 error, I tried increasing the memory..this is a big file we are talking about..
thanks

Mark O'Brien · May 13th, 2002, 11:37 AM

Hi pm,

I wouldn't imagine so. On the PC version you can add the extension yourself or Excel will add it for you.

Is the application letting you "Debug" when you get the 1004 error? If it does, it may be useful id you could post that line of code and any other relevant code.

pm · May 13th, 2002, 11:44 AM

thanks Mark

here is my code
temp_fn = Application.GetSaveAsFilename( _
"Submission Workbook -- rename me", , , _
"Enter the filename for the new submission workbook", "Ok")
--after this i trim the filename to remove the path hierarchy--
and then do this:
ActiveWorkbook.SaveCopyAs FileName:=temp_fn

for some reason it just loses the value of temp_fn and says that Excel cannot find the file I am looking for

Please help!

May 13th, 2002, 11:37 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Hi pm, I wouldn't imagine so. On the PC version you can add the extension yourself or Excel will add it for you. Is the application letting you "Debug" when you get the 1004 error? If it does, it may be useful id you could post that line of code and any other relevant code. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 11:23 AM	#1
pm New Member Join Date: Apr 2002 Posts: 19	when I use a saveas method on a MAC , does the user have to specify the .xls extension? i get a 1004 error, I tried increasing the memory..this is a big file we are talking about.. thanks

May 13th, 2002, 11:44 AM	#3
pm New Member Join Date: Apr 2002 Posts: 19	thanks Mark here is my code temp_fn = Application.GetSaveAsFilename( _ "Submission Workbook -- rename me", , , _ "Enter the filename for the new submission workbook", "Ok") --after this i trim the filename to remove the path hierarchy-- and then do this: ActiveWorkbook.SaveCopyAs FileName:=temp_fn for some reason it just loses the value of temp_fn and says that Excel cannot find the file I am looking for Please help!