Application.Dialogs(xlDialogSaveAs).Show _
arg1:="Customer1"
ActiveWorkbook.Worksheets("sheet1").Range("a1").Va lue & ".xls"


- manges

--
Message posted from http://www.ExcelForum.com

Hi thanks for the advice but it won't work!
It says Compile error, syntax error
All I have done is associate the new details with my existing macro?
What am I doing wrong??

"mangesh_yadav " wrote:

Application.Dialogs(xlDialogSaveAs).Show _
arg1:="Customer1" &
ActiveWorkbook.Worksheets("sheet1").Range("a1").Va lue & ".xls"


- mangesh


---
Message posted from http://www.ExcelForum.com/

Difficult to imagine why you are getting the error. what else do yo
have in the code.

- Manges

--
Message posted from http://www.ExcelForum.com