Updating a seperate workbook - Excel '97 VBA
 

Hi there,

First i admit i am very new to VBA, so please bear with me :)

I currently have a workbook setup where by people use a Input form to enter
details. The data in the form is the added to a hidden worksheet. Now the
workbook is getting exceedingly large and takes it time to open, close and to
save.

What i would like to do is have the Input form in one workbook and the data
to be sent to a serperate Data wookbook (and worksheet). Can this be done?

Or would i be able to setup a system via VBA that moves the data from the
Input workbook to a Data workbook and then clears the data it moves from the
Input workbook? (am i getting too complex here?)

Thanks,

Updating a seperate workbook - Excel '97 VBA
 

You can absolutely reassign to a new workbook. Just use a DIM at the
beginning of your code to assign a variable to the Input Box. Then, when you
do your Open other workboox command, just paste the info over. Course, the
details all depend on what you're moving and such.

"Phendrena" wrote:

Hi there,

First i admit i am very new to VBA, so please bear with me :)

I currently have a workbook setup where by people use a Input form to enter
details. The data in the form is the added to a hidden worksheet. Now the
workbook is getting exceedingly large and takes it time to open, close and to
save.

What i would like to do is have the Input form in one workbook and the data
to be sent to a serperate Data wookbook (and worksheet). Can this be done?

Or would i be able to setup a system via VBA that moves the data from the
Input workbook to a Data workbook and then clears the data it moves from the
Input workbook? (am i getting too complex here?)

Thanks,