Search results for query: *

Thanks, stars to both.

The split function works great. When I get to the newstrRetval(0) retval = Split(newstr, "_") I get an error on the newstrRetval(0) line saying "Sub or Function not defined." Any ideas?

Help. I have spent hours searching for a solution to this on tek-tips already. I have been trying to use the wildcard * but with no success. I need to replace the 162 between the _ and the . in the following string: "100 -nmin( (ROUND( MERGEDATA_162.FNU_FREQPERC_F ,0) + ROUND(...

I am having the same trouble getting acrobat.exe to open a pdf. Shell "C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe.exe ""path and file name here and yes keep all the quotes """""

Thank you both for all your help. It works perfectly.

VBAjedi, Exactly. I am not sure how to set TestWorkbook to my file. Everything I've tried gives me an error. Here is an example. Dim TestWorkbook As Workbook Set TestWorkbook = Workbooks("C:\AA\Bill\HasPassword\The Rockefeller Foundation.xls") If...

Zathras, Thanks for the code. This works; however, the code still halts upon opening of the excel and waits for me to hit the cancel button. I am trying to skip this step otherwise someone will have to sit while this code runs and hit the cancel button all the time. There will be thousands...

I have a directory with numerous excel files some of these files are password protected. I will be moving all of these files into 2 different directories. One directory will hold the password protected files, the other directory will hold the files with no protection. Dim FileName As String...

I have a directory with numerous excel files some of these files are password protected. I will be moving all of these files into 2 different directories. One directory will hold the password protected files, the other directory will hold the files with no protection. Dim FileName As String...

I understand now how to create a new module from within a module but I don't want to create a new module. I want to write a module that will open a form and place a sub procedure in that form. The sub procedure will actually be the on-click event for a check box. Thanks ahead of time.

Thanks for the info. However, instead of creating a module, I need the CreateCode routine to place the code into the on-click event of a checkbox on a certain form. Any suggestions?

I have a module that creates checkboxes on a form based on data in a table. This works just fine; however, I also need to get code into the on-click event of these checkboxes but don't know how to do that when I create them with the module.