View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M&M[_2_] M&M[_2_] is offline
external usenet poster
 
Posts: 33
Default Help with macro PLEASE

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