View Full Version : Solved: Copy .txt file
Meatball
06-17-2010, 10:36 AM
I want to be able to choose a .txt file from several in a folder and copy /paste the entire contents into an Ecxel sreadsheet. How hard is this to do? I tried getting some different codes to combine and do this but with no luck.
Hi Meatball,
Try recording: Data|Get External Data|Import Text File
Excepting picking which file to import, this should give you a start. Then look at Application.GetOpenFilename for picking.
Hope that helps,
Mark
Meatball
06-17-2010, 02:08 PM
:motz2: :motz2: :motz2:, I wish I knew one quarter of what most of you know. That worked great and I think I can rework in some parts of other macros to choose the file. Thank you very much Mark
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.