get data

Hello - I’ve been tinkering around with a sheet at work and I’ve been using various sources for getting data into a specific sheet so a group of 50 people can use. The best way I can query my data is through Microsoft exchange and applying filters to a specific email with excel attachments...

i want to get ID video from facebook using vba selenium on this page https://www.facebook.com/reel/ my code Set ch = New Selenium.ChromeDriver ID = ch.FindElementByXPath ("//div[@class='x6s0dn4 x18l40ae x5yr21d x1n2onr6 xh8yej3']").Attribute("data-video-id") the problem is class...

I am trying to find a way to create a button that will upload data from a pdf file. I am familiar with the "Data>Get Data>From file>From pdf" way of importing the data and am simply trying to create a button that allows the user to open the display that allows them to select a pdf file to...

Hi, I want to use the "Get data from Web" built in function. The website requires a log-in, and everyone who uses the excel arc is logged in, in Chrome. My first question is, when the navigator browses the web, can I set it to use Chrome, so everyone is logged in automatically? Or, can I...

Good morning, I am trying to get data from an excel file saved on Sharepoint, but I get the error message 'We couldn't authenticate with the credentials provided' when trying to connect anonymously. I am using Office 365. Does anyone know how to grant anonymous access? Many thanks, Paul

Hi everyone, I'm in the process of building a PC and as some of you may know, there is a big shortage in computer components. This has caused prices to be sky high and finding a deal means trawling through websites for various parts. As a result of this, I've decided to create an excel...

Hello there I need to make a excel document where i get live updated data from another excel workbook. im struggling with using the Data -> Get Data -> From File -> From Workbook. my problem is that it seems like i need to have the first document closed down in order for the second document to...

Hi Everyone, Hope you all are doing great. I want to keep importing 5 columns of data from Sheet A to sheet B, whenever I open sheet B. Though I can write simple macro for it, but I think there is an easier route as well through excel connections, importing data from an excel file is...

Hi everyone. I'm trying to create a Master Excel sheet that stacks up multiple children spreadsheets that have the same set of columns. I can easily do that using power query or the Data tab in Office 365. However, the problem is I may want to add or remove columns of the children sheets later...

Hi! I'm trying to build a reporting tool via Power Query that combines data from multiple .xlsm files in a folder. Excel "Get Data -> From File -> From Folder" looks to do just that. After getting familiar with the concept on my local drive I tried to load the same files from a network drive as...

I have used Excel VBA to navigate to a web site. I am trying to pull data from a specific part of the website. When I inspect the element the following is displayed: <span id="Status">Ready to Drop Ship</span> Does anyone know how to get the data "Ready to Drop Ship" from the above HTML code...

Experts, I have a macro, GetExcelData (), that retrieves the contents of a single worksheet from a workbook located in a network folder. User clicks a button and, presto, the needed data is deposited in a new worksheet in my affected workbook. Works famously. However, because the macro, based on...

I am trying to figure out how to continuously pull data from multiple excel files, but not allow excel/query to change manually edited values back to source values Example: I have June, July, August files. I pull these files from folder Sample data is <colgroup><col width="64" span="4"...

I'm looking for a solution that would use the Get Data function in excel to query and combine all files that reside in a Sharepoint document library. I'm able to connect to specific files but the number of files in the document library may change over time (expected to increase). Is there a...

Hi, I have previously added some rss feeds into an excel document (using the Get External Data Function), so there is a nice looking table present in a tab. I now want to add a similar rss feed into a different tab - simply changing a geographic location in the url. However, I can't for...

Hi, I currently have 2 spreadsheets, where I am using the "Get Data" function to pull data from one to the other. One of the columns I am pulling through contains "hardcoded" hyperlinks (not using any formula), where the content of each cell is the name of a file, and the hyperlink to said...

Hello everyone, I'm going to complete my simple application relating to creating new workbook, copying data sets from the workbook where I run my macro, pasting the set to the new one with possibility to point out a path. Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As...

Is there is any possibility to paste data from one sheet to another sheet(That is hidden) I have a vba code to copy data from one workbook on particular path and i have to paste that data into another workbooks sheet 6 but the sheet 6 is hided Thanks in advance Azhar

Hi guys, I have the attached billing template. Now, I need to make a summary sheet for it. This summary sheet would have a name filter. For example, if I filter "Joe's" name, it would show data for Joe from all other worksheets. Can you please help me with this? By the way, I can't post the...

For many years now, I have been using INDIRECT.EXT through MoreFunc to pull information from an external documents. I have just upgraded to Office 2016 (from 2007) and have discovered that my documents no longer work. So I need a replacement. One of the big uses was in our budget. The salary...