Thought I would make a comment ...

Did you know there is no Path property for a New Workbook ??!!!

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"
wrote in message
...
Thought I would make a comment ...

Did you know there is no Path property for a New Workbook ??!!!

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




"Chip Pearson" wrote:

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"
wrote in message
...
Thought I would make a comment ...

Did you know there is no Path property for a New Workbook ??!!!