Thread: How to browse folder and open xls file automatically in vba?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geniusideas geniusideas is offline
external usenet poster
  
Posts: 70
Default How to browse folder and open xls file automatically in vba?
Hi,
My Task now is to create excel macro that can:
1) User browse folder
2) Click folder--open then
3) Macro will automatically open all Excel file one by one
4) After open --- collect certain data
5) Close file

Anyone pls help for the VBA code.
Thanks



Reply With QuoteReply With Quote