import data

Hi, In my worksheet, I would like to add a macro which does the following at once: 1) refresh the active workbook, 2) clear the contents of a specific worksheet, 3) import columns data from a closed workbook, 4) refer to the path of the closed workbook based on cell data in the open workbook...

Hi guys. Okay, so I have a potentially really tricky one here... I have a design software, in which I can export a design to an item list in either a standard .txt Text document, or an overly detailed XML Document. Whilst the software allows me to specify what information to export to the .txt...

hi I have some code which has been working really well importing data from other files into a central file. Here is the code...

Hi, I have a lot of data sequences I need to statistically analyze. The problem is that the numbers are separated by a space character. I need each number to be in a different excel cell. Is there a way to tell excel to use the space as "move the next number to a different cell"? For example...

Hey Guys (and Gals), I currently have a daily report that imports data (in table form) from a file that is placed into network folder every morning (I did this using Powerquery). So, everyday I go into my report, hit refresh, and the table is automatically updated from the file sitting on the...

Hi All, I have a SOURCE workbook I use for Order Management and when I submit the form data to the sheet, it also submits it to a closed, HUB workbook on a shared drive. There are 6 other people using this. The HUB workbook has everyone's work. When you open the SOURCE workbook it will ask you...

Hello I'm using this board quite a few times but I never posted a question. I'm working on a special project in my company and for this project we use excel and vba code. We got a strange behavior. With VBA we import data from other workbooks into the main workbook. This tooks about 30s for...

Excel 2016 - I have an Excel file that imports a table from SQL Server via a connection created with the Data->Get Data->From Database->From Sql Server Database. As part of the Advanced Options while creating that connection I included a SQL query that basically reads: SELECT...

Excel 2016 - I have an Excel file that imports a table from SQL Server via a connection created with the Data->Get Data->From Database->From Sql Server Database. When I built the file, I imported the latest information from the SQL table, which created a table automatically in Excel, and then...

Hello, Trying to import data from a website.(www.motionindustries.com) I have a spreadsheet with multiple links to specific products.( ex. https://www.motionindustries.com/productDetail.jsp?sku=00544513) How an I make Excel click on the link from spreadsheet, copy data from website( price...

Hello, I want to pull some financial data from a website. Google Sheets has a fantastic function for grabbing data from tables. In my example, I want to pull the balance sheet for a specific company. Here is a link to the Google Sheets' example Is there an Excel equivalent? I tried getting...

Hello there, I have a folder containing 3 files : my Excel file (with my macro), Book1 and Book2. I would like to create a macro to import automatically my two ".xlsx" files (Book1 and Book2) in my Excel file. Data from Book1.xlsx would be placed in Sheet1 and Book2.xlsx in Sheet2. I also want...

Hi I'm having trouble importing multiple XML files to excel at once. Does anyone know if this is possible? I have been able to import one file at a time (however, this is importing the one file ~15 times) but not multiple XML files at once. I have been using the following procedure: Data >...

Hi all, I am new to VBA and have been facing a lot of trouble with figuring out how to pull data from the website boxofficemojo.com. I am trying to extract weekly data for the years 2010-2015. So i found a code that did something along the same lines and changed it to suit my needs. It is as...

Hi All, I am importing some data from a .txt file but the import data's first and last lines are un-important headers and totals which get in the way of how I am using the data. Other than having to manually delete them on each refresh what is the easiest way of automatically deleting them on...

hey guys: i was trying to import data from internet to an excel spreadsheet by using the command query. With Sheets(1).QueryTables.Add(Connection:="URL;" & miurl, Destination:=Sheets(1).Range("a1")) .BackgroundQuery = True .TablesOnlyFromHTML = False...

Hi, I have a worksheet with a series of clickable hyperlinks to a webpage with the information I am after. Is there some code to loop through each hyperlink and import the data from the webpage that it opens? All my Hyperlinks are in column B however some cells are blank so I would like the...

hi, I currently have a growing excel sheet. I copy/paste daily information and use it to feed into multiple pivot tables. My concern is that the spreadsheet is growing and constantly causing issues. I have to do a lot just to maintain the spreadsheet. At this moment we cannot import data from...

I have 2612 addresses and need to import the owners address into the excel file.Trying to do it one by one is hard.Please help if you can.Here is the website to find the info and the example of the addresses i am using. Pinellas County Property Appraiser a few addresses and the columns they...

Hello guys! Could you please give me any tips on how to extract the data on this site Market data | Nord Pool Spot to excel 2010? The table is dynamic and updates every hour so I want the new data be imported to excel aswell. many thanks Mikael