external data

I'm having a really hard time making web queries on Mac. I'm trying to import the individual words from different news articles into different columns. So, ideally, each row would have all the words from all the articles on a certain day. Whenever I use this code: WEB 1...

I have a pivot which uses another external spreadsheet , connected via "use an external data source" The data source has two columns , one for "Actual Spend" , one for "Budgeted Spend" . Both columns in the source file are formatted as Currency format and display as currency with no problems...

Hello everyone, I'm working on a macro, a part of which requires getting data from a website (after logging into it). heres what i have tried so far : Sub getdata() Dim a As String Set IE = CreateObject("InternetExplorer.Application") With IE .Visible = True .navigate...

Hi I've got some external data in cell M7 and need to copy the values to another cell. I've recorded a macro that refreshes the external data and then copies and pastes the values. When I run the macro it copies and pastes the old values while the external data is refreshing. The code look...

RE: Error with External Sources multiple users Greetings, i just began having errors with one of my workbooks. When the workbook opens it runs the "RefreshAll" Command via the workbook open event. Until today this has run without issue. However now when users, (other than myself), open the...

I have some numbers in a text file, like 6-1 7-12 8-11 These denote business hours, such as 6AM to 1AM. When I do a conversion, or import into Excel, whether I import them as GENERAL or TEXT, it converts them to dates such as 1-Jun, 12-Jul, 11-Aug. How can I make them import exactly as...

Is there a way of selectively importing data - have a csv file that is around 126 million rows and 3 columns. The third column will be a number between 0 up to around 1,000. Is it possible to request that a row is only imported if, say, the value in the 3rd column for that row was less than...

Hi all, I cannot seem to get external web data function, i am using Excel Office 2011 Mac, the option does not seem to be there??? I need live currency exchange rates to be automatically updated into a table i have created. can this be done on mac 2011?

I apologize if this is a simple question, but it's just got me stumped: 1) I am building a workbook of financial data (Don.xls), and to save time, I've copied a worksheet from a master file (Bar.xls - the sheet is named "model"). 2) After I've linked all my data from the "model" worksheet...

Hi all! Is there a way in standard Excel to bind (read-write) cells to data stored in a database? If not, can the functionality be accomplished with an add-in, which one(s)? Or can this be accomplished only with VBA? So far I have successfully managed to connect an Excel workbook to a database...

Hello all-- I'm sorry if this has been answered, but I can't find the answer to this anywhere on the internet. I am trying to record a macro that records the mouse clicks in an application outside of excel. I don't believe this can be accessed by doing a data query b/c to login into the...

Hello there! I haven't posted here in a long time but have certainly searched through here over the months to get help on any number of things. Thanks to the community for that. I love this place! My current dilemma is as follows: I'm in a corporate environment where Excel 2003 is the...

I am a newbie and need help. I used an ODBC driver to import data to Excel. I then added two columns to the left (Column A and B) of the data with formulas to calcuate age. Now I have a couple of problems. I think the problem is with the two columns that I added but not sure. I don't see anwhere...

I have used the macro below to pull information from a website and then paste the information into specific cells in excel. This has worked for almost 1 year. Excel would open the webpage into excel (i.e. bring in data, pictures, etc) via "Workbooks.Open Filename:=webpage" I will then pull the...

I am importing data from a Microsoft query into excel. The query only holds the current days information, then the next day it disappears and the new data is there. I would like to be able to create a database/table that retains the old information and just inserts new rows for new information...

Hello, After two days of googling (since om still a beginner) I have yet not found a solution to this (probably easy to solve) problem. I will firstly try to explain the problem and afterward the whole idea of the solution (if anyone wants to comment). I am trying to copy values from two...

I have a file in Excel 2007 that pulls data with the ODBC from a LAN. It is set to refresh upon opening. However, this file will be used by many within the company and the user must enable external data for the current data to come through. Here is my question. Is there a way (through VBA or...

I'm looking to find out if there's any way to use "Query Wizard-Filter Data" with a "Web Query"? External Data is one area of Excel I've never done much with. I have a need to post a "master data file" out on our company's web-based document server. The expectation is that several Excel...

Hi everyone, I have an interesting challenge today. I'm trying to create a template file that runs a vlookup off of another file. The problem is the other file (which I don't own) can have multiple entries. I need a way of either flagging that there are multiple entries, OR a sum of all...

I opened a memory stick on a XP system does evcel store any of the data anywhere ofter the memory stick is removed, files where saved back to the memory stick at that time thanks