by GaryRussell » Tue May 10, 2011 1:17 pm
Depends how the other sample sheet is set up. The COM interface can be used in a number of different ways. I am guessing that the sample sheet you are using expects to be linked to BA and uses a COM function in the update event of the worksheet. Therefore if it's not linked to BA then the worksheet is not updating and therefore the event is not firing and calling the COM function.
Please remember the COM interface is only aimed at users who can write VBA code otherwise it's not worth bothering with.