Please help Query and Excel arggggg

[ribhead]

I am in a huge pickle here and need some help. A couple of days ago I found out that my shared workbooks (XL 2000) weren't saving all the data entries. So, I have multiple users that need to use this program I wrote in XL but I also need to store the data and analyze it. What I was hoping to do was to have the main XL file as a read only and send the information in to an Access Database. When XL would open I would run the Query from Access to XL but first I haven't been successfull in accomplishing any of my goals and I can only suspect my Read Only system is largely flawed. Any help would be greatly appreciated. By the way I know an easy answer would be to just run all this in access but my company won't support Access as a "main tool of use".

Rib

I know a little about nothing and even less about everything.

 

[Nowell]

Hi,

why wont your company support the use of access, it would solvew their problems. Just seems a bit silly to me.

 

[ribhead]

Well, it's not that they won't let us use it the problem is that if I write a whole program using Access and leave the company then the next person they hire HAS to know Access. So, the direction I was given is that the main program needs to be written in Excel what I do with the info when it's stored is up to me. Probably didn't answer your question.

rib

I know a little about nothing and even less about everything.