Is it possible to use the OWC spreadsheet in VB?

L

Lyndsey

Ok I know I can use it... but I'm trying to load an Excel
file into it. I can't seem to get this to work, it
doesn't seem to have any properties to allow the source to
be set to an Excel file. And the HTMLURL is only good for
web pages isn't it??

Help!!!!!
 
S

Sue

I tried this and couldn't find a way to do it either. I
wound up using the Excel object instead. Of course, I
think that requires Excel to be installed on the computer
that's running your VB program.
 
A

Alvin Bruney

The excel spreadsheet cannot load xl files. One option is to convert it to
csv data and then do a CSVDATA load into the spreadsheet. The spreadsheet
requires special formatting tags to enable xl files to load. Xl does not
provide these tags in its schema so the load will fail

Alternatively, you may be able to write out the file to xml append the
special work book tags and load using XMLDATA. It is quite a pain in the
budgetsky so your easiest option is csv.
regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top