| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook.save
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save each sheet of a workbook as its own workbook | Excel Discussion (Misc queries) | |||
| Shared workbook - to save or not to save | Excel Discussion (Misc queries) | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| How do I save a workbook as a new workbook by using macros? | Excel Discussion (Misc queries) | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
Threaded Mode
