external file

I want to pull information out of a certain file/tab/cell if I type in the full [file.xls]tab!cell i get exactly what I wanted, but what I need to have it do is give me that same information after I've put together file/tab/cell as cells What information I need: ='[file.xls]tab'!$D$5 But I...

I have an excel sheet which acts as an Index to documents in a folder structure on my system. The excel sheet has path of the documents and links to documents created using HYPERLINK formula. I want to validate the links to check if the referenced documents exist or not. I really appreciate...

Hi, I'm moving a pricing worksheet from inside my workbook to an external workbook. I have the following lines of code that I want to turn into a reference from internal to external. I know the general idea is to use [external]! format but every time I have tried to do that in the past in VBA...

I am using AverageIf to link to another workbook. I've read that the "if" family do not like source workbooks to be closed, so I was going to modify formulas to somehow use SumProduct, when I noticed that half of the instances of the formula did return results, while others returned #Value...

=VLOOKUP(B6,'C:\Documents\Desktop\input files\[=CONCATENATE(TEXT(B6,"mm.dd.yyyy"),".xls")]01.31.2014'!$E$2:$I$7,2,FALSE) This is the formula I tried and did not succeed. I'm trying to pull info from external workbooks that are named with dates I have listed in column B of my current workbook...

Hi Folks I am wondering if somebocy can assist me in resolving a slightly intermittent problem of external file link in Excel 2007. There is a main Excel file that has external links to 2 other files. When the value is entered for instance 1 or 2 (this corresponds to a month) all works and...

I have a list of excel files at a website. http://www.domain/projects/excel1.xls http://www.domain/projects/excel2.xls http://www.domain/projects/excel3.xls The files are identical format, different data. I cannot read the files, only when i copy them to local system. (Error: ODBC Excel...

Hi, I am analyzing a large amount of data for a project, and so I am attempting to use the Database functions within Excel to speed up the analysis. However, after I set up the first set of DSUM equations, my file size jumped from ~50k to ~40MB! Any help would be much appreciated. Here are...

I have a workbook, workbook A, with lots of cells that link to a source workbook, workbook B. I copied workbook A from my hard drive at work to do some stuff at home, but I did not copy workbook B. I can't figure out how, but when I open workbook A (at home), the links to workbook B appear to...

Hi All, My Macro opens an excel file and I've to count the number of blank spaces for every filled column. I'm using CountBlank function for that. But, the code fails at the countBlank line by saying Type Mismatch. I've attached a snippet of the code below. Please tell me where I'm going...