August 11th, 2009, 01:15 AM
Have you opened the database with connection string?
also you havent declared rst3.
Declare them(Use Option Explicit).
August 10th, 2009, 02:07 AM
Its resolved. One of my columns had space at the end.
Thanks for the info but Datamiser please tell me your method.
August 9th, 2009, 11:37 PM
you can use internet explorer object to do the same in VBA.
Dim IE As InternetExplorer
Set IE = New InternetExplorer
you can use multiple objects to access...
August 9th, 2009, 11:31 PM
can you tell me about your method? i can change my code accordingly.
a small code snippet would be really helpful.
August 9th, 2009, 10:48 PM
Tried both adUseClient and adUseServer. still not working.
I get following error;
Runtime error '-2147467259(80004005)':
Method 'Open of object ' _Recordset failed
August 7th, 2009, 05:36 AM
instead of range user cells(row,col).
Here you provide integer as row and column.
eg : for B you use 2, c 3, etc
August 7th, 2009, 05:30 AM
You can import text file in excel. after importing it, you can do a find for your product and copy to the required sheet.
August 7th, 2009, 05:25 AM
I am writing a code which extracts data from a msaccess database to create certain report. For this purpose I wrote couple of queries and tried them in msaccess. One of the query has multiple...
April 22nd, 2009, 07:54 AM
you can use HTML DOM for this.
you can look at the html source and find out following three things;
1. userid text box id
2. password text box ix
3. the button you click to autheticate...
March 25th, 2009, 12:44 AM
thanks dglienna for all the help.
March 24th, 2009, 09:10 PM
one more help please, can you tell me the name of freeware DOM inspector?
March 24th, 2009, 01:20 PM
this is my requirement;
1. i have to login to somesite which requires user authentication.
2. then i have to give some unique id like transaction id or req id and press search.