Dennis Matthews
asked on
Loop through query with variables from table
I have a locations and Sales table.
LocationID Location Name
1, Philadelphia
2, Boston
3, Miami
4, Denver
I need VBA that will use the following query Select * From Sales where S_LocationID=? and loop through all the locations and save a separate excel file with the sales from each location
LocationID Location Name
1, Philadelphia
2, Boston
3, Miami
4, Denver
I need VBA that will use the following query Select * From Sales where S_LocationID=? and loop through all the locations and save a separate excel file with the sales from each location
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER