Function: under Data - Get External Data - New Web Query good day friends, i would like to query the stock quote copy to the data to the spread sheet by...

I have a file Summary.xls. There 100 files Data1.xls, Data2.xls, ... , Data100.xls Data files are identical. All files contains a value in cell A1. I have...

I have an excel file with several queries. This is connection string. It is saved in Excel file UID and PWD. I can see it using this...

Hello: I have a large report that has 104 imported external data links. These links refer to 104 differnt Access queries for a file located on a shared file...

We have migrated a share from one server to another and now Excel links are not getting updated. The only links updated are ones based on drive letter, but the...

Window into Excel results in text rather than a hyperlink. I've been searching for an answer all morning, and I'm sure it's something that I'm being duh about....

Hi, I'm a newb on the excel/VB thing and I am trying to set up a class timetable for casual teachers. What I need is someway of typing in some info (days.eg...

Hello, I'm using the Excel Interop in C#. A resultset is returned to a function which parses it into an array and the array is assigned to a range (I know,...

Hi Cookers, Welcome to our new website, cookersworld.com. We have expanded the content links to ad Mr. Emeril Lagasse's fine recipes along with recipes for...

If anyone can assist, I'd be most grateful. Firstly, Extend Formats & Formulas to Additional Rows is checked in Oprions under the Tools menu. BUT, as well as...

Is there any way possible that I can put three separate Excel spreadsheets on three separate computers and if one makes a change on any one of the spreadsheets...

I know we can at least ping a UNIX server from Windows. Is there any software available or VBA code to view data on the UNIX server. Have a server that shows...

I thought this would be easy to do, but so far... no luck. I have created a simple spreadsheet in Excel 2002 that lists the DVD's I have in my collection. I...

HELP! I have one workbook in which Sheet 1 imports data from Quickbooks. It always has the same number of rows and columns. I want Sheet 2 to pull data from...

The standard "Import External Data" function in Excel makes it easy enough to obtain a single record in Excel from an Access database, but I'm trying to figure...

Is there a reasonably simple way to link a range of cells in Excel to a table in Word such that the word table is not messed up by adding a line above the cell...

I've just switched from one Access application to another as the data source for an Excel spreadsheet, as a result I'm having to swt up all the links all...

hi all, Is it possible to retrieve a value from an external excel file using Excel 97 SR2? We have created a pricing.xlt template containing VLOOKUP function...

hi all, we are encountering an error "Not enough memory" when we try to save Pricing.xlt template file containing the following...

I have a problem getting my workbooks to update with the most recent data. For example, workbook A passes data to workbook B, B then passes data to workbook...