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!

  • Congratulations wOOdy-Soft 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: *

  • Users: ngerman01
  • Content: Threads
  • Order by date
  1. ngerman01

    Speeding up VBA array program

    Right now i have a program that that collect 2 columns of data out of excel and puts them into an array. The way i am doing this is as follows Range("B1").Select For I = 0 To 16000 pH(I, 0) = ActiveCell pH(I, 2) = ActiveCell.Offset(0, 1) ActiveCell.Offset(1, 0).Select Next...
  2. ngerman01

    msgbox function

    I need to run a macro out of excel that will open a labeling program and then have a message box appear in the labeling program. Also on a side note is there a way to pause vba code for a set amount of time without pause the rest of the computer. I have tried using Application.Wait, but that...
  3. ngerman01

    Load Label error/not doing anything

    I am trying to load a label on labeling software thru vba, i am not sure what the function should be. In the labeling software guide they give this function: Public Function LoadLabel(strLBL File As String)As Interger I am not sure on how to impliment that into the program
  4. ngerman01

    How to close a program using VBA

    Trying to write a VBA code to be used in excel to first close a priting software, reopen the same software, open a file for printing, and then print. I have the software opening part done, but to first close it is what i need help with.
  5. ngerman01

    Opening a program that requires login & password with shell

    I am trying to open a program using the shell function in VBA, but the program requires a userid and password to get in. I am not sure what commands must be given. Any help would be appriciated. Thanks

Part and Inventory Search

Back
Top