Trying to use SaveAs in VBA but not working, please help. 1

[vamoose]

Can someone please tell me why this does not work. What is does is clear the value in sheet1, cell B7 and then saves it as C:\Winding\.xls
The value in sheet1, cell B7 is a string value. Excel 2000.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheet1.Range("B7").Value = X
Application.DisplayAlerts = True
SaveAs "C:\Winding\" & X & ".xls"
End Sub

Thanks so much.

 

[easyit]

You're in a ms access forum.



But you could checkout "option explicit" with help (F1),
Your declaration of variables is not proper.