View Single Post
 
Old 10-01-2015, 07:42 AM
Lectrician Lectrician is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2013
Posts: 19
Lectrician is on a distinguished road
Default

Umm. OK. I have created a template in the startup folder and run the macro from there.

Anything that was on the server is still showing up as "normal", but some older documents in the same folder are showing the path as "c:\templates which is where they used to be before moving to the server. Also, anything saved recently is showing up as "\\NEWSERVER\tempates", so the macro is working.

When I run the macro now, it cycles through the files, but doesn't seem to change anything when I check the files. The loop also ends early, near the end with an issue with the datestamp of the file by the looks of it.

I also notice some are template.dot, and some .dotx.

They are old files that I don't really need, but it is nice to be able to look back and open them. If you fancy a donation by Paypal, would you be interested in doing this for me?
Reply With Quote