Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Pfd file open using shell command

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shell command writes file to wrong directory Dustin Excel Programming 2 October 25th 07 07:06 PM
send parameters to a batch file with the shell command Marcos[_2_] Excel Programming 6 May 28th 06 07:53 PM
how shell open AcroReader w/command line filename? Ian Elliott Excel Programming 2 October 17th 05 07:10 PM
Shell command and exe file conundrum Greg Wilson[_4_] Excel Programming 2 September 4th 04 09:24 PM
Copying a file with VBA (or with a SHELL command) Franck V. Excel Programming 1 September 15th 03 07:46 PM


All times are GMT +1. The time now is 12:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"