switch between workbooks

  1. B

    Changing between worksheets with similar names in macros

    Hi all, This is my first time making a macro in excel and I need some help. I am trying to get my macro to calculate % survival data. I currently have a macro that takes the average value for alive cells and calculates % survival, then copies the average value for alive cells and pastes it to a...
  2. M

    moving between multiple wokbooks

    hi, im facing problem operating between two different unsaved workbooks, read a lot about possible solutions but still cant find good one. Macro should select and copy sheets to a new added workbook or opened from file workbook (both workbooks have sheet kennzahlen), switching between those...
  3. C

    Switching between workbooks in vba

    Hi there, I have a problem I've been trying to work out for a while, I'm trying to switch between workbooks, Workbook1 with the code in will have a constant name, the name of workbook2 will change every time the report is run (on a weekly basis). I've got workbook1 to open workbook2, and can do...
    • Ceri_m
    • Thread
    • switch between workbooks variable file name vba activate
    • Replies: 2
    • Forum: Excel Questions
  4. L

    urgent help required...optimise the macro and switching between two workbooks

    Hi Gurus, I need some help in optimising the following code and also in the last I want to switch on the newly saved workbook and save close that file. Please help basically this peace of code is copying three worksheets from one workbook and copy pasting selective cells as value. Then this new...

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