Getting macro to save in folder specified on worksheet

[lealea1982]

Hi there,

I have a macro that currently saves and prints the sheet I'm working on. At the moment, it saves everything in the same place and always calls the file the same name. In the worksheet, a lookup does actually specify what folder it should be saved in and what name it should be given. How can I write the code so that it pulls up the name and the folder directly from the sheet it's saving?

Many thanks

Leanne

[royUK]

You need to attach the workbook, at least tell us what cells you are referring to & post the code.

[lealea1982]

Hi again,

Currently the code reads:

Please Login or Register  to view this content.

But instead I want it to get the folder (ChDir) from cell A16, and the filename from cell B16. I know it's probably quite easy but I'm not sure how to write it.

Thanks

Leanne

[royUK]

Try using

Please Login or Register  to view this content.