billgeo01 Absent Member.
Absent Member.
2183 views

Reflection Macro - Make Reflections Visible Again From Excel

My Reflections macro opens an Excel workbook and process all the data from it into a mainframe process.
This all works just fine but one usability issue I have in redisplaying the Reflection's mainframe screen once i've made the Excel workbook visible.

The macro is started from Reflections and when the macro after opening the Excel workbook it displays it (*.visible) and prompts the user to verify it is the correct workbook. The verification prompt is displayed via a msgbox() function however, this prompt displays on the Reflection's mainframe screen and the user cannot see it unless they manually switching to it. Note: this is still in testing and not a production macro as yet. I would think this is a very simple command/function to make the Reflection's screen visible but I've tried a number of ways only to error.
How do I made the Reflection's screen visible or how do I get the prompt to display on the Excel screen?

Any insights are appreciated!!

Bill
0 Likes
3 Replies
AutomaticReply Absent Member.
Absent Member.

Re: Reflection Macro - Make Reflections Visible Again From Excel

billgeo01,

It appears that in the past few days you have not received a response to your
posting. That concerns us, and has triggered this automated reply.

These forums are peer-to-peer, best effort, volunteer run and that if your issue
is urgent or not getting a response, you might try one of the following options:

- Visit https://www.microfocus.com/support-and-services and search the knowledgebase and/or check
all the other self support options and support programs available.
- Open a service request: https://www.microfocus.com/support
- You could also try posting your message again. Make sure it is posted in the
correct newsgroup. (http://forums.microfocus.com)
- You might consider hiring a local partner to assist you.
https://www.partnernetprogram.com/partnerfinder/find.html

Be sure to read the forum FAQ about what to expect in the way of responses:
http://forums.microfocus.com/faq.php

Sometimes this automatic posting will alert someone that can respond.

If this is a reply to a duplicate posting or otherwise posted in error, please
ignore and accept our apologies and rest assured we will issue a stern reprimand
to our posting bot.

Good luck!

Your Micro Focus Forums Team
http://forums.microfocus.com



0 Likes
vfast Absent Member.
Absent Member.

Re: Reflection Macro - Make Reflections Visible Again From E

To make the Reflection Workspace window come to the top-front on the Windows desktop using a Reflection VBA macro, use the Frame.Activate method, for example:

ThisFrame.Activate

http://docs.attachmate.com/Reflection/16-1-1/vba-prog-guide/Attachmate.Reflection.Objects~Attachmate.Reflection.Objects.UserInterface.Frame~Activate.html
0 Likes
billgeo Absent Member.
Absent Member.

Re: Reflection Macro - Make Reflections Visible Again From E

vfast;2478311 wrote:
To make the Reflection Workspace window come to the top-front on the Windows desktop using a Reflection VBA macro, use the Frame.Activate method, for example:

ThisFrame.Activate

http://docs.attachmate.com/Reflection/16-1-1/vba-prog-guide/Attachmate.Reflection.Objects~Attachmate.Reflection.Objects.UserInterface.Frame~Activate.html


Thanks vfast, This worked as I needed. 🙂
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.