element

Hi, I am new in data scrape via VBA. I want to get my order history over amazon. I can get all the info from html table with the code below. However, this code gives td elements in a single and it is hard to parse it again. I attached the html code of web page and highlight the info I want...

Hello, I'm wondering if it is possible to store more than one number in an array. I'm hoping I can reduce the size of my large score sheets by storing the scores of each student in one cell where for example the first element would be math score, the second physics score, the third chemistry...

Hi all, Looking to return values from multiple headers in an excel sheet. I have the following table for illustration: Ideally in 'column 8' i would like to pull the value from the merged header. The problem is there are multiple merged headers running through the sheet. For illustrative...

I need to do this in excel with vba for school. Create a subroutine Factorial(n) that creates an array of size n. The first element ofthe array is 1. The next element is 1*2. Next is 1*2*3, etc. Formula: for n>1, ifelement ‘n’ is x then Xn = Xn-1 * n. For example, Factorial(6) creates this...

I'd like to create something similar to the Excel Styles ribbon item, that looks like this: I thought it might be a gallery, but when I try that element, I get something that looks like this instead: How can I have this box to display the contents, with a button to expand? I may have only...

Hello, just after some help with one element of my coding, all the rest works. I have effectively built a hierarchy of conditions for rows on a excel spreadsheet that i want to populate a summary tab. all works fine apart from this element, which does not error, it simply does not pick up...

Hi everyone, I am finding myself in this problem I can't solve. I have 150 sets, each of which has multiple element inside i.e. Set A -1 -2 -3 -4 Set B -1 -3 -10 -20 etc. Now, I would like to create a matrix with the sets in rows and colum and for each intersecation I woudl like to count...

When I change: gCellCurrVal = gCellCurrVal & "," & Me.ListBox1.List(ii) to this: gCellCurrVal = gCellCurrVal & vbNewLine & Me.ListBox1.List(ii) in the code below, rather than just changing the way the selected values are represented (separated by a new line instead of separated by coma) the...

Hello How to leave only letters (element symbols) in a range of cells. The range begins at E1. Each element (Ex. Al240 %) is one cell. Make this: <tbody> Al240% As189% B208% C165% Ca393% Co340% Cr267% Cu327% Fe249% Mn_Calc. Mo386% Nb400% Ni341% P177% Pb220% S180% Sb206% Si_Calc. Sn326%...

Using VBA, is it possible to change the RGB color (say green) of a selected element within a smart art object (say Org chart). I know that we can do it if we know the element number - how about an element selected at random? Please advise as soon as possible.

Hi Everyone, First time poster here although I've been referencing many posts from this forum for years. So much great info here. I'm trying to submit package info to the UPS site to automatically return the shipping rates. For a single package I'm able to do it. When trying to set up for...

Hi. So I just recently learned about the LOOKUP formula and it's use for finding the last non blank cell in a range. For reference, I was looking at this explanation: https://exceljet.net/formula/get-value-of-last-non-empty-cell So the formula that's returning the last non blank cell...

I have this code that takes data from a html element by Id, the ID in this case is "MainBody_lblBankDetails" It then displays it in a message box. Private Sub CommandButton7_Click() With CreateObject("InternetExplorer.Application") .navigate...

Hey, I would like to detect if a webpage element reacts to being clicked, if it doesn't react to being clicked using .click - I'd like to use fireevent to finish the click. I'm unsure how to determine the element has or has not been clicked. Is there a way to do this? Thanks!

Hi, I saw this visualization in an Excel file. Trying to plot the element inside the red circle. Do you know how can I plot that? Thanks

I have a column of data that includes date/time in a text format (Dec 28, 2016 10:32 AM). What I would like to do is use a formula to return just the date element of the field (i.e. 28/12/2016). I've tried using the INT and DateValue functions, but I just get a #Value ! error. All help appreciated.

Hi all, I have over 500 spreadsheets which isnt formatted in the same way, I need to only capture the below column headers and associated data which can be in a row or column. URN Packaging Delivery Price I need to capture the data in the below format to build a database: <tbody> Urn...

I use a fairly simple vba routine to extract data from a table contained in an Outlook email body. The result is an array which contains 1 entry with 7 columns for each email. Here is a sample of one entry in the array: arrList(1,1) = "Sent: Monday, August 28, 2017 10:07:28 AM (UTC-06:00)...

Good day, I have a spreadsheet with 17 columns, "A" Column holding date and the various other columns holding data. I have a userform that is a 'display center' where I can pick and choose (through a YES/NO combobox) which columns to graph against time. So I can plot just one of columns, or...

I created a macro that automatically populated different fields on a website / online application that'd then give me results based on my inputs (which I then would have to "scrape" the results for my Excel reports). Recently the tool just had an update to its UI so now when I click view source...