hi, Jen !

1) it's not so clear if you have done this part (or you are looking for a way to do)...
2) however, AFAICS, you have it solved as per your comment...
(but it is not clear if this is a *.csv or an *.xls file ?)

3) also, if you know what you say to know (again, as per your comment)...
4) there are many ways to get data from a closed file
(ADO, ms-query, excecuteexcel4macro, the function "pull" from HG, etc.)
also, you could try Ron de Bruin's "Copy/Paste/Merge examples" section from here...
http://www.rondebruin.nl/tips.htm

if any doubt (or further infomation)... would you please comment ?
regards,
hector.

__ 1 __
I can export the list of jobs for the previous week from salesforce and
I want to drop that data into Excel then have it programmatically go pull the data
from the fields I need in the associated workbooks so
I can simply create a macro to create the CSV file which can then be uploaded.

__ 2 __
... the important thing is I have a list that looks something like
QC Record : Job Name : Listing Count : Date
201002-18485-QC : HD-11311-TA031110 : 263 : 3/15/10
201003-15737-QC : SHT-100312 : 103 : 3/14/10
201002-18327-QC : 032110Mag : 246 : 3/17/10
201001-18510-QC: TSA-100321 : 411 : 3/15/10
...

__ 3 __
Since I know the job name I know there's a file that exists in a folder called \\de-mt1\clients\QC Reports\Proofs Adjusted\.
The file will be called, for example, \\de-mt1\clients\QC Reports\Proofs Adjusted\HD-100311-TA031110 proof adjusted.xls
where HD-100311-TA031110 is the only piece of information that will ever change and it will always be the job name.
From the "Upload" tab I need to start grabbing the data from cell A2, B2, C2, D2, and so on.

__ 4 __
List of job names is 100% dynamic and the list varies in length from probably 50 to hundreds in their peak season.