external data

I have a very odd occurrence happening. My linked data is not updating when my source file is open. I have a central workbook that has links to about two-dozen source workbooks. The links work properly when I open the file. However, if I open both the Master workbook and one of the source...

Hi! I've created a sheet that will be used by our company for creating requests for purchase orders. Some of the information required to be chosen via a drop down list will need to be updated periodically. I would like to update the information, without having to always send a new form out. I...

Hi all, I am dealing with a huge amount of data on google and forums, but can't seem to place it all together. 1. I need concatenation for this, since from what I read INDIRECT() does can't open closed excel files. 2. I can't use MOREFUNC | Ashish Mathur's Blog (morefunc), cause it's on the...

I want to set a macro in Excel workbook and run/follow following steps. After click on Shape1 (Rectangle Shape Inserted and macro assign on click) Insert New Sheet with Name : BOQ Remove if any table exist with name : BOQTbl in open workbook Remove if any Existing Connection name ...

Hello. I'm working with a workbook that connects to an external data source (table in excel) when opened. Most of the data from the external table consists of 6 numerical digits. However, some cells have alphanumeric cells which is the 6 digits followed by a single letter. The data connection...

Hi All, I need to insert barcodes into an existing excel macro, however this issue I have is the company I work for won't put any excel barcode softare on the PC's for us to use. Is there a way I can somehow link it to an external free barcode website e.g. Barcode-generator.org or...

Hi All, I am wondering if something is possible and i am struggling figuring it out. I have a spreadsheet on my computer (a locally saved file), i have a macro which is linked to a cell in a hidden sheet, i want this cell to be linked to somewhere online and this will determine if the macro...

my original unanswered question is at the bottom. I've exported this page ( All Currencies | Crypto-Currency Market Capitalizations ) to Excel (there probably could have been an easier/more effective method of doing so, but I digress), thus making it a web query that updates the prices every...

Hi all, I have been asked to help with a fairly strange request which to be honest I am not sure I am going to be able to help with. Basically we are building a spreadsheet that tracks the purchase and sale of various items from the online game World of Warcraft. The longstanding online...

Hi I have some data which I bring into Excel from an external source (SQL). The import works fine, however as part of my spreadsheet I need to create a pivot table using some lookup fields (such as the month (which is a calculation of a date), which is why I cannot create the pivot table...

Hi, I'm trying to import a CSV file using the "Get External Data" - "From Text" section in Excel. I have a CSV file that is auto updated by a macro so I want to import this into a normal Excel workbook automatically to manipulate and format etc. When I import it though, about a quarter of the...

Greetings all. I have nearly completed a series of subs and functions that retrieve data from multiple excel sheets, access, and a corporate database. One of my end spreadsheets will have up to 100 lines of data in it once it is updated. Each line is information from a trouble ticket (the...

Hello guys, I am learning VBA by myself and I saw some codes that have the expression provider in it, like this one Connection.Provider = "Microsoft.ACE.OLEDB.12.0" I can not understand what is the function of the Provider in this case and where I can find the code in the...

I want to do the following: Create a connection to a site like this one. Filter the data based on SITE. Select a date and populate a form for that SITE/Date I created this spreadsheet that takes care of steps 1 and 3, but I am hung up on step 2. How do filter the list so it only shows dates...

Hi there, Is there a way to post a specific cell value into a url with macro. here is the macro. I want to Paste the cell value of A1 into the end of the URL. I have also tried to put the desired url in A1 and just reference that. Range("A2").Select With...

I have a small challenge for one of the sheets I am working on that I need the assistance of my fellow excel users. I am getting an external data from the web and the table (external data) has 10 rows always reporting for the last ten days. I want to roll this across to my sheet as a 'to date'...

I am required to set up a pivot table based on a chosen .csv file. I have it now set up through Microsoft Query following the steps layed out at https://www.youtube.com/watch?v=wOEWi4dqvl8. However, unlike in the video, I have a folder with multiple data files named yyyymmdd-report.csv Now I...

Hi All I build about 20 odd reports in excel using an external data source(oracle database through an ODBC connection). At the time of build, the report connections were established in the Development environment of the Database. But now we want to pull data from the Production Environment...

I have an excel sheet where column "B" has a list of style numbers . I also have a folder with pictures of each product and file name of the pictures are the product code. I would like to place the picture of each product in column "A" beside their respective codes. If possible, I would also...

I am using Excel 2003 at work and have made a workbook with 2 sheets that brings data from some queries in an Access DB (also 2003) via MS Query, then presents the data in a report with tables and pivot tables. The file is 23MB in size. Is there a way to program a button (I can manage a bit of...