reference a file

Hello, This is probably a quick fix but for the life of me I cannot figure it out. I have a project that references an open unsaved file ("Invoice Data.xlsx"). Every day a new file is emailed to us with invoicing information. The macro file imports the relevant data and runs some calculations...

So generally I am trying to make my text formula work, but as many other methods, this one doesn't work for some reason. =IFERROR('K:\PLANING\Apr\[Thu, Apr 11.xlsb]Millright data'!B7+'K:\PLANING\Apr\[Thu, Apr 11_2.xlsb]Millright data'!B7,'K:\PLANING\Apr\[Thu, Apr 11.xlsb]Millright data'!B7 This...

Below code works perfectly: Sub ExportToPowerPoint() 'early binding Dim ppApp As PowerPoint.Application Dim ppPres As PowerPoint.Presentation Dim ppSlide As PowerPoint.Slide Dim SlideCount As Long ' Reference instance of PowerPoint On Error Resume Next ' Check whether PowerPoint is running...

Hello, I am trying to export data sets from 3 files into a new "Weekly Summary" file. However, the file names change each week to match up with the start date of the week (ex. Line 1 6-26-17). Whenever I try to reference a sheet by having the user select a file by using...

I have a master file consolidating everything I need and it is mostly references to other files that are exported with monthly data. I have one master file that is updated as those files are saved and has very little data that is manually entered. Not all of the reference files will be updated...

I ahve a report that I must update each week. Throughout the report are references to another daily report of the format: 20140610_DailyReport So each week when it comes to updating I am supposed to CTRL+H and replace 20140603_DailyReport with 20140610_DailyReport But when I try that now...

I'm really hoping someone could help me out with this one. Here is my situation: I have a workbook with several sheets, all set up exactly the same. Each cell on a sheet is referencing the same file, however each sheet is referencing a different file. For example, this is one of the cells in a...

I am having to set up a workbook for our purchasing department that compares two daily exports from our database and tells her what to order to maintain appropriate levels of inventory. I can make all the formulas and know how to get this to work if the two exports were excel files. Can the...

All, Apologies for the vague title - could not find a good way to word it. This thread plays off a recently posted one that a member was very quick to answer and get me on my way. I have a file name of "May Scrap Net of Reserve with scrap codes.xls". My earlier post centered around how to...

Hello all, I have found a number of threads on this subject, but all point towards using '=indirect()' or a macro. The problem with the indirect function is that I cannot consistently have the referenced file open, hence a #REF error. I also do not want to use a macro due to the volatility of...

I want to reference a table (not a pivot table) from another Excel file. I want it to update automatically if the original table is changed in any way. Any ideas?

Running Windows XP - Excel2007 Each month I prepare financial spreadsheets that include entries for that month and a running cummulative total for the year. I add the current month to the cumulative total last month (by referencing the same cell in last months spreadsheet). Each month I...

Hello, I have experienced an unusual problem with formulas referring to another workbook. When re-opening the master xls file and choosing the update option, the error message "This workbook contains one or more links that cannot be updated" comes out and the formulas containing external links...

Hi All, I have just started VBA-ing in Excel, and feel I am way over my head. Any solution to the following would be greatly appreciated: Basically, I have two two workbooks, let's call them data.xls, and model.xls The model workbook needs to pull numbers from the data workbook. Basically the...

Hi, I'd like to know if it is possible to make a reference in vba to an external program. Now, I can make an object-reference to Excel like this: Set xlExcel = New Excel.Application xlExcel.Visible = True xlExcel.Workbooks.Open vFile, False, True I'd like to do the same, but now to a...

I am using Excel 2003 to track some data between two workbooks. Book 1 has the source (first 6 columns of data) which I have referenced to Book 2. Book 2 contains the data from Book 1 but has additional columns of information that is manually updated. Here's my problem. When Book 1 has an...

I have two workbooks: one with raw data, and one that uses that data. My 1st workbook references cells within the 2nd one using: =INDIRECT("'[Next Level Input.xls]Sheet1'!"&"$C"&$F$4) Essentially, I am looking for it to return the data in a cell: with column "C" and the row of F4. All of...

At work we have about 10 different excel programs that we use regularly, and we're trying to create a control panel program to make things easier for the less technically inclined. The control panel program (currently named "Control Systems.xls" needs to be a shared workbook that has the...