We have a large number of xlsx. design tables to insert into a veriety of assemblies. I have searched the web for a macro that might help with this but have not found anything that I can work with.
What I am trying to accomplish is below.
Insert -> tables -> Design table
In design table utility
Source -> From File
Browse -> Define folder location and select file name that = Assembly Name
Accept and close utility.
I have set up keyboard shortcuts as best I can to speed the process but automation is the goal. Any help or code samples would be appreciated.
Thanks in advance