analyze subform in excel

G

GeorgeAtkins

I want to use the "analyze data in Excel" feature, with data in a subform. As
of now, when I use the command interactively, it does not work. It will work
with the subform opened on its own, but not when it is embedded in a master
form, even if the cursor is in the subform.

Can anybody throw me a snippet or hint how I might code this? I would want
all of the data in the subform to be posted into Excel. I'm not sure where to
begin with this one. Thank you!
 
D

David Cleave

Hi George

So how do you do this? I know you can copy data from a datasheet and paste
it into Excel, but sometimes it mucks up date formats. Is there a better way?

Cheers

David
 
Top