Are the two different machines the same operating system?
Are the two different machines using the same version of Excel?
What is the error when you try Intellisense on the Workbooks object in TestComplete?
The reason why I ask these questions is that, using your same code on Windows XP SP 3 with Excel 2003 installed, I get no errors and intellisense actually comes up just fine on the Workbooks object.
Also, what does the rest of your code look like? It's almost like your Set statements aren't working correctly. Are ExcelApp and Logbook properly declared with "dim" statements within the subroutine?
Since I cannot reproduce your problem, this might take a bit to figure out what's going on so expect a lot of questions. :-)
You might want to take a look at the following thread on the official forums as someone else seems to be having similar problems.
I believe I'm local admin (I can install and remove programs).
<font class="small">Code:</font><hr /><pre>
sProjectPath = project.Path
aTmp = Split(sProjectPath,"\")
sStorage = ""
for i = 0 To (Ubound(aTmp)-3)
sStorage = sStorage & aTmp(i) & "\"
GetDataFolderLocation = sStorage
DataFolderLocation = GetDataFolderLocation & "Data_Folder\"
'Msgbox (DataFolderLocation & DataTableExcelFile)
DataTableTitles = GetExcelTitles(DataFolderLocation & DataTableExcelFile)
Set ExcelApp = Sys.OleObject("Excel.Application")
Set Logbook = ExcelApp.Workbooks.Open(DataFolderLocation & DataTableExcelFile)
Set Sheet = Logbook.Sheets(1)
Here's a question... perhaps we're going about this the wrong way...
You say you're using these routines to get data from the spreadsheet at the beginning of your tests. Is there a reason why you are not using the DDT.ExcelDriver to get the data from the spreadsheet? The only reason I know of to use the OleObject for the Excel sheet is if you're intending to write out to it as well.
Automated Testing Evangelists
Definition expert - noun - Unknown drip under pressure