macro to prompt to upload spreadsheet

[tlindeman]

I found code (through this site) to upload a spreadsheet into a table. However, is there a way to create a macro to prompt me for the name of the spreadsheet? The name of my spreadsheet changes weekly. BTW I am using Office 2010

Thank You
Tony

 

[G37Sam]

Share the code you got and we'll modify it for you