macro open workbook

  1. R

    Macro to Open Workbook then use supplied name elsewhere in code

    Hello, I'm looking to create a macro that will prompt the user to select the workbook that their "settings data" is in and then proceed to copy and paste some of the data from that workbook to the new one. So far I've got this in place: Sub GetOptions() Dim vFile As Variant 'Showing...

Some videos you may like

This Week's Hot Topics