I have a Macro which currently we download a spreadsheet Update: and it automatically opens (and doesn't save) -- from our custom internal web interface. The spreadsheet name changes each time. The current utilization instructions are to open VBA Editor, copy Macro into new module, then run Macro.
I'd like to make a stand alone file to make the instructions something like this, open workbook, then double click file.
My though would be that they could only have the workbook in question open and the standalone file code would be something like
use open workbook (Very generic).
I read about vbs, but all I did was change my macro from .txt to vbs and clearly it doesn't work yet. Can anybody point me in the right direction?