importing data using macro

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Importing data using macro buttons

Importing data using macro buttons

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.08 secs.