I am trying to set up a button on an access 2000 form which when clicked will open a specific excel 2000 file, and transfer the name and address of the current company being viewed in the access form.
I have already done something similar with Word 2000, but cannot find a similar method with excel.
I have tried using the query wizard in Excel, but it does not work, it does not let me complete the query says their are not enough variables.
If I have the access query use a static criteria I can get the excel documnet to open and put the name and address in it, but it puts it in as columns and I need to to put it in as rows.
I also need it to transfer the information when the file opens, and not have to have the operator activate anything.
In short the operator need only:
Open form on Access
Find record of Company desired
Press button on Form
Then automatically it should
Open excel file
inport/add company details to specific rows (ie address label look)
Note I do not know VBA, or excel macros for that matter.
Any help would be appreciated
I have already done something similar with Word 2000, but cannot find a similar method with excel.
I have tried using the query wizard in Excel, but it does not work, it does not let me complete the query says their are not enough variables.
If I have the access query use a static criteria I can get the excel documnet to open and put the name and address in it, but it puts it in as columns and I need to to put it in as rows.
I also need it to transfer the information when the file opens, and not have to have the operator activate anything.
In short the operator need only:
Open form on Access
Find record of Company desired
Press button on Form
Then automatically it should
Open excel file
inport/add company details to specific rows (ie address label look)
Note I do not know VBA, or excel macros for that matter.
Any help would be appreciated