Re: $$Excel-Macros$$ Help on this task please

2010-02-03 Thread KC Cheung
pe mismatch" & it highlights Call > searchsub(full_dir) > > On Feb 2, 8:20 pm, KC Cheung wrote: > > Air code, not tested > > > > Sub all_2010() > > ' Macro to searh & display PDf files > > Dim i As Long > > dim d1 as string > >

Re: $$Excel-Macros$$ Help on this task please

2010-02-02 Thread KC Cheung
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