Hi Raj,

If you post your code, it will be easier to help.

---
Regards,
Norman



wrote in message
oups.com...
Hi,

In a visual basic macro, I am opening a workbook (workbooks.open
filename := abc.xls), making a change to .sheets(1), renaming the sheet
and trying to save the workbook via .save. But the saveas dialog box
appears. Why? The workbook already has a name (abc.xls). I am using
window xp and excel 2000 versions.

Thanks for any help.

RK