Recent content by jay9324

Hi CJ, Can you tell how to export to excel and while exporting skip few rows in between.

Thanks CJ_London, 25 is a Excel sheet name and i = 16 is data print will start from 16th row of excel column.

Hi CJ_London, I = 16 is the row number from which data will start pasting in excel sheet. So Example my recordset returning 78 records then: A16: J59: first 25 records A70: J107: another 25 records so on. This is what I want. Please help..!!!!

Dear Friends, With below codes I am able to export recordset data to specified excel range if recordset count is 25. But I am unable to export the data greater than 25 to 2 specified range. Please Help me guys.. I am stuck in this from last 10 days. Regards, JK

Dear Friends, Please help for my mentioned question.

Dear All, Please help as previous answer does not answer my question. I want to print half of the recordset rows in 1st range and other half of recordset data to other range. Please Help..!!!!

Dear All, Please help me to get this done as i am stuck for week. Question is: 1. Run the Query and export the recordset to Excel with below requirement. Say for Example Query returned 20 rows of 7 column. 1. I want to paste 10 records in Excel Range A1: E10. 2. rest 10 records in A14:E23...

Hi Everyone, I am intermediate programmer in Ms Access. I love VBA programming as this very usefull in our day to day life. Regards, JK