Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Grant Young   on Sep 17 In MS Office Category.

  
Question Answered By: Ethan Evans   on Sep 17

I wonder about your Me.fFullName - does it return a full, absolute path (eg,
"C:\path1\filename.xls") or a relative one ("filename.xls")? If it's
relative, the question is where is it saving it.



Do you get an error of some kind? Can you step through the code and see
what's happening? When it hits the SaveAs line, you should be able to tell
if you flip back to the Workbook and see if it is now saved or not and with
what name. And if you then try File/SaveAs you should be able to tell in
which folder it's saved too.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on workbooks.add Or get search suggestion and latest updates.


Tagged: