Macro Help - Modify macro to save as to specific location

[scoochUM]

Currently have this macro running, which does a save as and names the file based on the value in cell B3. I would like to modify this macro so it also saves the file to a specific directory (example C:/dropbox).

Please Login or Register  to view this content.

[Fotis1991]

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#3 and add code tags around your code.

[scoochUM]

Got it, thanks! Sorry for being a NooB!

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#3 and add code tags around your code.

[Fotis1991]

Thanks for understanding.

Give a try to this.

Please Login or Register  to view this content.

[scoochUM]

Didn't work, it saves the file still as name in cell but saved to desktop instead of specified folder. Also, created a new workbook and gave the following error:

Run-time error '1004':

Microsoft excel cannot access the file C:/C877B220. There are several possible reasons:
The file name or path does not exist
The file is being used by another program
The workbook you are trying to save has the same name as a currently open workbook

Any thoughts?

[Fotis1991]

In my tests, macro works like this.

saves the file with the name of cell b3 AND create a new one with name "C:\dropbox.xls"..

VBA isnot my strong card so sorry but no other idea.

[scoochUM]

Just to make sure we are on the same page, I am not trying to create 2 separate files (I think that's what you're saying). I'm trying to save the file with the name in cell b3 & just save this same file to a specific folder (in example, c:/dropbox).

In my tests, macro works like this.

saves the file with the name of cell b3 AND create a new one with name "C:\dropbox.xls"..

VBA isnot my strong card so sorry but no other idea.

[Fotis1991]

Exactly!!

[scoochUM]

Any other ideas????