Trying to Save to A: Drive


Posted by S N on April 06, 2001 11:15 AM

I'm trying to get the following code to save to my A: Drive, but it saves to my C Drive (the default drive).

I'm obviously a beginner, can anybody help me out?

Thanks.

Cells.Select
Selection.Copy
Workbooks.Add
Cells.Select
ActiveSheet.Paste
Range("A1").Select
ChDir "A:\"
Application.DisplayAlerts = False
fn = Month(Now()) & "-" & Day(Now()) & "-" & Year(Now())
ActiveWorkbook.SaveAs Filename:=fn, FileFormat:=xlCSV
Application.DisplayAlerts = False
ActiveWindow.Close
End Sub

Posted by Barrie Davidson on April 06, 2001 11:27 AM

Try changing your variable declaration to:
fn = "A:\" & Month(Now()) & "-" & Day(Now()) & "-" & Year(Now())
You can delete the Chdir line.



Posted by S N on April 06, 2001 11:50 AM

That did it, thanks