webpage

while importing text from web page (to be refreshed later on), the alphanumeric values (0321418U, 04776181, 0876129P, 01242109) get converted to numeric (0321418U, 4776181, 0876129P, 1242109) ie prefix zero is removed. i want it as text only with zero prefixed.

I want to get an updateable data of some countries from the table inEconomic and financial indicators | The Economist in excel

I am new here, so forgive me if any information not specific. I got a task to download data from this webpage using VBA: STOXX 600 Historical Rates - Investing.com I want to have monthly, 5-year data, whereas the default values for the webpage are: daily and for 1-month. I can manipulate it...

Hi Guys, I'm trying to extract the website url and the country name from a webpage which is like this - www.xyz.com/startup/startup-name-1234/ So, everytime startup name & the number at the end of the url changes and it's recurring. Manually I did change only the number at the end of the url...

Hi everyone, I am planning to link a website with an excel file (rather than coding the formulae into PHP) so when a user enters the input values then the output from cell “A8” of the workbook should be displayed in the webpage. More details below – for example 1. In the web page you see...

I have a simple data listing that uses Autofilter that I want customers to be able to use on the web. In Excel 2003, I could Save As Webpage, click the add interactivity box and I basically had it. Except that users needed to have the Office Web Components installed to use it. Not everyone...

I am trying to create code that will navigate careerbuilder with internet explorer and apply for jobs automatically. I am stuck at Applying for the actual job by clicking the button which is input type. The code is below. Also I need to attach my resume which exist on my pc to career builder...

Excel VBA newbie looking to scrape property search results linked pages into excel. I have read a few of the articles here and viewed a few videos online to help me understand how this is done and gave it a go using this property search. The method I used was to save the webpage as a text file...

I'd like to import graphs from webpages to Excel. E.g. many webpages show intraday stock prices and I'd like to include some in a "dashboard" style worksheet that can be up-dated. Is this possible with Excel?

Hello All Bellow is the source code of the webpage. where i want to enter the city name through vba. Please help me on this. I am using Ie.document.getelementsbyname("city").Item.value = "city". Please help me on this. <tbody> <TABLE CLASS="Theme-Form"> <tr> <td> City...

My spreadsheet uses webqueries to get data from the internet, use that in calculations, and publishes it as a webpage. Works perfect, but the webpage only gets republished when I save the document. I would want for the pages to be republished on an interval, or better yet, the document to be...

I have an Excel VBA program that saves the Excel file every 5-10min. It also publishes a web page with selected ranges of cells. This works 98% of the time. Today I got an error that stopped my program and required me to click ok on the error box. It said "ERROR: Cannot access file in Excel...

Hello i need a macro that does the following 1. open URL from cell A1 (via Internet explorer) 2. (whilst on webpage) select all and copy 3. Go back to worksheet 4. Paste into cell b2 and ignore source formatting (I want plain text) i cant provide the URL, or the worksheet I am working on...

I have a user who was able to copy and paste data from a webpage into Excel and have the drop-down boxes appear as objects a few months ago. The objects in the workbooks from that time show =EMBED("Forms.HTML:Select.1","") in the formula bar when selected in design mode. Basically, we're...

Hi All, Thanks in advance for reading and giving your time. I am trying to access this page and automate search of lot#: "https://www.smarteda.qld.gov.au/pools/properties/propertySearch.action" I am using MSXML to do this: Sub Getlot() Dim xml As Object ' MSXML2.XMLHTTP Dim html As Object '...

Hi All, Thanks for looking at the post. I have written code to select all (from webpage), copy and paste (in excel sheet) in Excel 2007 and it is working perfectly. But when my client who uses this program on 2003 version, he gets Error 1004. "Class worksheet pastespecial' Following is the...

Hello, I am looking to pull information from multiple pages on one website (data extract is the term I have been seeing mostly) and am looking for a simple solution. Long story short the info I am looking to grab must be selected after going through a couple clicks. Ie Base webpage -> select...

I've got a list of movie names in column D and I use the following formula to search IMDb for the movie name in column D =HYPERLINK ( "http://www.imdb.com/find?q=" &D2 &"&s=all" , "IMDb" ) Is it possible to make Excel go to the link of the first search result within that webpage that...

I wanted to know the code for a macro to search and highlight multiple set words in a webpage and to open the highlighted word hyperlinks in the webpage? Note: In the process the website is same all the time but the webpage changes, so there should be an option so that macro code can be...

Hi, I have an excel sheet which consists of 7,500 locations. I need to put these locations one by one into this website Reverse Geocoding and get the geo-code for the same. Is there a macro code that I can run which will extract the geo codes ones by one and update the excel sheet. Have minimal...