analyze subform in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top