| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate "current workbook"
Currently within my VB I have Windows("FileA.xls").Activate This is no good as the file name will change depending upon which book I have open, but I want the macro to run on the active book (I will specify sheet which is the same in all books) I want to activate current Book. (there will only be one file active, Macro is running from Personal Book, which it goes into to copy and paste some data across to File A) Any ideas? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Activate "Show all" in a Protected Shared Workbook | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
| =IF((TODAY()-B8)30, "Overdue", "Current"), | Excel Discussion (Misc queries) | |||
| Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming | |||
Threaded Mode
