[RBG7-L] - Re: Launch & Excel Macros

[Alastair Burr]

Chuck,   I have sometimes had problems getting launch to work as I want so I now use this method which seems to work every time:     SET VAR vLaunchProg   TEXT = NULL   SET VAR vLaunchParams TEXT = NULL   SET VAR vLaunch       TEXT = NULL   SET VAR vLaunchProg   = 'c:\progra~1\irfanview\i_view32.exe'   SET VAR vLaunchParams = +     ('d:\MusicImages\_' + (sget( (ctxt(.vLastEdit)),3,1)) + '99\fle' + +     (ctxt(.vLastEdit)) + '.snd/thumbs')   SET VAR vLaunch = (.vLaunchProg & '|' & .vLaunchParams)   LAUNCH .vLaunch Note the DOS format for the path and the full program name. I suspect that the ampersands could be replaced with plusses in the concatenation of the two halves of the launch variable but as it works I've haven't bothered.   Regards, Alastair.     ----- Original Message ----- From: [EMAIL PROTECTED] To: RBG7-L Mailing List Sent: Wednesday, March 30, 2005 7:52 AM Subject: [RBG7-L] - Launch & Excel Macros From reading the help files in the fine RBase 7.1, it looks like I can call a macro when I launch a Microsoft Office product without having to use Auto_Open. The example in the documentation shows:      Launch C:\WordDocuments\TestFile.DOC|/MacroName|W   I switched gears and am trying with excel.The macro is stored in my personal.XLS worksheet. I have tried with the personal.xls hidden and Un-Hidden.  My code looks like this:   Launch c:\Test_File.XLS|/TestMacro|W and I have tried Launch c:\Test_File.XLS|/personal.xls!TestMacro|W   Do any of you smart people have any suggestions for me?