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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LuAlPa

  1. LuAlPa

    variable variable name

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

    variable variable name

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

    variable variable name

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

    Displaying Methods and/or Properties

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

    variable variable name

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

    variable variable name

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

    Displaying Methods and/or Properties

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

    Displaying Methods and/or Properties

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

    variable variable name

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

    convert a string Date into a formated one

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

    variable variable name

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

    IE.document assistance needed

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

    Handling PDF files with VBA

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

    Handling PDF files with VBA

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

    Handling PDF files with VBA

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

Part and Inventory Search

Back
Top