Code Fails Saving File

**breader** · 11-27-2013, 02:05 AM

Hi

I am working with 2 files, A and B.

File A opens File B and then saves File B as file C.

Then Data gets pasted from File A to File C and then File C is saved as file C

My code works up to where I want to save file C as file C after pasting data from file A.

See my note within the code below CODE FAILS HERE

Thanks for any help on fixing this, Benjamin

Please Login or Register  to view this content.

**AlphaFrog** · 11-27-2013, 03:06 AM

SaveAs is used to create a new file and not save an existing file. If you try to use SaveAs a 2nd time with the same file name, it errors because that file already exists.

The 2nd time you save file C, just use...
WbkFPOFOpen.Save
...with no file name.

Or you could replace this...
WbkFPOFOpen.SaveAs Filename:=(WksFPMasterControl.Range("FPOF_Root_Directory_Save").Value)
WbkFPOFOpen.Close (False)
With just this to both Save and Close
WbkFPOFOpen.Close SaveChanges:=True

Also note: the variable name is the Dim statement is different than within the rest of code
Dim WkbFPOFOpen As Workbook
WbkFPOFOpen.SaveAs Filename:=(WksFPMasterControl.Range("FPOF_Root_Directory_Save").Value)