Member Avatar for Divinedar

I am trying to do the following in excel 2010:

For instance:

If I have a directory file name "Brazilian Navy Ku" and then I have another directory file folder name " Brazilian Aeronautical VSAT Spares"; then it will go through the first directory file folder name, search for excel files, open the excel file, search for any worksheet tab with tab format XX.XXX or tab format XX.XXX.XX, then retrieve information from certain cells within that excel file.

I just need to be able to have it search within a folder by a certain name criteria of the folder name. I only need to search file folders that meet the criteria specified within the criteria box.

  • 1 Contributor
  • 1 Reply
  • 247 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Divinedar
Member Avatar for Divinedar

any help anybody?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.