Recent content by abrody

Thanks Gasman!

Thanks arnelgp! Works great! And thank you all for your suggestions. While waiting for your reply, I did one more search. Somehow I made the search gods happy and found the code below. It works, but when I try to open the Excel file I get a "Excel cannot open the file because the file format or...

Thank you all for the help. Arnelgp-Could you please tell me how to modify your example to export each Product Category into it's own separate Excel file instead of separate tabs in one file? Thank you.

I need help with VBA. I have a table called tblProducts that I need to export to several Excel files. I need to loop through the table and export the records for each ProductCategory into it's own Excel file. Each file should be named with it's ProductCategory. For example (using the table...

Your suggestions are on target. Thank you both.

Hello everyone, I am not very good with loops. I have a select query called sel_tblTrimsheet-Trimsheet. In that query is a field called PT Num. The PT Num can repeat on two or more records in the query. I want to loop through those records and print a report called zTrimsheet for each PT Num...

Hello. My name is Alex. Thank you for letting me join this forum. I'm a beginner Access user. I often come to this site to read threads and learn as much as I can. I look forward to working with all of you. Thanks again.