How to read and write Excel worksheet throught VB6

[ShivaPillai]

Hi all,

I am trying to reand and write an Excel worksheet through
vb6 but i don't seem to working. could anyone help me on this. My development pc has MS excel 10.0 library and the
client pc has no vb6 but office 2000.

Thanks

ShivaPillai

 

[Genotix]

Try to use this piece of code.
It helped me out very well.

http://www.freevbcode.com/code/VB2Excel.zip"]FREEVBCODE.COM[/url]

This is from a site i use next to this site.
In my opinion these two sites should be combined!

Linux IS userfriendly.
It's only very selective about who it's friends are.

 

[johnwm]

If you're using different versions of Excel/Office then you need to look up Late Binding. There have been several discussions in this forum (Advanced Search, at the top of the page), and some details in VBHelp

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

For tsunami relief donations

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts