open & copy

  1. A

    Open, Copy data and Close a workbook based on the names of the tabs in my active workbook

    Hello everyone, Apologies English is not my first language and I am very new to writing VBA codes. So far, I have only copied and adapted parts of the codes to fit my needs. Recently, I have created a workbook, each tab has the name of a treatment site. Daily, I receive data about these...
    • Aurore87
    • Thread
    • closed workbook excel open & copy retrieve data separate workbook tab name vba
    • Replies: 2
    • Forum: Excel Questions
  2. IIII

    Copy open workbook to same folder dir with date amended to name

    Hi All - as it states in the heading, I'm looking to either amend the code below or obtain a new on where I can copy the workbook I have open to the same folder but with the Week ending date (Sunday) added to the end of the file name. I found this code (Credit: @swapnilk) that gets me going...
    • IIII
    • Thread
    • date open & copy rename workbook save a copy vba
    • Replies: 2
    • Forum: Excel Questions

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
Back
Top