Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have gotten some code from Barb Reinhardt some time ago, but want to add
some more code to it. I want it to not only search that folder but all of the subfolders in that same directory. i know that the file applicationfile.search has a subdir property, but i couldn't use that solution, so barb gave me this. How do i make this code search the sub folders? Is there a property that does this? Private Sub Lbx_file_names_DblClick(ByVal Cancel As MSForms.ReturnBoolean) ' If (Lbx_file_names.Value < "") Then ' Adobe_Filename_Pick = Lbx_file_names.Value ' End If ' If (Adobe_Filename_Pick < "") Then ' Shell "C:\Program Files (x86)\Adobe\Acrobat 9.0\Acrobat\Acrobat.exe" & _ (" " + MyFolder + Adobe_Filename_Pick), 1 '" X:\Omar\Finished_Flanges\14_600_RTJ_WN_S40.pdf", 1 ' ' the following prints the document 'Application.SendKeys "^p~", False ' End If ' End Sub Thanks, Omar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
code modification | Excel Programming | |||
modification to this code | Excel Discussion (Misc queries) | |||
Code Modification | Excel Programming | |||
Modification in the CODE to HIDE rows and columns that start with ZERO (code given) | Excel Programming | |||
modification for the code | Excel Programming |