Does this happen when you start the Session manualy or only when starting it from the Excel Macro?
That is the Same version of Extra I am using and I can set start up macros.
If it works when you open the Session and not when the Excel macro opens the Session, could the macro be opening a...
You are right, Sess0.HostName doesn't work when using an IBM Mainframe. I couldn't find anything that would work with an IBM Mainframe, sorry... maybe someone else can come up with the solution
it might be something like this depending on your system object: sess0.hostname
you can check it in a message box:msgbox sess0.hostname
it is in the help topics of the macro editor under HostName property
I've been trying to figure out how to declare a CreateObject, but i don't know what to use for the statement or how to find it. Using what i found for Excel
Set AppExcel = CreateObject("Excel.Application")
I tried to use the same thing to create a Windows Media Player object with...
This is what I did when I was having the same problem
NL$ = Chr$(10)
EndMsgtext$ = String1 & NL & String2 & NL & String3
MsgBox EndMsgtext
I changed the Chr$ number until I found the one that worked.
Hope this helps you
i was wondering if there was a way to create an open file dialog box like Windows has that allows users to pick the file location. I would like to use it when scraping from excel to Extra!X-treme.
I was thinking about using an input box but that would be too complicated for some of users...
It still wasn't working. I seperated everything out at the thousands seperators, it works, but it isn't pretty.
TotalSubjectMillion = MuScreen.GetString(14,67,3)
TotalSubjectMillion = TotalSubjectMillion*1000000
TotalSubjectThousnad = MuScreen.GetString(14,71,3)
TotalSubjectThousnad =...
the data i am using to test is:
TotalSubject = 2,311,934.00
TotalPit = 2,293,702.00
TotalPitwhld = 32,541.32
BWSTotalSubject = 2,331,014.80
BWSTotalPit = 2,313,882.83
BWSTotalPitwhld = 32,541.32
The numbers get scraped as i wrote them, and when I used your IF statement, I got a type mismatch...
thanks for the reply, but the numbers fail your If statement and I get a type mismatch error.
I also took off the Val function because it stops at the first non-number. If there was a way i could ignore the thousands separator, then it would work.
Could I use the Format as General then the Val...
I hate to post again, but I found the Val function, and now the math is incorrect
'Get Totals from QTRI
MyScreen.Sendkeys("<Home><BackTab>QTRI<Enter>")
MyScreen.WaitHostQuiet(g_HostSettleTime)
MyScreen.MoveTo 3,6
MyScreen.Sendkeys(AccountNum1 + AccountNum2 + AccountNum3)
Qtr$ =...
I'm not sure if this matters, but the Strings I am getting have commas in them like 2,311,934.00
I tried to format the commas out
TotalSubject = Format(TotalSubject, General)
But that does not work. Again, thanks for any help.
I think that GetString is not the best way to get data for math opperations, but i don't know the other way to do it. Thanks in advance.
'Get Totals from QTRI
MyScreen.Sendkeys("<Home><BackTab>QTRI<Enter>")
MyScreen.WaitHostQuiet(g_HostSettleTime)
MyScreen.MoveTo 3,6...
Wow! Thank you! I think its a bit more than I need, but learning what each function does will be fun...
Is there a refrence book or manual that I can buy to help me code better?
I was wondering if anyone could point me in the right direction to find out how to set a timer to automatically click close a MsgBox statement after 5 seconds. i don't have any code started for a timer or anything because i don't know where to begin looking. Any help would be appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.