I am trying to make a copy of the active workbook.
I used the command “ActiveWorkbook.SaveCopyAs strFileSaveAsName”
It makes a copy of the file… but the form from the original workbook, for some reason, gets moved to the newly created workbook. And when I try to run the original program one more time it gives me an error “could not find the specified object” and when I try to open the form in the original workbook I get “path/file access error” message.

Thanks.

Here is some code:

        lcFileSaveAs = "c:\temp\" & lcFileSaveAs

        goExcel.ActiveWorkbook.Saved = True
        goExcel.ActiveWorkbook.SaveAs FileName:=lcFileSaveAs
        goExcel.Quit


Notice the := , yes the power of : learned it the hard way.