My colleagues and I exchange workbooks with order/invoice records that are
installed (copied) in to each local database. We send them via email and its
very convenient to just open the excel-file from Outlook and install the
records. But there is an obstacle: If we put the installation macro in the
routing workbook, we get the trouble with security when running procedures
without digital certificates.
We have now tried to move the procedure to the main, local spreadsheet but
we then face another problem. When opening workbooks with the same name
several times from Outlook, every workbook gets a serial number within
parenthesis added to the name as all of them belongs to the same temporary
directory in C:\documents and settings\....OLKE. When running the procedure
from the main workbook, the program does not know which other workbook to
activate as the name changes every time. Can anyone find a solution to
activate the (only) workbook starting with the name TradeRoute, skipping the
end of the name _(12) or _(13), etc.

You should always save any workbooks that you receive is a permenant
directory. The OLKE directory is a temporary directory and you WILL loose
any changes you make to these files if you don't save them else where. The
simple method is to open the e-mail and then save attachments. The save
attachments will go into you My Document Directory unless you specify another
directory.

"Mats Samson" wrote:

My colleagues and I exchange workbooks with order/invoice records that are
installed (copied) in to each local database. We send them via email and its
very convenient to just open the excel-file from Outlook and install the
records. But there is an obstacle: If we put the installation macro in the
routing workbook, we get the trouble with security when running procedures
without digital certificates.
We have now tried to move the procedure to the main, local spreadsheet but
we then face another problem. When opening workbooks with the same name
several times from Outlook, every workbook gets a serial number within
parenthesis added to the name as all of them belongs to the same temporary
directory in C:\documents and settings\....OLKE. When running the procedure
from the main workbook, the program does not know which other workbook to
activate as the name changes every time. Can anyone find a solution to
activate the (only) workbook starting with the name TradeRoute, skipping the
end of the name _(12) or _(13), etc.