I have tried the various posted solutions for exporting values from Access to a specific cell in an existing excel file. I can't make any of them work or even comprehend some. Can someone give me anexample of the code, actuated from a click on button named CommEx on Form1, that will transfer a single value to a cell in an existing excel file? To keep it simple, let's say that I want to export the number 12 to a cell named 'Length" (or cell B5 if need be) in an excel file named Dimensions.xls. (stored in current project path)
I am using A2007 with W7 but also have access to A2003 with W7. Thanks in advance, any help much appreciated.