Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Fahimah Khan   on Sep 03 In MS Office Category.

  
Question Answered By: Jenny Lopez   on Sep 03

You have a folder  name in your save  statement of 08DC which doesn't match
what you were saying in the description. I think you have your backslash in
the wrong place. (In fact, you also have a second DC08 and a second use of
mnth. Much more stuff than you have in the description.)

As a matter of principal, do not construct something like a file  name
directly in the parameter of a call to a method. It makes things  much
harder to debug.

Create a variable and put the constructed file name in there, then check it
(e.g. using MsgBox or just view it in the VBE), and then use this file name
variable in the save call instead of the expression.

If you'd done it that way, you would almost certainly have spotted the
problem immediately, yourself.

Share: 

 

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

 
Didn't find what you were looking for? Find more on Saving files to specific location using VBA Or get search suggestion and latest updates.


Tagged: