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 mnik3

  1. mnik3

    Are there additional events in VBA?

    Alright, thank you!
  2. mnik3

    Are there additional events in VBA?

    WM_WINDOWPOSCHANGED, WM_WINDOWPOSCHANGING. This little project is mainly just to increase my experience with subclassing. I hadn't really planned on changing what I've got, I read something this morning and then it occurred to me that maybe VBA had a built-in message capturing mechanism that...
  3. mnik3

    Are there additional events in VBA?

    So are there "friendly" forms for capturing other messages, so that I don't have to worry about correctly hooking/unhooking?
  4. mnik3

    Are there additional events in VBA?

    So, as far as I can tell, the "events" in VBA Userforms (such as UserForm1_Click, ect..) are either very similar or identical to SendMessage + BN_CLICKED. So, that leads to my question, are there additional events that you can filter for? Not the _Terminate and _Activate type of events in the...
  5. mnik3

    Treeview System File/Folder Directory in UserForm

    Well, nobody replied, but I did some digging on MSDN today and this is what I came up with if anybody else wants help with this project. Works like a dream. Private Sub UserForm_Initialize() Me.TreeView1.ImageList = Me.ImageList1 'I have an image of a folder as Image1 and an icon as Image2...
  6. mnik3

    Treeview System File/Folder Directory in UserForm

    I haven't been able to find many examples of how to create a treeview directory of files and folders in the system in a treeview control for Excel VBA. I have come up with some code that will do it, but it's really touchy (sometimes identical node keys are generated or I run out of room in the...
  7. mnik3

    VBScript with html... script does not launch application

    Could someone please explain to me why my script is not launching the targeted application (it works just fine outside of the .html file as a .vbs file, and if you have some .html knowledge, why are my area maps not working correctly(there are blue borders around the enclosed area, but they are...
  8. mnik3

    How to open new instance of excel during use of UserForm

    So, essentially I have made an instant messenger with Excel, which uses a VBScript to notify the VBA code to fire a certain sub when a parameter is met. In the code Application.Visible = False, so my problem actually lies with opening any different Excel files through their respective shortcuts...
  9. mnik3

    Automation Error with GetWindowText and Dynawrap

    Tsuji, it WILL retrieve the window text, however, the specified return value in "i=lrl" of r, which is to pass by reference, seems to be limited to 48 characters. I disagree that the implementation is incorrect. There is only one other similar function that I know of; InternalGetWindowText does...
  10. mnik3

    Automation Error with GetWindowText and Dynawrap

    I am using Dynawrap to get text from a dialog box, and when I try to grab anything of the class "Static", I receive the following error: "Run-time error '-2147417848 (80010108)': Automation error. The object invoked has disconnected from its clients." I wrote the code for VBS but copied the code...
See more

Part and Inventory Search

Back
Top