Recent content by LearningAsIGo

Can't you use a custom Format to make it look like a date. Something like: 00\/00\/00

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

have you tried using object.HostName

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...

If the Strings were all the same length could you change the size of the TextBox so that only one line would fit in a given width?

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

Thanks Skip, that is exactly what I needed! Would GetSaveAsFilename() work for Saving?

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.