Search results for query: *

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...

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...

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...

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...

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...

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!!

Thanks for the help. Works Great!!

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...