import data

I'll start with my most important question, so as not to be a bore. Plus, I could probably learn from there. How can I get up-to-date bitcoin (sell, if anything) prices from the Coinbase exchange onto an excel spreadsheet? All the directions I've been reading are telling me that it'd be easier...

I would like to import data in an email on gmail to a spreadsheet in excel. what would be the easiest way to do this? any help would be greatly appreciated.

Hi: I am trying to import a .dbf file into excel. I saved it to my desktop and it says it's 372 MB - compressed size 56 KB. So, I imported, but there are more than 1 million rows, so I can only see part of the data. Can someone tell me how to import 1 million records at a time, so I...

Hi Guys, Here is the question, i am stuck with it. I have a workbook (lets name it Bag Inv. Nov 2014.xlsx) with 30 worksheets on it each worksheet is named as Nov 1, Nov 2, .... Nov 30. Each worksheet has inventory on it. so we use one worksheet each day according to the date. Now I have a...

I am getting a 4 part extract from an enterprise tool which come out in XML, that was irritating but I can work around that, but whats weird is that when I import the data into excel the fields are moving around (see screen shot). No one can seem to either explain to me why this is happening or...

Hi all, Want to import a text file in excel via macro, however I need it to do two things - first I want to select a text file (as the name changes every day) & secondly I want it to be imported with delimiters '|'. Currently I have something as mentioned below, however the below code only...

http://imageshack.com/a/img89/7038/vxps.png - sheet2 Welcome ! I have problem with importing data from in Excel. my data : sheet 1 - number of product (ID) and quantity sheet 2 - list of row materials and quantities needed to manufacture product (on photo - right column is number o product...

Hi, A former colleague of mine wrote the code below and has now left. I am wanting to modify the code so that it can repeat the macro over and over again. The limitations of this is that you have to go into each webpage one by one and paste it in, wait for the macro to run and then repeat the...

Hi, I am very interested in sports stats and am trying to import stats from multiple pages on the same website. For example in the below code it has game-93920 and the next page I would like to get the stats from is 93921. As each page has a unique code that is always 1 greater than the one...

I currently have numerous reports that I pull information into excel. An example of the forms is shown below. Is there a way to pull specific information, i.e. only the "Project Name" and "Sales Representative", into excel? We can assume that the file name to the word document is known, but vary...

What I want to be able to do is basically the same thing as opening up a file in a hex editor and then copying all of the hex data into a cell into a spreadsheet. The reason why I can't do that is because some of the files that I will be using have to much data to fit in my clipboard. popcornrulez

I'm having with an import that involves number that are sixteen digits long. They appear to come in from Excel in scientific notation and all I need on the Access side is a 16-character string that represents the original number. (I need it to be text because that's the way it will be stored on...

We use a PowerPivot table to import website data to a large workbook. On the main report tab, the information is broken out by "Year" and then by "Week" (1-53). When 2013 began (and 2013 data was imported), the year 2013 automatically appeared on the reports, BUT this data is no longer broken...

Hi All, I was wondering if anyone could help me... I am using Excel 2003 (Work are a bit slow at moving with the times) I have a workbook consisting of mutliple worksheets which have some conditional formatting and protected cells. Each worksheet is filled out by various individuals and then...

Guys I've created a spreadsheet which calculates scores for Soccer/Football predictions based on correctly predicted scores against actual results. As part of this, I would like to display in my sheet the list of results from the previous week along with the scores actualy scored. I will...

Hello everyone! This is my first post. Here is my question: I would like to collect currency exchange rates from USD to EUR from the internet and automatically insert it into my spreadsheet. The twist: I would like this function to do this in reference to time (i.e. today is the 14th of...

Hi <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am looking to run a macro in a remote file across a network WITHOUT OPENING THE FILE which will create a sub-set of the data (say employee) eventually importing into a Reporting Hub. This will be from...

I’m trying to automate a task that I perform daily at work using VBA. I’ve used very basic VBA code to manipulate data in excel before, but never anything involving access. Below, are the instructions that I’m hoping to convert to VBA code. I would be more than grateful for any...

Hi I am trying the import data into excel (using excel data menu) from a table/query I have made in Access so I can then use a little macro to refresh it automatically. But I am having challenges... This works with other tables but not the ones I have built, anyone know what I am doing...

Hi everyone! I am having some trouble setting up a master excel sheet that can automatically pull data from a folder when it is opened. I currently work with an inefficient data management system in which I save a file as a text (which I can't change), I then re-save it as an excel sheet...