open userform when excel opens

[Erik]

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

 

[Spreadsheet Solutions]

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.

 

[FSt1]

hi,
post your code.

Regards
FSt1

 

[Erik]

I did google this, and tried the workbook_open as you suggest. The problem
is that the form opens up at the same time the save as routine. So, I cannot
add the data I want and then save as. I need to be able to open the form
first, then once the user inputs data, then save as.

 

[Erik]

Unfortunately, I cannot post my code here. It is written on another network
that happens to be classified.