I was wondering if it was possible to create a macro to a button using the file \\Cluster2\Dept Data\Migration Data\NOMSALES.csv as a source and from that create a csv file that displayed sample data from the file \\Cluster2\Dept Data\Migration Data\NOMSALES Output.csv. In other words instead of the user going through a directory to open a file I would like the user to click on a button within a workbook and the data within the later file will automatically populate on the spreadsheet. Can this be done? If so what code can be written in a macro for this to be done?
Also i would like to be an expert at vba access, excel and macros. Do you know of any really good books, websites and online courses where I can learn about producing complex macros to ideally produce high level functions?
Thanks for your contributions