VBA SaveAs

[jeskit]

Hi

I am using Excel 2010 and within a piece of a code i have i am using SaveAs and it works fine but it keeps saving the file into "My Documents". I was wondering if anyone knew if there is a way get it to SaveAs in a defined location?

Thanks

Jeskit

[royUK]

You can specify the File Path in the code

Please Login or Register  to view this content.

[jeskit]

Hi

Thanks works now!