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 derfloh 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: *

  1. pkmoore

    Vlookup on a file without opening it?

    Thanks, that is what I do now. I take the spreadsheet they send me, copy the cells (part numbers), past them into a table called Generic_PartNums and run an access query. Then paste into excel and do a vlookup from the output back to the part numbers. Can't just paste the output back in, in...
  2. pkmoore

    Vlookup on a file without opening it?

    Thanx, but I'm not making myself clear in my needs. I have asked this question before and can't seem to get the answer I'm looking for. Yes, I've tried that. Here's the deal. I have a database that has 50,000 records in it that contain things like part_number, Cost, Price, Descriptions, etc...
  3. 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...
  4. pkmoore

    Quey Access within Excel

    Thanks, for the replys!! But here is my problem. I don't want the user (user of the spreadsheet) to even know that it is getting the data from Access. Here is what I am doing today: Part ID COST ------- ------ 1234567 8277282 7728821 2099288 7782991 Now the user hits a button on the...
  5. 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...
  6. 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!!
  7. pkmoore

    Get a file datestamp prior to opening file.

    Thanks for the help. Works Great!!
  8. 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