Hey Guys.
Im only a greenhorn at VBA so be kind. Also thanks in advance for any help provided.
Ok. This is probally going to sound stupid or really easy but how would I go about having on open a excel template and upon opening prompt the user to choose the location for the spreadsheet where i will be copying data out of there into the template then saving the template. I figured out the copy functions but open the sheet?
For VBA code im going to call the spreadsheet name for the Template as "Template" and and the spreadsheet to open is going to be called FillDATA and these will be located on the desktop for Template and in C:\FillDATA.xls for FillDATA Spreadsheet
Thanks All
Kaos