d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Excel Vba To Micro Focus Reflections
Add Reply New Topic New Poll
Member
Posts: 6,338
Joined: Feb 14 2003
Gold: 8,450.00
Trader: Trusted
Aug 22 2019 03:17pm
Hello everyone.

Has anyone here ever worked with writing macros in Excel that interact with Attachmate/Micro Focus Reflection Sessions? I have scoured Google and can't seem to find any decent references on this.

I have been tasked with a project at work to automate keying in some of our "test" data and am having a lot of trouble setting the "terminal" variable to the currently open session. I can get it to open a brand new session no problem, but we want to work with a "logged in" session because we don't want everyone having to put their passwords into spreadsheets that they may forget to remove before saving.

Thanks for any help you may be able to provide! :)
Member
Posts: 6,338
Joined: Feb 14 2003
Gold: 8,450.00
Trader: Trusted
Aug 23 2019 03:55pm
I actually figured it out!

If anyone in the future comes across this same problem, you need to use .GetViewByTitleText rather than trying by file path when setting your session to one already open.

Hope that helps someone in the future :)
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll