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!

Recent content by lmbayley

  1. lmbayley

    Attachmate - Read Cursor Location

    Skip, could you elaborate on your post of 17 Aug 09 11:44 ? 1) Do you mean you store your field information in an Excel table? 2) How do you go about using the information in the table when you're looking for something in the screen string? I'm working on a macro where I'm going to be...
  2. lmbayley

    Attachmate to Excel, SaveAs the open Workbook

    Hi, I think the problem is that you haven't declared the workbook itself as an object. Try this: In your declarations: dim xlWorkbook as object Then to open and save the workbook: Set xlWorkbook = xlApp.Workbooks.Open("Test.xls") xlWorkbook.SaveAs("TestSave.xls") -LB
  3. lmbayley

    why doesn't this code work

    Skip, Have a * for your posts of May 12 at 9:18 and 9:39. Your example of how to use MoveRelative and WaitForCursor just opened up whole new lines of thought for me! Cheers, -LB
  4. lmbayley

    How do I refer to an 'empty' listbox in VBA code?

    Wakayama, You say you're using listboxes that only allow single selections? In a listbox with the MultiSelect property set to fmMultiSelectSingle, I always know that the listbox doesn't have a selection if ListIndex = -1 . -LB
  5. lmbayley

    Linking Excel to Outlook Contact folder

    fireydad and hermanlaksko, A star to both of you. I was about to post a slightly different problem when I saw this thread. (I needed a way to iterate through a part of the Global Address List starting at a specified name.) Between the two of you, you gave me exactly what I needed to solve my...
  6. lmbayley

    VB.Net & Screen.Srch Function

    Hello answers123, Have you tried this: Set Srch = MyScreen.Search("ABC") I believe you have to do it with the Set statement because you're assigning a value to an object, not a variable. If you were just looking for, say, the Top coordinate, then something like dim SrchTopLine as Integer...
  7. lmbayley

    Automated Setup of HotSpot (or anything)

    Thanks for the pointer, Skie! Have a star! -LB
  8. lmbayley

    Copy Scrolling Data To .txt File

    vzdog, You never actually write anything to the file with this code. Try this after your loop that reads the screen: fn = freefile FileName$ = "E:\Network Elements\NE Summary.txt" open Filename for output as fn print #fn, Screenbuf$ close #fn Note that I opened Filename for output rather...
  9. lmbayley

    Automated Setup of HotSpot (or anything)

    Skie, I too am forever going around installing HotSpots. I had a look in my Extra80 folder (we're using Extra 8.0), but I couldn't figure out which file you meant by the "session file". Could you elaborate? Thanks, -LB
  10. lmbayley

    Change Paste Options under Edit Settings via macro

    Check out the Attachmate Extra help for the EditScheme property. I think that should get you pointed in the right direction. -LB
  11. lmbayley

    DropComboBox and the 50 States

    You can set up your list of choices like this: ListOfChoices = "Alaska AK" _ +chr(9) + "Arizona AZ" _ +chr(9) + "Arkansas AR" so your declaration will look like this: DropComboBox 9, 17, 111, 41, ListOfChoices, .ComboBox1 Now, to call your dialog box: Done = FALSE While Done...
  12. lmbayley

    From Attachmate to SQL

    DemBones79, I often use an Access database to hold information, and add to it from an Extra macro: dim cnn as object set cnn = createobject("ADODB.Connection") dim rst as object set rst = createobject("ADODB.Recordset") MyConn = "C:\Example.mdb" ' open the connection With cnn...
  13. lmbayley

    Why is PageSetup so slooooow?

    Sigh. Skip, now I see which post you were referring to. When I read your idea the first time, it didn't seem to say the same thing as what I was thinking, probably because you said it in words, rather than code. I apologize for my snarky response in the second paragraph of my previous post...
  14. lmbayley

    Why is PageSetup so slooooow?

    Skip, I was honestly trying to contribute to this forum. Did you really need to slam me like that? I've only been programming for a couple of years, so maybe I don't know the difference. But it looked to me like my way of working through all the sheets was different from your way. You...
  15. lmbayley

    Why is PageSetup so slooooow?

    Okay, so here's my two thoughts on the matter. First, whenever I know I have to have the same formatting on a bunch of sheets, I'll put that formatting into my Workbook_BeforePrint sub. To make it so that it doesn't go super-slow each time I print-preview a document, I only tell it to format a...
See more

Part and Inventory Search

Back
Top