Thank You So Much!!!
It works great
On Feb 3, 8:58 pm, KC Cheung cheung.kc...@gmail.com wrote:
add one more dim statement as below
Dim d1 As String
Dim d2 As String
Dim d3 As String
Dim d4 As String
Dim full_dir As String
On Thu, Feb 4, 2010 at 12:44 AM, Dave
Thanks for the help I am getting a compile error when I run the code.
the error is ByRef argument type mismatch it highlights Call
searchsub(full_dir)
On Feb 2, 8:20 pm, KC Cheung cheung.kc...@gmail.com wrote:
Air code, not tested
Sub all_2010()
' Macro to searh display PDf files
Dim i As
add one more dim statement as below
Dim d1 As String
Dim d2 As String
Dim d3 As String
Dim d4 As String
Dim full_dir As String
On Thu, Feb 4, 2010 at 12:44 AM, Dave davidstev...@gmail.com wrote:
Thanks for the help I am getting a compile error when I run the code.
the error is ByRef
I have the code listed below that searches a folder and if it finds
any PDF files its displays them with a hyperlink in the spreadsheet.
My
problem is that under the MAIN folder I have tons of files now and
its very hard to find the PDF I am looking for.
I redid my file structure under main and
Air code, not tested
Sub all_2010()
' Macro to searh display PDf files
Dim i As Long
dim d1 as string
dim d2 as string
dim d3 as string
dim d4 as string
d1=inputbox(Select year, 1988-2010)
d2=inputbox(Select months, Jan-Dec)
d3=inputbox(Select A or B folder, default to both)
if d3= then