Jet Engine Excel Error?

[daint]

I have have made a VB program to access both a MS Access database and a MS Excel file. However, when the sheet names on my Excel file have spaces in, my VB prog gives me a error

'the microsoft jet engine could not find the object ....'

I know I could just rename the sheet, but this would defy the whole point of my program.

I am using Excel 8.0 data type in VB and an Excel 2000 file, would this cause any problems?

Any help would be greatly appreciated

Thanks

Daint

 

[petermeachem]

I would think that when you open the excel thing then you need to put either square brackets or quotes around the name. Otherwise the software does not know where that name starts and ends. Peter Meachem
peter@accuflight.com