E
exceluserforeman
Thought I would make a comment ...
Did you know there is no Path property for a New Workbook ??!!!
Did you know there is no Path property for a New Workbook ??!!!
C
Chip Pearson
Of course the Path property is empty for a new workbook. What
would it be?
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"exceluserforeman" <[email protected]>
wrote in message
news
[email protected]...
would it be?
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"exceluserforeman" <[email protected]>
wrote in message
news
[email protected]...
E
exceluserforeman
Thank you for your response albeit empty!
The new workbook path could have been at least be C:/Temp
I wrote a little utility that allows the user to switch workbooks that are
opeed, and sheets. Its basic design is to allow a user with too many
workbooks opened awith too many sheets to view reasonably. I also added a
label to show the activeworkbook path. However, when the user adds a new
workbook, the path is nowhere. I wrote a msg warning that tells the user to
save the new workbook otherwise the utility (ie comboboxes) will not update.
It was just bothersome to have to include this factor.
You can try it out if you want to at:
http://www.geocities.com/excelmarksway
regards
- - Mark
The new workbook path could have been at least be C:/Temp
I wrote a little utility that allows the user to switch workbooks that are
opeed, and sheets. Its basic design is to allow a user with too many
workbooks opened awith too many sheets to view reasonably. I also added a
label to show the activeworkbook path. However, when the user adds a new
workbook, the path is nowhere. I wrote a msg warning that tells the user to
save the new workbook otherwise the utility (ie comboboxes) will not update.
It was just bothersome to have to include this factor.
You can try it out if you want to at:
http://www.geocities.com/excelmarksway
regards
- - Mark