Name Increment on Open
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
|