webpage

Hi, i have list of hyperlink in my excel. Each hyperlink will open a webpage. I have to download the webpage as pdf format. Please help me how to run a macro to download all the pdf copy from the webpager after clicking the button.

Good Day I have a spreadsheet with multiple tabs. 3 of the tabs are created as dashboards and saved as a web page with the option to auto republish every time I save it. A week ago I added some new info on one of the dashboards. Ever since I did that the size of the dashboard is so big that...

So here goes. My workplace has an automatically generated webpage that puts up production values. I have exported this page to an excel sheet and set it to refresh automatically. I would like to pull a 2 points of data from the webpage, the number of cans and boxes. Basically to be able to...

I have a list of info in a spreadsheet and i need to get it into fields on a website. I thought sendkeys might be useful as cell A1 needs to go into one field, then there are 3 tabs before B1 needs inserting and so on....... However, if I have the spreadsheet and the webpage visible at the...

Is this possible? Many thanks.

Hi all Can someone please give me some simple VBA code that loops through all the tables in a webpage? I would like to the debug.print the contents of the tables. Thanks in advance. Regards Jim

Hi Is there a way to get the webpage xml (right click on a webpage and - view page source) ? tnx

Hello everyone Basically there are word documents stored on a webpage that I would like to extract information from and put inside an excel table. I already have a code to loop through word documents of a given computer folder path to extract information from them and I want to be able to do...

Hi, I am generally familiar with accessing elements on a webpage using VBA. However I am struggling with the DELETE button on the Kijiji website. Please click the following link to the screenshot (I am not sure how to get the image in the message itself). As there is no id identifying the...

Hi Friends, I tried finding VBA code on MRexcel forum. But did not find suitable one. A VBA Macro to extract whole webpage data including hyperlinks for example url: https://www.dice.com/company/07960AP <colgroup><col width="64"></colgroup><tbody> </tbody> Not only from this website, I...

Hi I've googled around a ton and have tried out a few examples but just can't make head nor tails of any of this, I'm self taught with both vba and excel and this just isn't my area so sorry if I'm being stupid. I want to feed the macro a permalink to an item page and for it to give me back...

Hi Friends, I am trying to choose a date from webpage, by date picker calendar and fortunately reached for a mile with my current code, _________________________________________________________________________________________ Driver.FindElementById("validtill").Click d = Sheet1.Range("BA2") n...

Hi guys, I am newbie to html and web data scraping using vba. I have no problems getting data from a table on the webpage, but I bumped into two issues. On the webpage, it only shows one page of table data, at the bottom I can click page 2, 3 and NEXT. Using control+U to see the html codes, I...

suppose i have a table on excel sheet like this sl n. account no. arrears 01 1234567890 02 2456981000 & so on i want to search these acc.no on webpage www.uppclonline.com/paybillhome and update the respective cell of arrears please help me about this.

Hello, I want to ask question about how I can get data from a javascript based webpage with vba code. I want to enter one input data (text) to a textbox and then click on button and finally get the results. I can get data from a normal HTML webpage but in java based webpages i cannot . The html...

Currently VBA logs me in and navigates to webpage with entry fields. (first of all, maybe I am not using right src to call on elements, since there are iframes. IDK) Then I need to enter text (numbers and letters) into different entry fields. So basically need to automate info from Excel cell to...

I am very green to VBA. I learned online by reading through forums and watching YouTube. So please be descriptive in your response. Or just respond bc I need help lol So I am using code below to navigate to a company site and logging on. This works fine and takes me to homepage. Now I am...

Hi guys im trying to control an webpage that is already open but so far im not able to get it to work. here is what I have: Sub google() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As New MSHTML.HTMLDocument Dim HTMLRows As MSHTML.IHTMLElementCollection Dim HTMLRows2...

I have successfully imported a table no problems here...now the tricky part. Each row contains a hyperlink to a project page, which in turn has a hyperlink to a project - organizations page. Coincidently, on the project - organizations page there is a next button so it is also easy to jump from...

I have been saving some webpages in a folder on my desktop. The path of this file (the saved webpage in IE) will now be the local folder address. To find the orginal site from which this page was downloaded, this info is available in the "View Source" under the '< meta property="og:url"...