K
kidcosmo
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.
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.