Problem saving to correct file path

Hi there,

I'v pieced together a macro that will split two worksheets out from a master. Both of these files are then saved in the same location as the master file.

The problem is that the macro I have saves the files to the C drive (not where the master is saved). I can see why this is but don't know how to change it.

Please Login or Register  to view this content.

Can anyone help?

Thanks
Bobbi

Have a look at using ThisWorkbook.Path which will return the path of the file the macros are in.

Dom