Need help coding a "FileName" "SaveAs" to a specific serving location

Posted by DLM on March 22, 2001 11:03 AM

Hi.
This is probably so simple, I've tried a lot of statements, and cannot solve it.

I have an Excel workbook that contains VBA code to save the workbooks based on the cost center.

This is the save as statement:

tfile.SaveAs FileName:="CC" & Cell.Value & ".xls"

Now all I want to do is send it to a server drive and a specific location. For example,

n:\prime\blink\worker

Any help would be greatly appreciated.

Posted by Barrie Davidson on March 22, 2001 2:56 PM

Change your Save As statement to read:

"n:\prime\blink\worker\CC" & Cell.Value & ".xls"

Drop me an e-mail if this doesn't help.
Barrie

Posted by Dave Hawley on March 22, 2001 10:30 PM

You may need to use:

ChDir "n:\prime\blink\worker\CC"

Dave

OzGrid Business Applications