| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook name is read only property?
On Wed, 23 Apr 2008 08:43:04 -0700, Jim Thomlinson wrote:
The workbook name is the file name and ultimately that is controlled by the operating system. What you need to do is to save the file using the new name. wbCty.SaveAs FileName:= thisworkbook.path & "\" & sCity Thanks, Jim, worked like a charm! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Range.ServerActions Property displays read-only data | Excel Programming | |||
| Reading back a Read/Write Property | Excel Programming | |||
| E-Mailing a File but property set as Read Only | Excel Programming | |||
| Network access to file - read only property | Excel Discussion (Misc queries) | |||
| Recommended Read-Only Property | Excel Programming | |||
Threaded Mode
