Auto save to specific folder based on cell contents

Good Monring Folk

I have this code I use to save a workbook into a specific folder, It is in a generic form we use accross several sites and it changes the name accordingly


Is it possible to save the workbook to a folder with the same name as the contents of a cell...

e.g. Sites,,,, Glasgow, Edinburgh and Aberdeen

On opening the generic file cell A1 picks the location name...... if I have a folder for each location.... could it save the file into the relevent folder

Many thanks for your help

Please Login or Register  to view this content.

Hi JamesT1,

The following code should help you get started. There are two versions:
a. Full path in cell 'A1'
b. Partial path in cell 'A1' (e.g. 'Glasgow')

It is assumed that cell 'A1' is in the first sheet. That is easily changed if you have a specific Sheet Name you are using for all your applications.

Please Login or Register  to view this content.

Lewis