I get an Run-time error '438'
Object doesn't support this property or method.
Any idea what I'm doing wrong? (cut and pasted it into the editor, replacing what was already there.)
Hmmm... guess I am not getting it... Here is the script from the recording:
Sub Macro3()
'
' Macro3 Macro
' Macro recorded 12/11/2003 by CRHamilton
'
' Keyboard Shortcut: Ctrl+z
'
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\crhamilton\Desktop\Book1.xls"...
I am trying to setup a macro in Excel 2k that will initiate the SaveAs function, but will stop and prompt for a file name. Trying to use the "Record a Macro" in excel, then go into the VBS editor, but nothing seems to work. Can anyone point me in the right direction? Thnx in advance...
We are having the same problem here. I've done everything listed in the faq on the symantec page (listed above) with no change. Watching the host side, it nevers changes from "Waiting for Connection", although the modem is initialized by PCA. To further muddy the waters, this is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.