J
jedireg
I have an access database which tracks receiving inspection data on outside
vend product.
In the event that something is found to be out of specification, I would
like to issue a corrective
action request ( aka 8D ) to the vendor. I have the excel spreadsheet developed
already and
want to click a button on the access form and have it open up the excel template,
place information
into certain cells ( can be names ranges ) and then save the excel file with
the current record number
and vendor name ( all of which is available on the access form).
I can find lots of information on pulling the data from the excel side or
for pushing data from excel into
access and I have done this in the past. This time however I want to push
the data from access into
the predesigned excel sheet.
I would appreciate any help in the direction that I need to be going.
Thanks
Glen
vend product.
In the event that something is found to be out of specification, I would
like to issue a corrective
action request ( aka 8D ) to the vendor. I have the excel spreadsheet developed
already and
want to click a button on the access form and have it open up the excel template,
place information
into certain cells ( can be names ranges ) and then save the excel file with
the current record number
and vendor name ( all of which is available on the access form).
I can find lots of information on pulling the data from the excel side or
for pushing data from excel into
access and I have done this in the past. This time however I want to push
the data from access into
the predesigned excel sheet.
I would appreciate any help in the direction that I need to be going.
Thanks
Glen