Printing Access reports with Excel using VBA

[charvi]

can i generate more than 1 excel sheets when a command button is clicked
for eg
i search for 2 names of audit dept and click print command button where records will be printed in excel
again if i search for other 2 names and if i click print command button reports will not be printed.and gives error i have to close the program and load the program again

[Killer42]

can i generate more than 1 excel sheets when a command button is clicked

Yes .

[charvi]

can i generate more than 1 excel sheets when a command button is clicked
for eg
i search for 2 names of audit dept and click print command button where records will be printed in excel
again if i search for other 2 names and if i click print command button reports will not be printed.and gives error i have to close the program and load the program again

i can generate but i cannot put the import data from access only once i is possble and if i close an if i run again i can

i get error object variable with block variable not set

[Killer42]

i can generate but i cannot put the import data from access only once i is possble and if i close an if i run again i can

i get error object variable with block variable not set

I believe this is being covered in another discussion thread.