Run Code Within Query

[Ross Lewis]

I have some code that writes data into an specific excel spreadsheet.
Unfortunately this code workes with only one file at a time.

What I need to do is repeat this code for every line of a query.
I have a list of excel files that needs to be modified within a table.

How can I run the code that I already have and grab the file information
from the table?

 

[GVaught]

Why not just link the excel file into your Access database? This way you can
either updated the data directly from Access or directly from Excel. This
would eliminate the need for code to write to the external Excel
spreadsheet.