Help with macro for saving to a folder specified in a cell

[RMSDesign]

Hi all,

I am looking to create a macro that will allow me to save the excel workbook I am working on to a folder that I can specify the name of in a certain cell.

For example if I have folders A, B, C, D that I want to be able to save to. In cell A1 I want to be able to enter A, B, C or D so that I don't have to go through browse to choose my file location.

Not sure if this is possible, any help would be greatly appreciated.

Thanks,
RMS Design

[Vraag en antwoord]

It can be quite simple, but you give too little information. You can search for Thisworbook.saveas.

There are instructions at the top of the page explaining how to attach your sample workbook.

[RMSDesign]

This workbook will be used as a template for quoting jobs. In cell A1 I would like to put the company that I am quoting the job for. On my desktop I have a folder containing many folders with all of the names of the companies I generate quotes for. I would like the macro to search the folders to find the company name which is in cell A1. Basically I am searching for the save location based on Cell A1.

[Vraag en antwoord]

That's also about in #1 and doesn't add much new information. Already searched for Saveas

[RMSDesign]

I searched for it, I can't seem to find a way to choose the file path.