open close workbook

  1. A

    Vba code to open file which has current date in its name

    Hi All, I am working on one vba coding and I am stucked in between and wanted help. Through the macro, I want one file to be opened from the given location and the name of the file is in below format. "LearnersinMandateDataExport_3657_11302015.xlsx" In the above format only date changes...
  2. S

    Macro won't close fie after opening it

    Hi, Please could you help with the code below, I am very new to VBA I want to open a file whose filepath and name are determined in A1 of Sheet1. Then I want to copy the entire sheet "S1" from the newly opened workbook back to the original workbook, and paste values to a Sheet called "dump"...
  3. Z

    VBA in Excel: define file to open (I retrieve data from 2 Excel files)

    Hello, I have just created with VBA a new Excel file (A) that I will develop further (i.e. run more VBA on it). I also have a source Excel file (B) in which I have source data to run VBA scripts. So it is important to specify from which of both Excel files I read data (A or B) or write in...
  4. K

    VBA: Copy and Paste

    :confused: Hello, This is my first attempt at inserting HTML into a post so I hope I've done it correctly! I need to do the following: Open project workbooks using the details in column A (there are 53 files that need to be open and are all stored in separate folders, they are project...
  5. J

    VBA: Opening and closing workbooks within workbooks

    I have an Excel workbook (using VBA for Excel) with a macro that opens another workbook, then after a small delay, the original workbook closes itself (as it's no longer needed). But something is not quite right with the code... Code I have in a workbook called "workbook1": Sub...

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