I am still learning VBA, and I am having a difficult time trying to figure out the best way to accomplish this.
Years ago a workbook called Locator Forms was created in Excel to populate about 12 federal forms. I want to be able to use a Query to pull the neccesary info from an Access Table.
I have already created a macro that will export a query containing the correct info to a worksheet called Export Files. Now I want to be able to open Locator Forms updated with the info exported to Export Files, using either a command button or VBA.
I hope this post is clear enough.
Years ago a workbook called Locator Forms was created in Excel to populate about 12 federal forms. I want to be able to use a Query to pull the neccesary info from an Access Table.
I have already created a macro that will export a query containing the correct info to a worksheet called Export Files. Now I want to be able to open Locator Forms updated with the info exported to Export Files, using either a command button or VBA.
I hope this post is clear enough.
