How to browse folder and open xls file automatically in vba?
Bobs code works fine. You select the workbooks you want to open in the
folder you browse to and his code opens them.
Are you wanting to just select a folder and have the code automatically open
all Excel files in that folder? Try to be more specific on your needs.
--
Cheers,
Ryan
"geniusideas" wrote:
Sorry Bob,
I can browse the folder but unable to open file inside
automatically..Still need to select.Pls help again.Thanks
.
|