Author: LimLim
Date: Sep 6, 2008 00:42
Good day,
I have created a form named "Form1" which consists of a subform named
"Subform1".
The subform is displayed in a "Table" format aka Datasheet. Both forms are
linked by a variable "Jig No".
Now I want to export my subform data (acquired from a Query) row by row to a
specified existing excel file, specified existing worksheet and specified
range.
I checked out some threads and found out the Range parameter will not be
applied for DoCmd.TransferSpreadsheet acExport command.
I would like to know if there's other way that I can export my subform data
row by row to my specified worksheet and range.
Before this, I have tried something like:-
Dim myfield as Variant
myfield = Forms![Form1]![Subform1].Form![Variable1]
mysheet.cells(2,3) = myfield
But, what about the 2nd row and etc?
Or maybe can I load the subform data (where I acquired from a query result)
into an array then assign to specified data sheet range?
|