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!

Register Log in
  • Congratulations Rhinorhino 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. Chotor

    check boxes

    From the help file: Dialog (function) Example <Close> <Copy> <Print> This example creates a dialog box with a drop down combo box in it and three buttons: OK, Cancel, and Help. The Dialog function used here enables the subroutine to trap when the user clicks on any of these buttons. Sub main...
  2. Chotor

    Reading contents of a mail from Outlook?

    Nice, thanks. I'll keep this for reference. I actually accomplished what I wanted to do antoher way: I move those mails into a separate folder (with Outlook). What I discovered is that Outlook indexes mails in a folder from 1 to n, 1 being the oldest item and n is the newest item. So what I do...
  3. Chotor

    Multiple Variable PutString from Excel to Attachmate

    I would try to debug the code (for example, make MsgBox ("code ok so far") every now and then) to find out exactly where your code fails. I'm guessing you're using a call to an Excel function incorrectly/unsupported method.
  4. Chotor

    Reading contents of a mail from Outlook?

    Instead of spamming the forum with a new thread, I'm trying to ask here first. How do I read a specific mail? I know who sends it (I recieve one every day) and the subject. I want to read today's email from this person.
  5. Chotor

    Reading contents of a mail from Outlook?

    Thanks. After some programming, I'm now able to read the mail's contents (body). I'm using Set theseItems = thisFolder.Folders("Inbox").Items(4) Dim lineJPY As String Dim HeMail As String HeMail = theseItems.Body lineJPY = ExtractToCR(HeMail, "JPY") Msgbox "JPY: "+lineJPY ExtractToCR is...
  6. Chotor

    Reading contents of a mail from Outlook?

    I want to read a specific mail (arriving every day) from my Inbox. This mail is uniquely identifiable by for example sender. Also, I have this mail item open. How can I read a specific mail? Preferably the one I have open. Thanks to another poster, I have this: Dim thisApp As Object...
  7. Chotor

    Send keys as keys, not a string?

    Got it. It's <NewLine>. Should have checked better... :P Sorry for the trouble.
  8. Chotor

    Send keys as keys, not a string?

    I build up a string to send to Extra later. The string has 4 elements, each of which is either "N" or "<Ctrl+M>" (the ENTER key). Example: "NN<Ctrl+M>N" or "NNN<Ctrl+M>" or "<Ctrl+M>NNN" or "NNNN" etc... The problem is that <Ctrl+M> is recieved by Extra as the string <Ctrl+M>, and not the ENTER...
  9. Chotor

    Excel code for dynamic linking from Extra?

    Cheers. What I did was to copy a small part of the screen (just one number) and paste it in one Excel cell. This creates a link with the code as the first post. It's working now (I had forgotten to restart my sheet). The numbers now update in real-time.
  10. Chotor

    Excel code for dynamic linking from Extra?

    Skip, thanks for answering and taking the time to write that code. I'm really only looking for a link in Excel. The thing is, the values in Extra will change randomly, and I don't want to run a macro every now and then. I'm monitoring 7-8 lines in Extra. I want Excel to update in real time...
  11. Chotor

    Excel code for dynamic linking from Extra?

    Hi I need to display some values from Extra in Excel (for calculation reasons). I've tried to copy-paste a small area, and end up with this code: ='EXTRA!.Session.1'|'\\SERVER001N\MYUSER8$\E!PC\SESSIONS\MY-SESSION.EDP'!\R7C9R7C14M1 Why is this not working? Is there some other code to use...
  12. Chotor

    Do code IF order NOT qualifies

    Haha! I know I ask a lot. Sorry about that. Yes, I have checked the help file, but couldn't find a separate section with "Arrays". It's just scattered here and there. Now when I know it, I see ubound when I search for arrays. My main language is Java. I'm not very familiar with VBA, so I have...
  13. Chotor

    Do code IF order NOT qualifies

    Yes, I realize that. Any tips as to how to get the length of an array in this language? This programming language is pretty ...emmm... BASIC. :P
  14. Chotor

    Do code IF order NOT qualifies

    The (qualified) list is static, but selected element is not (Darth Vader is just an example). I want to know if selected element is on that list or not (within an IF).
  15. Chotor

    Do code IF order NOT qualifies

    Thanks. That code will most likely do the job. I was looking for something neater, though. Something with booleans. Like where the list of my qualified items are TRUE, and if I compare my selected element to that list, it renders FALSE (since that item is not in list). Something like...
  16. Chotor

    Do code IF order NOT qualifies

    This is more a general programming question than a specific Extra Basic question. I have a list of maybe 200 (or more) orders. I do a request for orders many times daily. Now I want to execute a specific code if order is NOT qualified (which is maybe 180 of them). (10% of orders qualify...
  17. Chotor

    Linking from Excel clone?

    Thanks, man! Got it working now. For reference, I used lookup_value = xlApp.WorksheetFunction.VLookup("Canada", LandRange, 12, 0) where 12 means Column L, and 0 means FALSE. One learns something every day. I'll be back with more questions shortly! :D
  18. Chotor

    Linking from Excel clone?

    Thanks, Skip! I am trying your code, but I get "no such property or method". I've been playing around a bit and Set LandRange = xlApp.activesheet.Range("A1:A25") Set PropRange = xlApp.activesheet.Range("L1:L25") lookup_value =...
  19. Chotor

    Linking from Excel clone?

    Thanks. I can now connect to "Excel" and retrieve information. Next step is LOOKUP. In Excel, =LOOKUP("Canada", A5:A25, L5:L25) gives me what I want. When I try to translate this into Extra, I get an error: Set LandRange = xlApp.activesheet.Range("A1:A25") Set PropRange =...
  20. Chotor

    Linking from Excel clone?

    Hi. I have an application called PowerPlus Pro, which is basically Excel with plugins. My ultimate goal is to read fields in Extra, lookup relevant values in PowerPlus Pro/Excel, and write those values back into Extra. My first challenge is: How do make a connection between Extra and PPP?

Part and Inventory Search

Back
Top