I created this Excel Video Lesson in response to a viewer request. He wants to learn how to move files that contain dates, text and numbers from a different program into Excel. Excel 2007 gives you an easy to follow Wizard from the Data Tab of the Ribbon to Get External Data.
As I stress in this lesson – “Resist, resist, resist … the urge to go to the Office Button (File Menu) and choose Open. No, no , no… Use the Get External Data Wizard. Watch this short lesson to see how to bring information in from Word 2007 and from Access 2007. I also show you how to save an Excel 2007 file as a Text File (.txt) to make it easy to open it in almost any program.
If you enjoyed this lesson, I invite you to shop for my DVD, “The 50 Best Tips for Excel 2007.”The Store for The Company Rocks is a secure shopping site. And, I personally guarantee your satisfaction – or I will refund your purchase price! Click here to start shopping.
You can watch this Excel Training video on my YouTube Channel – DannyRocksExcels
Related Videos
- How to Use Excel’s Transpose and Text to Columns Tools to Reorganize Your Data
- Visit My Index of Excel Video Lessons
I saw your video and I practice importing a couple of files and everything was fine, but I have a question, how can I import using a macro multiple files at once, assuming that these are in a folder and move these to an Excel workbook is ie each file paste into a sheet of excel workbook.