Macro to save as using path in worksheet

**Shahid_Excel** · 04-02-2012, 04:25 PM

Hi

I need some help with the below macro please.

The macro is working fine but what I want to change is the path for saving the file. The path that I would like it saved to is in the worksheet "NEW ORDER_" cell "N2"

Please Login or Register  to view this content.

I am new to the forum so this may not be filled in correctly, please let me know.

Thank you.

**Chippy** · 04-02-2012, 05:40 PM

Try changing:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

I am new to the forum so this may not be filled in correctly, please let me know.

Good post, but please put code tags around VBA code.

**Shahid_Excel** · 04-02-2012, 06:35 PM

HI Chippy

Thank you for your reply.

After changing the code I get the following error when i run the macro.

Please Login or Register  to view this content.

Sorry I don't have much knowledge of VBA

**Chippy** · 04-03-2012, 07:24 AM

You said the existing code was working, but try removing the first comma in this line:

Please Login or Register  to view this content.

If no joy, what is in cell N2 on sheet NEW ORDER_? It must be a valid folder path including drive, e.g. C:\folder1\folder2

Put:

Please Login or Register  to view this content.

before the SaveAs. It should give you a clue as to the reason for the error. myName must be a valid full file name, including drive letter, folder path and file name.

**Shahid_Excel** · 04-03-2012, 08:16 AM

Hi Chippy

I'm really sorry I had the wrong path in cell N2, sorry for wasting your time.

Thank you very much for your help on this it works a treat now.

Shahid_Excel