VB Script to save as

[MalcolmOPNZ]

Hi
I am very new to this. I am using the code below to save workbooks with date as part of the filename. It is working correctly but I want to save the files in a sub folder not the original. The original location is ("C:\Users\xxxxxxxxxxxxxx\Trial") but I want to save them in ("C:\Users\xxxxxxxxxxxxxx\Trial\TEST"). I have tried to find the answer but nothing seems to work. Thanks for any help.

Malcolm

Please Login or Register  to view this content.

[truk2]

I think that this source should give you most of what you need.

https://stackoverflow.com/questions/...-save-location

[AliGW]

@truk2

Administrative Note:

Welcome to the forum.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

[truk2]

Not a problem.
Will do

[MalcolmOPNZ]

Thanks for the help