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

    Vlookup on a file without opening it?

    Can I use VB to do a vlookup or equivalent to find data in an external file with out first opening that external file (file is to big). The external file is a csv file. Normally I'd open it then do a vlookup against it. Since the file is 150,000 rows I can't do that. So I'd like to write a...
  2. pkmoore

    Quey Access within Excel

    I have a list of part numbers in excel that I want to get external data for. I wrote a VB script to go get the data, but it does it one cell at a time. Connects, fetches, returns data, then moves to next cell and connects, fetches, returns data, over and over until it reaches a blank cell. I...
  3. pkmoore

    How do I launch excel that runs a macro automatically?

    I am trying to use Windows Schedular to launch Excel and run a macro (VB Procedure) that I wrote. I'm having trouble finding out how to do this. Please help!!
  4. pkmoore

    Get a file datestamp prior to opening file.

    Can someone tell me how to check the datestamp of a file to be sure it is the current file (date of file matches today)prior to opening the file with Excel and manipulating it. Thanks!! Pat...

Part and Inventory Search

Back
Top