external

Hello All, I have a connection in my workbook to refresh exchange rates every 30 mins. I would like to know after the refresh if the rate is down or up from the previous rate using some form of advanced conditional formatting. Is there a way to do this using some sort of IF statement in VBA...

Good afternoon, Can anyone provide me with the code required to find the screen co-ordinates of any window, searchable by its window name as it would appear in appActivate() for example? I know nothing about using APIs to find windows, nor handles etc., and the numerous threads I have read...

I have a workbook (WB1) that contains multiple worksheets. I need my current workbook (WB2) to go into workbook (WB1) and copy the multiple worksheets and combine them into one worksheet in WB2. I was able to work out... within the same workbook to combine all the worksheets into one but have...

Hello Everyone! I need some assistance figuring out a problem on a job tracker I am creating. I have two workbooks, one which holds the data for each job with each newly created job being on its own row. The other workbook updates off of the original workbook and is where the manage can move...

Hi everyone, I have written several macros to grab data from an external source and copy it to the open workbook but occasionally the exact same codes runs into the Run-time Error 1004. The setup is I have around 20 Workbooks each which have the below code within them referring to a single...

Is it possible to link an existing pivot table to an external data source? I wanted to move the data out of the workbook but didn't want to redo my pivots. JV

Hi, I am trying to make the following steps work but Step 5 (macro) simply does not work. Step 1 I have a worksheet where a user is able to enter data in one tab, Step 2 which is stored in another tab by way of macros, Step 3 which populates cells in another tab, Step 4 the cells will then...

Hi all, I have a workbook (mainWB) that get information from many different workbooks (underWBs) there is no problem updating this information. The UnderWBs also has references to external data (HTML) if I open an UnderWB and update information there is also no problem. Remember there are...

I created this webquery with a parameter that will generate the link to 800+ PDFs, instead of searching for all of them one at a time. Now I have to open each link and save each PDF individually, and that is where I need your help. Is it possible to write a macro where I just click cell A1...

Hi I have a workbook (let's call it Output.xlsm) that draws in data through external links from another workbook (Source.xlsm). Both of these workbooks are stored in the same folder location. I regularly make a copy the folder so that I can work on new scenarios, while maintaining the...

I have a workbook where the user inputs an Item Code and I want to present them with a list of LOT numbers (from a Table existing in another workbook) to choose from. The list will then be used in a list box so I would like the result in an array. So my input is an Item Code (I am not sure if...

Our shipping department creates an Excel workbook per job/project. Each job has a varying number of shipments. Shipping will add a new sheet with the details for every shipment - everytime a shipment goes out. The naming of the sheets varies and the number of sheets varies as the job...

Hello, I'm using Excel 2007 to try and paste as picture link from multiple workbooks. In total I will have roughly 50 sheets in my workbook with each sheet pasting as a picture link from a separate workbook. I'm trying to just run a test on the first two sheets and am not having much luck...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

Hi there Excel masters! Ok, here goes. Please excuse me, I'm fairly new to this. I'm trying to create a formula for work that will look up information on an external spreadsheet based on conditions. I want to be able so search a date in one cell, then a department in another cell then display...

(1) I have been using XML Data Import via a static URL in Excel with no problems. External data is pulled into a table in Excel, and when you refresh the table it refetches the XML at the remote URL. For reference, the method is described here...

Hi Everyone, :( I'm sorry if the same has been asked before, but I haven't got a clue yet from searching. So.. I have this Feedback Form (UserForm). I want the feedback form values to be written on a closed workbook. Say, "C:\EGD\Temp.xls". The UserForm is filled out by many users and, of...

I have a situation where I want to refer to cells in many different workbooks. The Indirect function will work if I have all of the external workbooks open, but I have far too many to open at the same time. Is there some way accomplish the same thing without manually entering all of the external...

Hi, I have started to have a problem with external links in a couple of spreadsheets. The problem is when you have just the primary spreadsheet open the external links are displayed as '\\DataDrivePC\Group\Forecasts\Mgmt Master\Sep11 actuals for financial bodies\[MasterBankModel...

is there any way to change text changing itself after you refresh external data from the internet For example: if the text you added to the spreadsheet was the United States of America, and then you changed it to USA. Is it possible to keep it as USA after refreshing the external data.