Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 'database'
Hi Guys,
Just posing a small and potentially simple question (well not to me!) I have made a tiny excel 'program' that looks at the contents of its sheet and then returns the answer from it, and through it you can add new entries to the sheet (sheet1). Now if I wanted to share this with others, how could I have one central file that we all can open and add to and see each others additions? At the moment what is on my sheet will not be on someone elses sheet obviously but I would really like us to all see the same info that each other has put in. Im sure there is a simple way to do this but I cant fathom it, its kinda like wanting excel to be access! Any ideas or tips would be greatly appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 'database'
Hi
The obvious answer is to simply all use one file on a shared drive????? Or am I missing something? regards Paul Duncan wrote: Hi Guys, Just posing a small and potentially simple question (well not to me!) I have made a tiny excel 'program' that looks at the contents of its sheet and then returns the answer from it, and through it you can add new entries to the sheet (sheet1). Now if I wanted to share this with others, how could I have one central file that we all can open and add to and see each others additions? At the moment what is on my sheet will not be on someone elses sheet obviously but I would really like us to all see the same info that each other has put in. Im sure there is a simple way to do this but I cant fathom it, its kinda like wanting excel to be access! Any ideas or tips would be greatly appreciated |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 'database'
Hi Paul,
Yep, you are right in what you are saying, but I want to all be able to use the file and how can we do that? After further thought I am thinking my code should look to this one file for its data instead of looking within itself, but am unsure of how to code that, any ideas? Many thanks Duncan wrote: Hi The obvious answer is to simply all use one file on a shared drive????? Or am I missing something? regards Paul Duncan wrote: Hi Guys, Just posing a small and potentially simple question (well not to me!) I have made a tiny excel 'program' that looks at the contents of its sheet and then returns the answer from it, and through it you can add new entries to the sheet (sheet1). Now if I wanted to share this with others, how could I have one central file that we all can open and add to and see each others additions? At the moment what is on my sheet will not be on someone elses sheet obviously but I would really like us to all see the same info that each other has put in. Im sure there is a simple way to do this but I cant fathom it, its kinda like wanting excel to be access! Any ideas or tips would be greatly appreciated |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 'database'
Hi All,
Have solved the problem, at the top of each sub that looked to the data I put Set sourceWB = Workbooks.Open("G:\DATA.xls") With sourceWB.Sheets("DATA").Range("A1:B100") --- my normal code here --- Then at end of sub I put sourceWB.Save sourceWB.Close This worked a treat. Duncan Duncan wrote: Hi Paul, Yep, you are right in what you are saying, but I want to all be able to use the file and how can we do that? After further thought I am thinking my code should look to this one file for its data instead of looking within itself, but am unsure of how to code that, any ideas? Many thanks Duncan wrote: Hi The obvious answer is to simply all use one file on a shared drive????? Or am I missing something? regards Paul Duncan wrote: Hi Guys, Just posing a small and potentially simple question (well not to me!) I have made a tiny excel 'program' that looks at the contents of its sheet and then returns the answer from it, and through it you can add new entries to the sheet (sheet1). Now if I wanted to share this with others, how could I have one central file that we all can open and add to and see each others additions? At the moment what is on my sheet will not be on someone elses sheet obviously but I would really like us to all see the same info that each other has put in. Im sure there is a simple way to do this but I cant fathom it, its kinda like wanting excel to be access! Any ideas or tips would be greatly appreciated |
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) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row | Excel Programming |