Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am opening a workbook using the following code:
Set wb = Workbooks.Open(strFullFileName, 0, False, , , , True) where strFullFileName is the full path and filename of a workbook. When the workbook opens, its name has an incremental suffix such as MyWorkbook12 if it is the 12th time the MyWorkbook file was opened. Unfortunately, this incremented name is what is used when the workbook is saved using a wb.save statement, causing multiple copies of the workbook to be created. What is causing this behavior? I suppose that there are cases where this behavior was desirable, but I need to open and resave the workbook with its original name. TIA for any help, TK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Increment | Excel Worksheet Functions | |||
Automatically increment numbers in a cell when you open workbook | Excel Discussion (Misc queries) | |||
increment a value by 1 | New Users to Excel | |||
Increment/Increment letter in alphabetical order | Excel Programming | |||
how to auto increment a number each time i open the worksheet | Excel Worksheet Functions |