update closed workbook

  1. J

    Updating existing records in closed workbook VBA from current open workbook

    Hello, Any help appreciated. I tried finding an existing thread on it but could not find one close enough. Long story short, I have two excel files. One is called "Item Impact and Cause" and stores a list of 4 columns which are (1) Item Number, (2) Root Cause, (3) Recovery Week, and (4)...
  2. S

    Update Data in Closed Workbook

    VBA novice here, Is possible to update data that is queried from an external source in a closed workbook? I use the following code to retrieve stock data from Yahoo Finance: Sub GetData() Dim DataSheet As Worksheet Dim EndDate As Date Dim StartDate As Date Dim Symbol As...
  3. T

    VLOOKUP in a separate workbook that updates the file name daily

    I am trying to use vlookup for a different workbook, but the file name of the workbook changes daily (it's updated everyday). The format of the file's name is consistent, and only changes according to the date, so today's file name would be "file_02132014.xls" So far what I have that works is...
  4. O

    Updating a different sheet through a closed workbook

    Hi There! I got into some trouble trying to help someone at work: He uses Excel 2007. He has 2 workbooks, lets say wb1 and wb2. wb1 has 2 sheets, sheetA and sheetB, while wb2 has sheetZ. What needs to happen is that when he updates sheetA, it updates some cells in sheetZ, which updates some...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top