Multi forms export to excel

[Rakesh935]

Hi there, well i have two sub forms in a ms access file and i want to export it to one excel file with different sheets. Can anybody please help me with vba code to export.

 

[Alansidman]

This may be helpful

http://accessblog.net/2006/07/export-to-excel-range.html

 

[Rakesh935]

Thank u very much for the reply Alansidman.
After going through the link though i got some idea but still i am not clear enough with the vba code.
Requesting if u could further guide me with regards to access vba code.
Thanks...

 

[Rakesh935]

Hi Alan, Just got one more question to ask...Is it possible to export a access table and a access form located in the same access file to a excel file have two different sheets.
Thanks in advance...

 

[Alansidman]

I am confused. Why would you want to export a Form? It is primarily only a device to either view items in a table or input data to a table.