Recent content by ngerman01

Thanks to both of you

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

yes i checked out the faq but the place that i want the program to pause is further down the line from the shell(ing).

Also the I am not sure about the if the labeling program is VBA sub. I was told that it was activeX aware, but not really knowing what that means it did not help me. The labeling program itself contains a VBA editor.

Yes to open the program the shell command is being used

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

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

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.

Thanks on a side note how does one close an program thru VBA.

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