Recent content by alap43841

Thanks for your support............

Sorry bro, I know nothing about coding, I got it from the web and using it with little modification or as it is..........

Definitely there are problems with the site and i don't know what is that. I only I need to get data for my database to analyze my stocks. I got this alternative address from my friends. But my point is not that why the web address changes every time, I need to make it easy if the address is...

DCrake, giving you trouble again............what should I do if the text is tab delimited? What should I change in the code.......thanks

Earlier the the Address of the web-page was: h t tp: //w w w .dse bd.org/ latest _share _price_all.php Now it does not work, and changed to this one: h t t p: // web.ds e.com.bd/admin -real/latest _share_price _all.php Again it (h t tp: // web .dse.com.bd/admin-real/latest _share _price...

Thanks, I will do and provide you necessary DB as asked shortly................. :)

darbid, thanks for your reply, the web page that I extract behaves funny many a time and address is changed without any notice, I then look for new address and change the ie navigate property manually. I want to have table with two fields "WebLink" and "LinkID". If the address is changed I want...

Thanks for your reply, actually I am extracting data as delimited text file which used as liked table, Could you please be little more specific as to how to do this? I am not an expert on VBA, thanks

I am extracting data from web page that is used as table in a database. The address of the webpage changes frequently, I want to store the web address in a table and get the web address for the ie object from from the table. Dim colTables As Object Dim strDocHTML As String Set...

I have a database where I save web page contents in txt file as delimited file which again used in the database as linked table. I am not a VBA expert, I searched around the net and got those codes to execute my requirements. I need to save more than one page during the form loading. The...

I need to extract data from web to analyse financial performence of various companies for trading stock. The web address is http://www.dse.com.bd/company_details.php?name=AFTABAUTO, please notice that I need to change the last part of the web address to get data of other companies, for example...

DCrake, thank you very much, it works great :)

DCrake, there is a problem I am facing that is the last record set of the text file is not imported to the database. The text file has 212 record set but in database table there are 211 records..........I am attaching both a sample DB and the text file, can you please help.............thanks

Thanks DCrake and Smiler for your response, I found a solution in the net http://www.dbforums.com/microsoft-access/1004019-locating-duplicate-records-memo-fields.html to remove duplicate records of memo field, tested and working great so far, query statement that is given by Smiler creates...

I download a text file from the net that has 7 days news and every time the file is updated whenever there are some new news, but it contains only 7 days news. I need to download the file every day whenever new data is added and put it the MS Access database table where "Symbol", "News" and...