Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have been asked to create a front end appliacation where people can enter data in text boxes and the data will update the excel sheet. The problem is that there are going to be 15 people using the application and they do not have Microsoft Access (or sql) to store the data in a back end database. As you know it isnt possible for more than one person to access an Excel sheet, update it and save it. So now I am kind of stuck. I have tried a '.csv' file and updated it successfully, but it doesnt support the colouring and resizing of cells. At present I am updating an '.xls' file and I am also able to do this successfully. But now I am trying to get VB to know whether the excel sheet is read/write or just read. If it is read then I will put in a method called sleep which will cause a small delay and then try again. I have only started programming recently and I am only 19. So I probably have no idea what im talking about, but I would appreciate any pointers and tips with the code and how to go about it. |