workbook1

  1. M

    VBA- Activate Sheet from another Workbook based on Cell value

    Hi everyone. I'm having a hard time coding this one. My objective is to select the sheet name based on a cell value from another work book. Say, in workbook1, range(a1)= d-4 Then i want sheet(d-4) opened in workbook2. The catch is, i want to dynamically do it. That is, once sheet(d-4)...
  2. W

    Excel VBA switching between workbooks

    Hi! This time I am really stuck. I have two workbooks Workbook1 (main file - named: h:\dekstop\somethingneweveryday.xlsm) Workbook2 (data file - named: H:\desktop\blomst.xlsx) I do my work in Workbook1. I use a macro in workbook1 to open and activate Workbook2 and do some stuff and collect...
  3. V

    How to call and run a Macro (StatusV2) stored on Workbook1 onto Workbook2

    <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier...
  4. P

    Copying Data to Another Workbook

    Hi can anyone help with a macro to copy a range of data from one workbook to another? I have rows of data on workbook1 sheet(Data) range A2:H that I want to copy to workbook2 sheet(Data). I need the data to copy to workbook2 in the same columns as workbook1 but continue the data to the next...
  5. MitzDriver

    Next file in directory

    How can I..... From workbook1 open the first workbook (no matter what the name is) in directory X. copy value in a1 and b6, paste it to a1 and a2 in workbook1 Open next workbook (no matter what the name is) in directory X copy value in a1 and b6, paste it to a1 and a2 in workbook1 Do the same...

Some videos you may like

This Week's Hot Topics

Top