How to call a VBA macro from visual macro editor?

[Shalin Mehta]

*****
To join, leave or search the confocal microscopy listserv, go to:
http://lists.umn.edu/cgi-bin/wa?A0=confocalmicroscopy
*****

Hi Listers and folks at Zeiss,


We need to call a VBA macro from visual macro editor of Zeiss Zen 2011
(laser scanning system).
Our macro behaves like other macros - it can be called from the
standard macro dialog and inserted as a menu entry.

But, we cannot figure out how to call ANY macro from visual macro
editor - through the "VBA macro" block it provides. Please see this
screenshot that shows the issue using Zeiss's multi-time macro:
 https://dl.dropboxusercontent.com/u/7544966/VMECannotLoadVBAMacro.png

In above, if I click Run in "Macro control" dialog, multi-time macro
comes up. The "Procedure" field (blue highlight on right) in visual
macro editor does not get populated with procedures that appear in
Macro control. Typing in the name of the procedure and then clicking
run doesn't bring up the macro either.

It seems we are missing something simple. Any ideas gratefully received.

Thanks
Shalin
website: http://mshalin.com
(office) Lillie 110, (ph) 508-289-7374.

HFSP Postdoctoral Fellow,
Marine Biological Laboratory,
7 MBL Street, Woods Hole MA 02543, USA

[Richard E. Edelmann]

*****
To join, leave or search the confocal microscopy listserv, go to:
http://lists.umn.edu/cgi-bin/wa?A0=confocalmicroscopy
*****

Shalin:

Did your purchase include the macro editor?  You need to have purchased the
macro editor license, before any of it works right.


On Mon, Dec 30, 2013 at 5:24 PM, Shalin Mehta <[hidden email]>wrote:

> *****
> To join, leave or search the confocal microscopy listserv, go to:
> http://lists.umn.edu/cgi-bin/wa?A0=confocalmicroscopy
> *****
>
> Hi Listers and folks at Zeiss,
>
>
> We need to call a VBA macro from visual macro editor of Zeiss Zen 2011
> (laser scanning system).
> Our macro behaves like other macros - it can be called from the
> standard macro dialog and inserted as a menu entry.
>
> But, we cannot figure out how to call ANY macro from visual macro
> editor - through the "VBA macro" block it provides. Please see this
> screenshot that shows the issue using Zeiss's multi-time macro:
>  https://dl.dropboxusercontent.com/u/7544966/VMECannotLoadVBAMacro.png
>
> In above, if I click Run in "Macro control" dialog, multi-time macro
> comes up. The "Procedure" field (blue highlight on right) in visual
> macro editor does not get populated with procedures that appear in
> Macro control. Typing in the name of the procedure and then clicking
> run doesn't bring up the macro either.
>
> It seems we are missing something simple. Any ideas gratefully received.
>
> Thanks
> Shalin
> website: http://mshalin.com
> (office) Lillie 110, (ph) 508-289-7374.
>
> HFSP Postdoctoral Fellow,
> Marine Biological Laboratory,
> 7 MBL Street, Woods Hole MA 02543, USA
>

--

Richard E. Edelmann, Ph.D.
Center for Advanced Microscopy & Imaging, Director
9C Upham Hall
Miami University
Oxford, OH 45056
Phone: [phone]
Email: [hidden email]
Web: www.cami.muohio.edu

[Shalin Mehta]

*****
To join, leave or search the confocal microscopy listserv, go to:
http://lists.umn.edu/cgi-bin/wa?A0=confocalmicroscopy
*****

Thanks for the suggestion Richard,

We do have license for both Macro module and visual macro editor.
Sans "VBA macro" block, I can execute custom acquisition using
visual macro editor.

Hope to hear more ideas from the list,
Shalin
website: http://mshalin.com
(office) Lillie 110, (ph) 508-289-7374.

HFSP Postdoctoral Fellow,
Marine Biological Laboratory,
7 MBL Street, Woods Hole MA 02543, USA


On Thu, Jan 2, 2014 at 5:46 PM, Shalin Mehta <[hidden email]> wrote:

> Thanks for the suggestion Richard,
>
> We do have a license for both Macro module and visual macro editor.
> Sans "VBA macro" block, I can execute custom acquisition using in
> visual macro editor.
>
> Hope to hear more ideas,
> Happy 2014,
> Shalin
> On Tue, Dec 31, 2013 at 9:00 AM, Edelmann, Richard <[hidden email]> wrote:
>> *****
>> To join, leave or search the confocal microscopy listserv, go to:
>> http://lists.umn.edu/cgi-bin/wa?A0=confocalmicroscopy
>> *****
>>
>> Shalin:
>>
>> Did your purchase include the macro editor?  You need to have purchased the
>> macro editor license, before any of it works right.
>>
>>
>> On Mon, Dec 30, 2013 at 5:24 PM, Shalin Mehta <[hidden email]>wrote:
>>
>>> *****
>>> To join, leave or search the confocal microscopy listserv, go to:
>>> http://lists.umn.edu/cgi-bin/wa?A0=confocalmicroscopy
>>> *****
>>>
>>> Hi Listers and folks at Zeiss,
>>>
>>>
>>> We need to call a VBA macro from visual macro editor of Zeiss Zen 2011
>>> (laser scanning system).
>>> Our macro behaves like other macros - it can be called from the
>>> standard macro dialog and inserted as a menu entry.
>>>
>>> But, we cannot figure out how to call ANY macro from visual macro
>>> editor - through the "VBA macro" block it provides. Please see this
>>> screenshot that shows the issue using Zeiss's multi-time macro:
>>>  https://dl.dropboxusercontent.com/u/7544966/VMECannotLoadVBAMacro.png
>>>
>>> In above, if I click Run in "Macro control" dialog, multi-time macro
>>> comes up. The "Procedure" field (blue highlight on right) in visual
>>> macro editor does not get populated with procedures that appear in
>>> Macro control. Typing in the name of the procedure and then clicking
>>> run doesn't bring up the macro either.
>>>
>>> It seems we are missing something simple. Any ideas gratefully received.
>>>
>>> Thanks
>>> Shalin
>>> website: http://mshalin.com
>>> (office) Lillie 110, (ph) 508-289-7374.
>>>
>>> HFSP Postdoctoral Fellow,
>>> Marine Biological Laboratory,
>>> 7 MBL Street, Woods Hole MA 02543, USA
>>>
>>
>>
>>
>> --
>>
>> Richard E. Edelmann, Ph.D.
>> Center for Advanced Microscopy & Imaging, Director
>> 9C Upham Hall
>> Miami University
>> Oxford, OH 45056
>> Phone: [phone]
>> Email: [hidden email]
>> Web: www.cami.muohio.edu