Search results for query: *

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

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

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.

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.

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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?