Excel Save problems

[dezian]

I need to save a spread sheet to a specific directory using the value of a cell as the file name, the code below refering to the cell value to be used works, but the saved file is saved to the drive I am currently working in and not the directory path in the code below. Any help would be much aprieciated.


Sub savefile()

ActiveWorkbook.SaveAs FileName:="S:\WGSpecChemOps\QC Analytical\Facility 2\CERTS\2003\" & ActiveSheet.Range("I7&quot.Value & ".xls"

End Sub

Cheer Andy

 

[xlbo]

nothing wrong with the syntax - if you have more than 1 workbook open, however, it may be more advisable to use Thisworkbook.saveas etc etc etc

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[combo]

According to help file, if you don't include a full path, Microsoft Excel saves the file in the current folder. So, check the FileName:
Msgbox "S:\WGSpecChemOps\QC Analytical\Facility 2\CERTS\2003\" & ActiveSheet.Range("I7&quot.Value & ".xls"

combo

 

[xlbo]

do you have any "on error resume next" in your code previous to calling the save sub ??

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[dezian]

Xlbo, I get no error message, the file just happily saves its self to the directory I'm working from.

Cheers Andy Hickson

 

[mscallisto]

Is S:\WGSpecChemOps... expected to be a mapped drive?
If so is it really mapped to S: ?

Just a guess.

 

[mscallisto]

I tried it and it worked just fine as long as the mapped drive and path exists