Can Visual Basic update a Shared workook rather than autoupdate?
 

I intend to use a shared workbook to hold what is essentially a database of
stock requests.

I would then use various other workbooks to manipulate the data in this
shared file (Also to act as a GUI).
Before these workbooks make changes I want them to update the shared book so
they dont overwrite any new rows th other workbooks have added.

Is there a command in Visual Basic which will allow me to do this?

I am aware the are more appropriate programmes for this application, but
until I learn how to use them this will have to do.

Many Thanks,
Liam :o)

Can Visual Basic update a Shared workook rather than autoupdate?
 

VB and shared workbooks don't get along too well. You can try it but it
usually proves to be very problematic.
--
HTH...

Jim Thomlinson


"Liam" wrote:

I intend to use a shared workbook to hold what is essentially a database of
stock requests.

I would then use various other workbooks to manipulate the data in this
shared file (Also to act as a GUI).
Before these workbooks make changes I want them to update the shared book so
they dont overwrite any new rows th other workbooks have added.

Is there a command in Visual Basic which will allow me to do this?

I am aware the are more appropriate programmes for this application, but
until I learn how to use them this will have to do.

Many Thanks,
Liam :o)

Can Visual Basic update a Shared workook rather than autoupdat
 

What I want to do is not all the complicated so I think I should be alright.

Incidently I realise 'now' that when you save a shared workbook it updates
itself with any changes made by other users, so I'll just save it the line
before the macro makes any changes.

I'ma use this for now, but if anyone has better ideas? I am all ears! :oD


Thanks,
Liam

"Jim Thomlinson" wrote:

VB and shared workbooks don't get along too well. You can try it but it
usually proves to be very problematic.
--
HTH...

Jim Thomlinson


"Liam" wrote:

I intend to use a shared workbook to hold what is essentially a database of
stock requests.

I would then use various other workbooks to manipulate the data in this
shared file (Also to act as a GUI).
Before these workbooks make changes I want them to update the shared book so
they dont overwrite any new rows th other workbooks have added.

Is there a command in Visual Basic which will allow me to do this?

I am aware the are more appropriate programmes for this application, but
until I learn how to use them this will have to do.

Many Thanks,
Liam :o)