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 derfloh 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. marcdibi

    Use of Variable Customized Button in Excel/VB6...Need Help.

    Combo, I am working on using your idea to set the name of the 'variable' button. Da, I'm confused... Andrzejek, I have fun. I assigned this code gstrLetter = "2-Pole_NBL_1S_MDR" in his specific macro. So when I click first on *ANALYSIS* *2-Pole_NBL_1S_MDR*, my 'variable' button associated to...
  2. marcdibi

    Use of Variable Customized Button in Excel/VB6...Need Help.

    How do I specify gstrLetter as a variable passed into Mysub()? Public gstrLetter As String Sub MySub() ' ' Macro created 03/20/2008 by Marc Dibi ' Close #5 ' Open Filename For Output As 5 Filename = Sheet7.Cells(1, 7).Text Open Filename For Output As 5 Select Case gstrLetter Case...
  3. marcdibi

    Use of Variable Customized Button in Excel/VB6...Need Help.

    I believe those buttons would be easier to affect in the 'variable' button, for different reasons: This is not a code, just an explanation *ANALYSIS* *2-Pole_NBL_1S_MDR* *2-Pole_NBH_1S_SMR* *2-Pole_INBL_1S_MDR* *2-Pole_MZL_1S_MDR* *2-Pole_MZH_1S_SMR* *2-Pole_MZH_2S_SMR*...
  4. marcdibi

    Use of Variable Customized Button in Excel/VB6...Need Help.

    Andrzejek, The MySub() macro show up now in the Assign Macro box of Excel to be assign to the 'variable' button. I don't get what is "2" and "7" in the code: .Range(gstrLetter & "2:" & gstrLetter & "7").Select Combo do you have an example for your idea? Let's start from the beginning: I...
  5. marcdibi

    Use of Variable Customized Button in Excel/VB6...Need Help.

    Is it possible to specify in VB6 that clicking on a customized button "A" in Excel will set the Global Variable strLetter to "A"? Then to assign this strLetter as the name of a 'variable' button? X(|)X Let say button "A" is in custom toolbar ANALYSIS and the 'variable' button is in custom...
  6. marcdibi

    Use of Variable Customized Button in Excel/VB6...Need Help.

    Hello, I need help for the following item: I have 18 customized buttons in Excel with their macros in VB6 and once I click on one of those buttons, I want to remmber this action in another button. For instance, if I click on button A, the 'variable' button will do the same action as button A...
  7. marcdibi

    How to kill a shell task ID

    Awesome! That so beautiful! You should see it! Ha Ha! ;) Thanks Brian! Regars, Marc Dibi
  8. marcdibi

    How to kill a shell task ID

    No, just coping to much script from the help...:| Sub Analysis_Genesys() KillProcess (Genesys) Dim dTaskID As Double, path As String Dim myObj As Object path = "C:\Program Files\GENESYS2008.01\Bin\Genesys.exe" Filename2 = Sheet7.Cells(1, 12).Text ' Genesys application exits? Set myObj =...
  9. marcdibi

    How to kill a shell task ID

    RivetHed, The second code doesn't give me an error, but the first one did. Maybe Genesys is not recognized as an application...? Brian, You Welcome for the star and thanks for the TGML process. I need help, since both KillProcess do nothing. I stored your code in another module in my VBA/Excel...
  10. marcdibi

    How to kill a shell task ID

    Hi Brian, How do you put stuff in CODE presentation like you did in your reply? Thanks. Marc
  11. marcdibi

    How to kill a shell task ID

    RivetHed, Thanks for your hand.It makes sense to try. Brian, Thanks for the code. I'll test it and let you know. Regards, Marc
  12. marcdibi

    How to kill a shell task ID

    Hello I have extensive crystal filter design software under, Excel/VB6 that I am linking to Eagleware for analysis. I am able to toggle between the design software and Eagleware. This is where I need help . . .how do I check if dTaskID already exists (if YES kill it --> close the Eagleware...

Part and Inventory Search

Back
Top