Load qurey from website.
Dear all.
http://www.photon.info/photon_site_d...dule_en.photon
I have database value from this website.I would like to update database or query into excel sheet .
How could i record the query or update database from website.
first sheet must contain all common peramter & other sheet must be loaded with typesection value.
Set reference to Microsoft Forms 2.0 Object Library and Microsoft HTML Object Library
This gets you the table:
If you go and play around with it, please note that the link is actually different from the one you posted
Please Login or Register to view this content.
Please click the * below if this helps
Just an Input..
Reference to Microsoft Forms 2.0 Object Library might not be available in the Post 2007 Version.
Below link will help you set it up just incase you run into an issue..
http://www.mrexcel.com/forum/excel-q...t-library.html
Cheers!
Deep Dave
I am using visual basic 2013 desktop version . I tried to run code using class library. I am getting below error.
Error 4 Type 'HTMLDocument' is not defined. C:\Users\AJIT\Documents\Visual Studio 2013\Projects\Testing code\ClassLibrary1\ClassLibrary1\Class1.vb 7 51 ClassLibrary1
Error 5 Method arguments must be enclosed in parentheses. C:\Users\AJIT\Documents\Visual Studio 2013\Projects\Testing code\ClassLibrary1\ClassLibrary1\Class1.vb 15 19 ClassLibrary1
Error 6 'ActiveSheet' is not declared. It may be inaccessible due to its protection level. C:\Users\AJIT\Documents\Visual Studio 2013\Projects\Testing code\ClassLibrary1\ClassLibrary1\Class1.vb 18 9 ClassLibrary1
Then why are you posting in an Excel Forum?
When i run code on excel in developer option i got this errorexcel.jpg
Add a blank userform to the workbook and then try it again
userform1 is blank form only. I checked form & its property the above library function being included already by default.
i added line after it start run . i found data not being recorded in excel sheet
Please Login or Register to view this content.
Last edited by ajit.nayak87; 09-24-2015 at 06:53 AM.
So it's working then? You're making this very hard work
Check Post #3When i run code on excel in developer option i got this error
Why have you added an extra line?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks