Need VBA of Task Excel has built in

[rbpd5015]

I know this sounds crazy, but I am building a user form and want to use a button as a single action to preform a excel built in function.

What I want to do is this.

1) Press a button called (Import)
2) I want it to open a window for me to select a text file to import (Just as Excel has From Text in Data)
3) After selecting a file I want to not use the text import wizard but I want to the following selected
a) delimited
b) start import from row 24
c) My table has headers (NO)
d) Step 2 of the wizard uncheck tab so all are blank
e) Step 3 of wizard leave general as the column data format
f) At end I want to import in A1 of Sheet RomData
4) After success, I want a popup notification to the user that the data was imported.

Oh one thing I want it to overwrite existing data not add to it.

Thanks!!

So I know I can use the wizard, but since I am going to have user form I just want the user to locate the file he wants to import and thats it.


Thanks

Matt

[rbpd5015]

Wow I think I might have solved it I found the following MACRO...

Problem is that it saves to a new workbook and names the sheet after the file name?

here

Please Login or Register  to view this content.

How do I change this to save it to the current workbook and sheet RomData?

thanks

Please Login or Register  to view this content.

[rbpd5015]

Solved.... Sorry I was impatient

Please Login or Register  to view this content.

.