Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking two Excel Files
to set up an excel as a database How would I do that?
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Files in Excel | Excel Discussion (Misc queries) | |||
Linking Excel Files | Excel Worksheet Functions | |||
Linking files in excel | Excel Discussion (Misc queries) | |||
Linking Excel Files | Excel Discussion (Misc queries) | |||
Linking two excel files | Excel Discussion (Misc queries) |