Saving an external file without making it active

  • Thread starter Thread starter JENNA
  • Start date Start date
J

JENNA

Hi all,

I have a userform in one file that is used as a frontend to place data
into cells of an opened external file. When I click on a save control
on this userform I wish for it save this external file without first
making the external file active.

Something like:

"ExternalFile.xls".Save

Thanks for any help
 
Jenna,

Private Sub cmdSave_Click()
Workbooks("ExternalFile.xls").Save
End Sub

Rob
 
Back
Top