Skip to content

Simple Excel VBA

Make your office life easier with simple and fast Excel VBA solutions.

  • Home
  • Posts
  • Videos
  • Memes
  • SAP VBA
  • My music
  • About me
  • YouTube
  • Facebook
  • Buy me a coffee
  • Pinterest
Simple Excel VBA

Tag: dir

The fastest way to find the file in chosen location

Last time I showed You how to loop through folders and files. But was that the fastest way? In today’s article I’m going to compare the speed of loops through files methods and get the fastest way to find the file.

The fastest way to find the file in chosen location jeremy clarkson
Continue reading “The fastest way to find the file in chosen location”
Author Tomasz PłocińskiPosted on 06/04/202003/08/2021Categories Excel, Excel VBATags dir, Excel, fastest way to find file in chosen location, files, folders, how to loop through files and folders with file system object using vba, VBA4 Comments on The fastest way to find the file in chosen location

Search for article

Categories

  • Arrays
  • Charts
  • Excel
  • Excel VBA
  • http
  • Internet Explorer
  • Outlook
  • PDF
  • PowerPoint
  • Python
  • SAP
  • SQL
  • VBE
  • Video
  • Web automation
  • Word
  • XML
  • Home
  • Posts
  • Videos
  • Memes
  • SAP VBA
  • My music
  • About me
  • YouTube
  • Facebook
  • Buy me a coffee
  • Pinterest
Simple Excel VBA Proudly powered by WordPress