workbook references

Hello everyone. Everyday I run a report that integrates into a database. Since the file was different everyday, I had the macro stored in the personal workbook. I am now trying to move the macro to the database, so that the personal workbook would only have the code to call the macro in the...

Is there any way to create a cell reference that allows you to lookup values from multiple workbooks based on the contents in another cell? For instance: instead of typing the below formula and manually editing the date for each row (day) ='F:\Quality\manufacturing...

Hi, I'm trying to reference another workbook in vlookup formula but I get an error. Is there a way I can reference another workbook without having the workbook open. I tried two formula's below (1. setting workbook as variable and 2. putting workbook directory in the vlookup itself).: 1) Dim...

Hi All, I have created a considerably large sized workbook which processes large amounts of data, as a consequence is slow to run and bulky to save multiple copies. There are currently 40 sheets to the page which are a breakdown of inputs and output pages as well as calculation sheets. We...

Hi, I am trying to load (Copy)certain data from a file from fixed location into a current file by macro. The file name of the current file will change all the time so I need a dynamic reference. I tried the active workbook command, but somehow it doesn't work. Do I have a syntax error? please...

I'm having some difficulty referencing my SUMIF formulas that have multiple criteria to an external workbook that contains multiple sheets. Currently I am able to link to an individual sheet with this: =SUM(IF(('X:\MAM\Tracking\Yearly Reports\[2014 Report.xlsm]Jan'!$D$7:$D$2000="Criteria...

I'm having some difficulty referencing my SUM(IF formulas that have multiple criteria to an external workbook that contains multiple sheets. Currently I am able to link to an individual sheet with this: =SUM(IF(('X:\MAM\Tracking\Yearly Reports\[2014 Report.xlsm]Jan'!$D$7:$D$2000="Criteria...

Hello, I have an issue with worksheet links through a network drive. System information: Windows 7 Professional SP1 64 bit Microsoft Office 2010 Professional I have two workbooks, v1_File and v3_File. Both are Microsoft Excel Macro Enabled workbooks and are both saved on a network drive. The...

I am calling a function in workbook B from workbook A. The function call works after I setup a Reference in workbook B (Visual Basic, Tools, References, then select the check box for the Project I want - in this case it's called "X_Steam". This works fine as long as both workbooks are open...