save active worksheet in directory called in another worksheet cell

hey all,

I have a macro that at the end saves the current worksheet, the problem is that in another sheet the user uses two cells to name the input and output directory, I would like the save as to be the one named in the other sheet.

example of my current code;

Please Login or Register  to view this content.

The user inputs the output folder path in the worksheet called "Input" cell B2. I need this save code to reference that cell and save as to that directory.

Thanks.