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

Search results for query: *

  1. pxcpyc

    Shortcut fires Script that opens Excel form and API adds minimize + taskbar. Second instance faulty

    Hi PHV - sorry but I missed your reply somehow Can you clarify which properties you mean? My shortcut is the one that windows creates when I right click on my VBscript file. thanks
  2. pxcpyc

    Shortcut fires Script that opens Excel form and API adds minimize + taskbar. Second instance faulty

    For information of other readers, I have found a way forward: I open my program as described in the first post above then open a second form (off the display area) which I then close, then the API functions work correctly for multiple instances. My fix is in the VBA code area rather than the...
  3. pxcpyc

    Shortcut fires Script that opens Excel form and API adds minimize + taskbar. Second instance faulty

    I found that if I open 2 separate instances of my test program from the 1 script, then they both work perfectly: Dim xlApp Dim PathFileName PathFileName = left(WScript.ScriptFullName,(Len(WScript.ScriptFullName))-(len(WScript.ScriptName))) & "Test1.xlsm" Set xlApp =...
  4. pxcpyc

    Shortcut fires Script that opens Excel form and API adds minimize + taskbar. Second instance faulty

    I have a desktop shortcut to a vbs script (below) that opens Excel (invisible) and displays a form. I use Windows API to add an icon to the titlebar of the form, to add a minimize button to the form, and add the programs name to the Taskbar. This works perfectly. If I double click on the...

Part and Inventory Search

Back
Top