open userform when excel opens
 

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

open userform when excel opens
 

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

open userform when excel opens
 

hi,
post your code.

Regards
FSt1

"Erik" wrote:

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

open userform when excel opens
 

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.

"Spreadsheet Solutions" wrote:

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

open userform when excel opens
 

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

"FSt1" wrote:

hi,
post your code.

Regards
FSt1

"Erik" wrote:

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