Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LearningAsIGo

    trying to convert a mixed up numbere to a date in excel

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

    Startup Macro Help

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

    connection question

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

    connection question

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

    connection question

    have you tried using object.HostName
  6. LearningAsIGo

    How do I use CreateObject?

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

    Creating a new line in a textbox

    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?
  8. LearningAsIGo

    Creating a new line in a textbox

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

    user picks an excel file to open

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

    user picks an excel file to open

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

    How Can I use Subtraction With GetString

    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 =...
  12. LearningAsIGo

    How Can I use Subtraction With GetString

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

    How Can I use Subtraction With GetString

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

    How Can I use Subtraction With GetString

    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$ =...
  15. LearningAsIGo

    How Can I use Subtraction With GetString

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

    How Can I use Subtraction With GetString

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

    Setting timer to close a message box

    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?
  18. LearningAsIGo

    Setting timer to close a message box

    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.

Part and Inventory Search

Back
Top