| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
workbook.save
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
workbook.save
Is the workbook opened in readonly mode--either marked that way (in windows
explorer) or opened as readonly or even located on a path that you don't have write access to? And you're sure the workbook is opening as a workbook--not a template (based on that workbook???). wrote: 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 -- Dave Peterson |
| Reply |
| 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 | |||
Linear Mode
