Save workbook to a server

[dswiders]

I currently have a macro and it saves the file that the user is
working on locally on their hard drive. I would like to make it so
that it is saved to our server. In the code I specify the location
for where I would like to save it:

ChDir "O:\DATA\......"

However when the macro runs it always saves the file to the local My
Documents folder. Is there anyway around this or is it not possible
to save a file to a server like this through a macro?

 

[Dave Peterson]

I wouldn't bother changing the directory, just point at the drive/folder in your
save:

thisworkbook.saveas filename:="o:\data\" & somefilenamehere, ...

 

[dswiders]

I wouldn't bother changing the directory, just point at the drive/folder in your
save:

thisworkbook.saveas filename:="o:\data\" & somefilenamehere, ...

Thank you for your help it worked just as I need it to.