How do I get,insert data from a excel spreadsheet??

# How do I get,insert data from a excel spreadsheet??

Johan,

        You don't say which version of VB you are using.  This applies to
VB4-16.

        I notice that when I search for Excel in the help file there is an
entry "Excel, accessing...".  However, if I follow that, the only
topic I get is for a Code Window.  Bad pointer, I think.  What I did
find was an entry for 'accessing data in Microsoft Excel worksheets',
which brings up a topic of the same title.  Anyway, this page should
answer your questions.

                                        -- Bill Clay

We have an Excel 5 spreadsheet that is linked to other files which are
being continually updated.  I have written a module that updates the
links, but I want to run this from a VB5 app.  The app runs various
processes and needs to update the links in the spreadsheet.

My approach has been to GetObject the spreadsheet and try to use an
object method to run the Excel module, but I'm not having much success.
Any suggestions?

Thanks in advance.

Steve Hanvy