98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Importing data using macro buttons
Importing data using macro buttons
Resolved · Low Priority · Version Standard
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.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |