K
kidcosmo
I didn't get a response on my last post, so I'm hoping someone will
have an idea on this request. Below is my original post:
Hi, All! I'm looking for some help in moving data from my Access
form
to specific cells in an Excel template. I'd like to create a command
button on my Access form that will open the .xlt file and transfer
some of the values on my form and plug them into the .xlt. For
example, I have the cost of equipment calculated on my form control
(3
printers @ $300 each = $900), the command button will capture that
value and plug it into the capital expenditure cell on the .xlt
file.
Any help would be greatly appreciated.
have an idea on this request. Below is my original post:
Hi, All! I'm looking for some help in moving data from my Access
form
to specific cells in an Excel template. I'd like to create a command
button on my Access form that will open the .xlt file and transfer
some of the values on my form and plug them into the .xlt. For
example, I have the cost of equipment calculated on my form control
(3
printers @ $300 each = $900), the command button will capture that
value and plug it into the capital expenditure cell on the .xlt
file.
Any help would be greatly appreciated.