Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Nick V
  • Content: Threads
  • Order by date
  1. Nick V

    Ignore Hidden Sheet & AutoFill Fail Safe

    Hi all, I have managed to make a loop which looks through all tabs in all files (both tabs and files are unspecified). The code copies a set of data and pastes into a Data Dump file. There is a problem when there is only ONE entry in any tab due to the AutoFill section of the macro. Would...
  2. Nick V

    Pasted ID number from .txt data, find and paste relevant .pdf filepath

    Thanks to Skip and Andy for helping me construct a VBA which grabs .txt data and pastes it into a single spreadsheet. Invoice File There are three companies and all of which have different filename for their .pdf invoice file. When pasting the .txt data: D01CC96625668...
  3. Nick V

    Loop through all Sub Folders & copy data in .txt files into individual tabs

    Hi all, Quickly : There are folders for each month of the calendar year and in those month's folders are sub-folders which belong to various companies. In the company's folder are more folders which holds .txt files that I need the the contents to be extracted from. Essentially, in folder...

Part and Inventory Search

Back
Top