J
jwrnana
I sent the message below, but am now sending as a new post with the previous
information. I was not sure if anyone would see it so far down in a
previous post. Thanks
I hope that one of you can help me with a very similar problem.
I have an access database. I am analyzing a report using microsoft excel.
This creates a worksheet in excel. I have a template that "should" pull the
information from the worksheet. I then email the template format on to an
end user who enters information in fields that are not locked. When this
data is returned, I would like to be able to have my database pull the data
from the worksheets.
Here are my problems:
1. I am a novice at this and am probably over my head, but I am trying.
2. I do not change the information location; i.e. cells, type of info,
when I am analyzing with excel. I do, however, answer yes when asked "There
is already a "dealer worksheet file". Do you want to create a new one?
When opened, the template should pull the information from the cells.
a. The information is not pulling over to the template, and I have
to relink the worksheet cell by cell to the template, or
b. If the information pulls, it does not insert the info in the
correct location on the template.
Once I get the template to contain the correct information, I protect all
but a few cells and email to end-user.
1. How do I take info that is emailed back - the original template with
information inserted - and has access pull that info into the access
database without manually key punching info?
I have tried to go to Data/Export/Excel, but my query has 4 parameters that
the end-user must complete; therefore, all info is not exported to excel.
This is why I am creating a report via query and then analyzing it with
excel.
Many many thanks for your help. Any suggestions and assistance will be
greatly appreciated!
JR
information. I was not sure if anyone would see it so far down in a
previous post. Thanks
I hope that one of you can help me with a very similar problem.
I have an access database. I am analyzing a report using microsoft excel.
This creates a worksheet in excel. I have a template that "should" pull the
information from the worksheet. I then email the template format on to an
end user who enters information in fields that are not locked. When this
data is returned, I would like to be able to have my database pull the data
from the worksheets.
Here are my problems:
1. I am a novice at this and am probably over my head, but I am trying.
2. I do not change the information location; i.e. cells, type of info,
when I am analyzing with excel. I do, however, answer yes when asked "There
is already a "dealer worksheet file". Do you want to create a new one?
When opened, the template should pull the information from the cells.
a. The information is not pulling over to the template, and I have
to relink the worksheet cell by cell to the template, or
b. If the information pulls, it does not insert the info in the
correct location on the template.
Once I get the template to contain the correct information, I protect all
but a few cells and email to end-user.
1. How do I take info that is emailed back - the original template with
information inserted - and has access pull that info into the access
database without manually key punching info?
I have tried to go to Data/Export/Excel, but my query has 4 parameters that
the end-user must complete; therefore, all info is not exported to excel.
This is why I am creating a report via query and then analyzing it with
excel.
Many many thanks for your help. Any suggestions and assistance will be
greatly appreciated!
JR