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 bkrike 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: EddyH
  • Content: Threads
  • Order by date
  1. EddyH

    Get path of file still unopened in folder

    By VBA I have found a filename within a known folder, could be .doc file or some other non spreadsheety one. As I am within Excel I wish not to open it but just to capture its filepath. Any offers?
  2. EddyH

    Select filenames fast from a folder's multitude

    I have a multitude of files within a folder being pdf and Excel. They are identified by their leading 3 characters ie ZZf....xls. Ideally only one Excel file will match ZZf in that folder. I want to quickly get the filename inside that folder matching ZZf so I can use it later. Doing this via...
  3. EddyH

    Find rows where natural Excel page breaks occur

    Simple objective:I need to know the row numbers that are just below and just above the natural page breaks in a long Excel file of 1000 rows or so. I am writing a macro to automate thjis and other bits involving text wrapping so VBA method needed. It must be locked away in help somewhere, I...

Part and Inventory Search

Back
Top