Sharepoint "Export to Spreadsheet" Question

I have just begun programming开发者_开发技巧 in VBA and despite my researching efforts have a quick question for the community...

Is it possible to perform the sharepoint action "Export to Spreadsheet" using a VBA macro?

I want to export to excel and create a few pivot tables if you are wondering where I am going with this.

A push in the right direction would be extremely helpful... I wish I had some code to post but I am still in the planning/researching stage.

---

I would first like to thank @Tim Williams for directing me towards the support.microsoft.com/kb/930006 link as I believe I have found a solution to my question. (If I had enough reputation your comments would be upvoted!)

I was able to generate an .iqy file from the "Export to Spreadsheet" command which I have successfully transferred into a VBA web query. Alternatively, I was able to simply save the .iqy file and open it with the VBA code. Both have successfully populated my spreadsheet so I can now do the reporting I was looking to do.