Recent content by LuAlPa

Tony & PH, thank you for the pointers. Between collections and associative arrays we (with my techy guru) will make it happen. Now i will have less time to code since I am in a production environment-- unlike during the weekend. Thank you again Lp

Will see into the dictionary proposal shortly. Another thing I had not heard of. Thank you PHV.

Since I have all the coordinates, I populate the variables with no problem. ORIGIN = trim(myBuffer(12,3,3))

No, I am using VBA. That is the infor I get from the About ... menu in the VBE

IT MAKES ABSOLUTE SENSE. And that is exactly what I am doing at this time. Propose the data to the user but getting ALL data from the buffer (that is the esasy part). What I do not want to do is that big SELECT. I have the name of the field the use wants in my array but I can not seem to...

ok, my fault, Tony. I was actually being a bit misleading. We, mere mortals at a product department level, are not allowed to run a direct, real-time query against the MF database (Ideal Datacom, actually, running under CICS / OS/390 environment). So we screen-scrape a Hummingbird front-end and...

Thank you, Ettiene, but regardless of where the cursor is at (in the code screen) I get no response. The hourglass blinks and dissapears going back to the I beam. It is MS VB 6.5 with Excel 2003 SP3

Is there a simple way to display all supported methods and/or properties for elements like activesheet or activecell or whatever? The compiler shows them but shows EVERYTHING regardless of the element we are currently dealing with. Or am I wrong? Sorry for the lack of formal use of terminology...

The data I am offering are different dates or pieces of data the user can choose from. These are service order that within my company have several dates or statuses. So he chooses like "Entered" "Limit" "Minimum" "Current Status" "Last owner" "Origin" (So basically he gives me the name of the...

If the format is fixed I would say this is even simpler Dim s As String s = "23Mar08" s = Left(s, 2) & " " & Mid(s, 3, 3) & " " & Right(s, 2) MsgBox DateValue(s)

Ok, here is the deal. User picks up to item 4 items form an iterative InputBox. He may actually pick less than 4. I store choices in OptVal(4). Then I access a mainframe data base and based on choices resolve user choices. Result would be to paste to an Excel cell the returned value from the...

I am experimenting with accessing IE from VBA. My company has some web based applications I am trying to access, read and interact with from VBA. Simple stuff. No frames at this stage. But how may I find the properties of the IE.document and where to put data or where to retrieve from. I have...

Hi Aubs, At present I am not processing them in any way except by trying to use PDFgrabber. But the option of exporting using Acrobat Professional is a venue worth exploring. Thank you.

Nothing so far. I have investigated a few products that are around and the only one with some promise seems to be PDFGrabber which transforms PDF into an excel spreadsheet with as many worksheets as necesswary. But nothing from the VBA community

We receive PDF files resembling Excel files. Same position, same data type, over and over again. Has anyone developed a means of opening a PDF file from VBA and getting data into variables? After that generating the Excel file with just the data I need is simple enough. (PDF documents go from 5...