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

importing data using macro

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

Importing data using macro buttons

ResolvedVersion 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.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.