Sarah has attended:
Excel VBA Intro Intermediate course
Access VBA course
Importing data using macro buttons
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?
RE: importing data using macro buttons
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.