Hi all,
I hope someone out there can help. I'm having a little problem with one
of the projects I'm working on, and was hoping someone out there has had a
similar issue and knew how to deal with it.
I've been asked by a client to produce a share price page which draws
information from another specified website. My first solution to this was
to use Excel XP to create Web Queries, and then to pull that information
into a web page using ADO. This has now been achieved and works fine, but
the problem I do still have is that the information in the Excel file will
not automatically update unless opened by Excel, so all I have at the
moment is a web page that imports static information. Does anyone out
there know how I can get the information within the Excel file to update
upon pulling it into an ASP page? Or perhaps another way to get at the
dynamic information from one website to another?
Thanks for any help you may provide,
Lee