Linking two Excel Files
 

Is there a way to have one excel on your C drive and another on the server. If you update the one on your c drive and it will automatically update the one on the server with only the specific columns you want entered. Also if you do not have a exchange server.

Linking two Excel Files
 

You would have to write code to record changes, then open the server version
of the file in you local instance of excel and update it, then close and
save it. Now if the file was set up like a database, there are possibly
other approaches you could use such as using ADO or DAO. This assumes that
you have read and write access to the file from your computer.

--
Regards,
Tom Ogilvy

"Tslaby" wrote in message
...
Is there a way to have one excel on your C drive and another on the
server. If you update the one on your c drive and it will automatically
update the one on the server with only the specific columns you want
entered. Also if you do not have a exchange server.

Linking two Excel Files
 

to set up an excel as a database How would I do that?

Linking two Excel Files
 

Header1 Header2 Header3 Header4
dataA2 dataB2 dataC2 dataD2
dataA3 dataB3 dataC3 dataD3
dataA4 dataB4 dataC4 dataD4
dataA5 dataB5 dataC5 dataD5

--
Regards,
Tom Ogilvy

"tslaby" wrote in message
...
to set up an excel as a database How would I do that?