Hi,

I have a subroutine written, to be run on various different machines.
This is to be run automatically as part of an overnight procedure, so
have it being called from a VBscript file. Of the form


Code
-------------------
Set xlObj = CreateObject("Excel.application")
xlObj.Workbooks.Open "c:\trinity\exchange.xls"
xlObj.Run "ExchangePriceImport"
xlObj.ActiveWorkbook.Saved = True
xlObj.ActiveWindow.Close
xlObj.Qui
-------------------


However, on certain machines this code fails, saying the macro canno
be found.
On looking in the workbook under toolsmacros, the name seems to be o
the form

exchange.xls!sheet1.ExchangePriceImport

However on other machines, opening the file shows the macro in the lis
as ExchangePriceImport only.

What is casuing this, and how can I stop the name being altered? a
this is stopping processes runing on certain systems.

Excel version is 2000 and they're all running the same service pack.

Thank

--
alex99
-----------------------------------------------------------------------
alex999's Profile: http://www.excelforum.com/member.php...fo&userid=1497
View this thread: http://www.excelforum.com/showthread.php?threadid=26602