Search results for query: *

Crash171, fwiw, Bluezone has their own scripting language but you should be able to use "most" of Extra Basic for your needs. There will be a few hiccups as there are subtle differences. You would need to figure out a workaround. The Bluezone interface is not as robust or friendly as Extra...

look at Skip's solution here http://www.tek-tips.com/viewthread.cfm?qid=1758542

lankaw, can you post your code that initially opens Excel?

Rambonaotr, I may have misunderstood your requirements You have several open sessions and you are evoking the macro from let's say session 1. does the macro go to session 2 or session 3 to do anything? if you only want the macro to run on session 1, then as I've said earlier, this would be...

Rambonaotr, what Skip posted is correct. if you found a solution, it would be nice if you would post it so that others can make use of it in the future.

this should be the problem Set Sess0 = System.ActiveSession for each session that you open, iterate, Sess0, Sess1, Sess2. this will differentiate each of the sessions. so if your macro refers to sess0, it will only work on that session

so this is good now?

the recorded macro does not work; this will work Sub Main() Dim Sessions As Object Dim System As Object Set System = CreateObject("EXTRA.System") Dim Sess0 As Object Set Sess0 = System.ActiveSession Dim MyArea As Object Set MyArea =...

Did you try the code I posted?

Nightshade74, not sure what your code is but give this a whirl for a test Sub Main() Dim Sys As Object, Sess As Object, MyScreen As Object Dim MyArea As Object Set Sys = CreateObject("EXTRA.System") Set Sess = Sys.ActiveSession Set MyScreen = Sess.Screen...

are you correcting the screens manually? you can/should use a "helper" column in Excel that will mark off where you left off, so when you run the macro again, it will know where to begin. another method would be to click in the cell and have your script recognize the cell you are in and use...

Silver180, Sess1.Screen.SendKeys ("<End>") maybe ? Sess1.Screen.SendKeys ("<ErEOF>") if you look at the key properties in the Keyboard Map Editor, it will list all the available strings

do you have Extra installed? your code looks good.

sorry, I don't know how to do that. did you post this question in the vb6 forum?

2009luca: This how I figured out how to do this. I opened a session and saved it as a layout. Open up the layout .ELF file with the macro editor and it will reveal how to open up that specific session. To close the session, all you need to do is to iterate all your sessions to find your specific...

@Skip, I was thinking that if "TOTALS" was found, then it has to be the last page. then the script can do one final screenscraping, then exit. maybe something like this: If Sess0.Screen.Search("TOTAL") = ("TOTAL") Then For i = 10 To 21...

what happens if you move If Sess0.Screen.Search("TOTAL") = ("TOTAL") Then Exit Do to right after Do instead of after Next i

once you reach the last page and you evoke <PF8>, what happens? when does the word "TOTAL" appear?

Biznez, please answer Skip's question WHAT still does not work?

dim obj as object