vba close workbook

  1. C

    VBA to close workbook with different name at the end

    Hi, So closing a specific workbook is simple. Google knows too. But what's the VBA to close a workbook that changes name at the end everyday? Example: Today: A_AgingDetail20220721ghtr Tomorrow: A_AgingDetail20220722erts A. Tomorrow: A_AgingDetail20220723weph So the only...
  2. C

    VBA to open 2 workbooks(name changes on 1), copy and paste data and drag down existing formula

    Hi, Thank you in advance. This one is a bit long. Sorry! So I download a file daily and I use that to replace the data on another file which is 1 of my database excels for my main template. The VBA that I'd need would be the following: * Open both Excels(I'm guessing they have to be opened for...
    • cdalgorta
    • Thread
    • calculation options vba vba close workbook vba copy data vba drag formulas vba open workbook
    • Replies: 85
    • Forum: Excel Questions
  3. J

    VBA keeps closing BOTH workbooks (only 1 specified)

    Hi all - any help would be appreciated. I have VBA that loops through a tab on a 'master sheet', changing the club on the tab, and saves down as a separate file for that club. It repeats this for each club, saving the sheet and closing it down each time to return to the 'master sheet'. I have...

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