ExportingFromMultipleFormsToSingleExcelFile

[hetalmeghal]

I have a master-detail form on my screen. I want to transfer all the data (on master as well as detail form) to a sinlge file. I tried to use the outputTo Macro Actio, but it considers one form at a time. So i m not able to send all the data into a single file.

I am already on a deadline, so, if anybody can guide me, i will be grateful.

Hetal

 

[SeeJane]

Could you use a SQL to pull all the desired data together into a single source, then export that?. You could either do the work as a stand alone query or use VB to program a new Query Def then export it using the transfer spreadsheet method.

Good luck,
CJ

 

[hetalmeghal]

Thanks. I was in that direction, but could not make it out. Now I will try. thanks again.