I am trying to run an application where I import data from an excel spreadsheet. While this works fine in the uncompiled version, when I make an exe I am given the above error and told that the application can't find the worksheet. The offending excel worksheet is called 'HiddenResults', and the code is given as follows:
If MsgBox(sMsg, vbYesNo, "Import Results"
= vbYes Then
sSheetName = App.Path & "\" & sFile
Set dbExcelSheet = OpenDatabase(sSheetName, False, True, "Excel 8.0;"
Set rstHiddenSheet = dbExcelSheet.OpenRecordset("HiddenResults$"
Else
Exit Sub
End If
Any help will be much appreciated.
Seosamh
If MsgBox(sMsg, vbYesNo, "Import Results"
sSheetName = App.Path & "\" & sFile
Set dbExcelSheet = OpenDatabase(sSheetName, False, True, "Excel 8.0;"
Set rstHiddenSheet = dbExcelSheet.OpenRecordset("HiddenResults$"
Else
Exit Sub
End If
Any help will be much appreciated.
Seosamh