how can i have our excel template pull information such as the revision, filename, and any other drawing information and place into a certain cell in excel by pressing one button?
In many way you can do this.
One way is
1)Write a macro in excel vba.
2)Create solidworks object in excel vba to access solidworks from excel
3)Then get properties you required
4)Write those properties in current excel work sheet
5)Finally assign the macro to a button
Retrieving data ...