export data from access database to excel

[Guest_imported]

i am coding in vb to get records from Access database and then to create an excel sheet using that data.

the user has a choice to select a particular reocrds.
when the program is started the firts time, it goes to the form where a user can select a particular record and then create a n excel sheet. it creates an excel sheet and saves it . the problem is if i choose another record and try to create a excel sheet i get an error message :
error 1004 method 'Range' of Object '_Global ' failed.

can some one help me with this problem.

 

[edge2000]

I assume you are using the automation objects to write the excel out, i have experienced similar problems to this it seems to be due to the fact windows cant recognise the fact that you closed the previous instance of excel, make sure you have issued the = nothing statement for the excel session.

Dave
dab@completebs.com

http://www.completebs.com

See website for more info but we can develop most things for most people.