Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, Macros, Database
Hello.
I would like to know if its possible to create different Excel sheets, each one specifically for a unique user with Macros, and have these Excel sheets linked to one common Excel sheet on a server in order to check all the data coming from different users (kind of a database). The purpose of my question is that Im using the Macros with Excel sheets and we cant have multiple users having access to the common Excel sheet simultaneously Read only mode. Thanks for you help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, Macros, Database
A linking formula in a master sheet isn't concerned with how the sheet
linked to gets a value in its cell. -- Regards, Tom Ogilvy "Sun" wrote in message ... Hello. I would like to know if it's possible to create different Excel sheets, each one specifically for a unique user with Macros, and have these Excel sheets linked to one common Excel sheet on a server in order to check all the data coming from different users (kind of a database). The purpose of my question is that I'm using the Macros with Excel sheets and we can't have multiple users having access to the common Excel sheet simultaneously "Read only" mode. Thanks for you help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
Macros VBA and Converting Form to Database | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Macros to tranfer data to database | Excel Discussion (Misc queries) |