save excel document form vb

[Guest_imported]

i am new to vb and writing a application where ,i get records from access database and then store them in an excel sheet. someimes i get an 1004 error and sometimes the code works but i cannot view the ecxcel sheet after i run the program. can someone help me with this problem

 

[JerryDennison]

Are you using the DoCmd.TransferSpreadsheet method? If so, you can only use an existing table or query. You cannot use SQL directly to return an exportable recordset. You can however use QueryDef to create a new query with only those records you wish to export and then use this query as the recordsource for the export. If this is to be done on a regular basis you'll want to immediately delete the query or you won't be able to create it again using CreateQueryDef.

 

[Guest_imported]

no i am using MS-Access database and i am getting error
"method 'range' of object '_global' failed".

 

[JerryDennison]

Are you writing your code in Access or are you using a version of Visual Basic? This is an Access forum, so I assumed you wanted VBA coding help.

 

[Guest_imported]

i am using visual basic. so where can i get help