export current view of subform

[TheShabz]

Hi all,

So I have a subform that displays filtered data from a table. I'm trying to export the current view of the subform into excel. I assume transferspreadsheet will take care of it but I cant quite seem to get the syntax down to use the RecordSetClone as the source.



Help?

[boblarson]

Actually, paste the function found here (on my website) to a standard module. Then you can just call it by passing the form as shown in the instructions in the header of the code:

http://www.btabdevelopment.com/ts/de...aspx?PageId=47

[TheShabz]

Thanks. It works. Do you know of a non-control way of doing this? When the record count gets high, it will take a few seconds to go through all the iterations. Transferspreadsheet wont take a recordset, will it?

I was also considering making a temporary table with the recordset first, as then I know I can use transferspreadsheet.

Thoughts?

[boblarson]

Thanks. It works. Do you know of a non-control way of doing this? When the record count gets high, it will take a few seconds to go through all the iterations.

What iterations? This copies the entire recordset completely in one shot. The only iteration is just the headers which need to be put in. So it should not take much at all. I've used this with 250,000 records with it taking just a second or two.

[TheShabz]

Ahh yea, nvm. The For Loop there is only the headers. Nevermind.