external data

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

I have a spreadsheet that has links to Outlook email and task templates. Everytime I click them, I get the warning about "Some files can contain viruses. . ." I have added the folder the templates are in to the trusted list and have enabled all data connections and workbook links. The message is...

Hi, I have a 3 column list 'master.xls'. In another WB I have a "report" worksheet that I want to reference the master wb. So, a user will want to select from a list an option found in the master. Then, dependant on what is slected from the first list will be given a choice from a second...

I have an Excel 2007 workbook that there is a worksheet that able to refresh the data when change the cells value in other worksheets. I read her query has several [WHERE (X_PR_EXCEL.YEAR>=?)], and parameter is pointing to cells in other worksheets. When I click on the result table, and click...

I have a workbook/report that is fed from ~200 queries to an access database. we recently added a number of queries and we have started to get odd behaviour when the code gets to the 120-150 query range in that it starts prompting for a data source. I'm sure the problem is NOT the queries...

I am importing data to excel from an external database though MS Query. The data is similar to the table below. This information is for a weekly report, and though the bulk of the information remains the same, there is some small change from week to week. <?xml:namespace prefix = o ns =...

I have a worksheet which holds a list of data records. An external application is then called which reads these records and creates a separate worksheet containing a result for each of the data lines in my worksheet. I have created a link from my sheet (at the end of each data record) to the...

I have a text.CVS file I down load daily off a server. I have used Get External Data From Text. Works well. I want to write a VBA sub to refresh the link as part of a large reporting package What I have is: Selection.QueryTable.Refresh BackgroundQuery:=False But when it runs it...

Hello, This is my first post and since I'm new at VBA (I learned a lot through MrExcel forums, thank you all) I would like to know if there is any way to get information from external software window, for example, information on textboxs of other software applications (not Office) I'm...

What is the best way to implement VBA code to query multiple spreadsheets in a directory, pulling data from specific cells into a new spreadsheet, and ensuring all spreadsheets in that directory are included in the query? Where I work we have a huge amount of test data in .xls format, hundreds...

I am trying to set up a VLOOKUP to a table which is linked to Access. The linked table is a master vendor list which comes directly from our accounting system. I'm using the VLOOKUP in a listing of payments to vendors and I want to be able to only type in the vendor number and have the VLOOKUP...

Hi, I am producing tables and images outside Excel 2003 and want to auto-update them in a Excel file. The file names stay the same but the images themselves change (they're graphs created by an external software). I found instructions on auto-updating external tables but I cannot find any...

I'm trying to create an "Abroad Expense Report" form, and I would like to get the exchange rate from web site. I would like to put a date in a cell and to get the right exchange rate. Herewith the link to get it. in this example the date is 20030505...

I have recently recorded a macro to import data from an external data source. The code below is basic tweak of that recording. What i essentially want to do is have this code loop through Worksheets("FileList").Range("I1") to Worksheets("FileList").Range("I6") as there are 6 cells that contain...

Hi, I am looking to build a report from multiple pivot tables and I wish to build a summary table, with data pulled off from these tables. The catch is that the pivot tables are linked to an external data source, which changes regularly. I am actually looking to get values at a particular...

I have oversimplified the following scenario in order to get to a specific question... I have the following two excel files: File #1 = ModelData.xls File #2 = DistrictFormat.xls File #1 contains one worksheet named "basn". The worksheet includes a column with header "NAME" and text data...

I would like to grab data from external work books. I then want to consolidate a range in each workbook on to the original workbook. There are lots of examples of this type of code on here but I am struggling adapting it to my needs All the target workbooks are the same name. ("Spend review...

It seems I have worked on this bit of code for months and it was working until the sheet that the data is coming from was changed. To allow for this and any further possible changes I did the following. Workbooks.Open Filename:=Fnm 'place file path of workbook in cell in column A With...

Hi, I have a excel report template which contains approx 9 pivot tables and 4 external data feeds from more than one access db. I am looking to automate production of this report so there is little or no input from the user. So... I am looking to write some code which will refresh each of...

I would like to pull data from a lot of external spreadsheets (50 at present but growing by the week) to a single sheet. I have looked through the forums and although there are some threads covering this I do not really understand the code well enough to adapt it to my own needs. The external...