Erik;

The story is a little complicated to me but referring to your subject,
are you familiar with the Workbook_Open event

To me it seems that a little google on that subject will help you.

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands (Those who live some 18 feet below sea level)
--
E:
W: www.spreadsheetsolutions.nl
--


"Erik" wrote in message
...
Hi All,
I have a spreadsheet that will import data, add a few lines of text and
then
save as a new file name. Everything works, however the order is wrong.
Need
to know how to make it work in the correct order.

I want to have the user open the file and then things happen in this
order:

Import data
Open userform for extra data entry
run the various subs to add the extra txt
save as

I have all the subs written to accomplish the above tasks, and the
userform
works great, but need to have things work in the above order. Any help is
greatly appreciated. Thanks

Erik