Help with macro PLEASE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im trying to create a macro that will do what I do manually in excel.
I cant get how to do this!

Any help certainly appreciated

Heres what I do manually but I want a macro that would do this:
1) Data=> Import External Data --> Import Data
2) LookIn: Desktop
3) Filename: Test.txt

Within the new dialog window.....(Test Import Wizard)
4) Choose Delimeted
5) Start import at row: 19
6) Finish

Within the new dialog window....(Import Data)
7) Existing Worksheet= $E$14
 
Try this:

Tool -> Macro -> Record Macro

Do what you want

Tools ->Macro -> Stop Recording.

If you need help cleaning it up, bring it here and we can assist.

HTH,
Barb Reinhardt
 
Thank you so much Barb for that quick response, I will give that a try
shortly and get back to you. Thank you thank you
 
Hey Barb I got it to work. Wow it amazes me how many features Ive been
missing out on. I spent hrs. yesterday trying to figure this out. But I guess
this is the process of learning.

Thank you.
Deeply appreciate it
 
This is how I started with macros. You'll find out that what's recorded may
not necessarily be the most efficient way to do it, but it's a start.

Good luck!

Barb
 
Back
Top