Export a value to specific Excel cell

[gg80]

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.

[pbaldy]

Did you see this one?

http://support.microsoft.com/kb/219151

There's a lot more there than you need, but it appears to be commented well enough that you can ignore what you don't need.

[dsmacs]

Sample in 2003, should work in 2007.

Cheers
Darren

[gg80]

Thanks for quick reply and easy to use example, but works ok only for C:\ dimensions.xls. In A2003, if I use the pulldown for another location I get an error message that the file can't be found. In A2007, it just locks up. If I use file location as CurrentProject.path\dimensions.xls, I get same error message. Is this some W7 phenomena?

[gg80]

Hi dsmacs-Problem fixes itself, not sure why-my new 64 bit Sony and A2007 have given me several fits. But, working great and does just what I need. Still can't get it to accept CurrentProject.path, but will work on it and not a big deal in this case. Thanks so much. You really simplified it down to my level, much appreciated.

[gg80]

Hi PBaldy and thanks. I got another reply that was more at my level. I tried to extract my needs from the code on the suggested site and had problems ksimplifying it to exporting to an existing excel file.