What is the best way to import data from a comma separated file on the computer hard drive into an Excel spreadsheet, using a macro button embedded within the spreadsheet?

have you tried to record the coding when opening the comma separated file? once you see the coding, you can change the file name to a variable which can be stored somewhere within your spreadsheet? and then once you have stored the coding within a procedure, you can assign this to a "button" object?

just a thought, that is what i do in my macros when i want to open a comma separated file.