I have remote sales people who do quotes on a supplied Excel spreadsheet. There are two spreadsheet files, File1 contains a list of centrally managed customers, and File2 contains links to File1 and the quoting logic. The files are too big to email out as they change and I am trying to create some version control functions. I know what VB and macros are but I do not know how to use them. My sales people are less technical than I am.

I have created a batch file, that once the user VPN's in to a network server, that they can copy down both File1 and File2. I am trying to create additional functionality that would allow for a shortcut for the File2 spreadsheet on the desktop that would allow the sales rep to open without a lot of technical training and also time for a central administrator to manage.

I am not sure if this functionality would be in the spreadsheet files or done externally. Any guidance would be greatly appreciated!

Thanks,
Jim