In the office this past week I created a tool that was posted on the
corporate Intranet and users downloaded it to view certain reports and make
forecasts to other reports. The file was 6.8MB and Tools Share Workbook
Allow changes€¦ was checked. Over the course of the first day that the tool
was posted to the Intranet, we noticed some strange behavior. Some people
who open the file received a message saying that the file was €˜Read Only but
this setting was never enabled. Also, some people were unable to save the
changes that they made to their forecasts (even when the file was not opened
as €˜Read Only€¦which was never enabled anyway). Some people had no problems,
whatsoever, accessing and utilizing the file. All in all, probably 30+
people accessed the file throughout the day. Due to this strange, and
seemingly random behavior, I can only imagine that we exceeded some kind of
memory limitation. Has anyone encountered this type of behavior before? If
so, what did you do to overcome these issues?

I am thinking that there must be a better way to allow users to log into a
single file, view the contents, and make a few changes. Can this be done
with UserForms? Can I set up some UserForms, open them, allow users to input
information into the form, and then send this data to a specific range on a
specific sheet? I have some extensively experience programming Excel
UserForms, but I have never tried to use a UserForm to log into a €˜remote
excel file.

I have some experience using specific references in UserForms such as this
€¦
Private Sub ComboBox2_Change()
UserForm1.ComboBox2.RowSource =
ThisWorkbook.Worksheets("Welcome").Range("A12:A20" ).Address(External:=True)
End Sub

Private Sub ComboBox3_Change()
UserForm1.ComboBox3.RowSource =
ThisWorkbook.Worksheets("Welcome").Range("B12:B20" ).Address(External:=True)
End Sub
€¦

Anyway, Im not even sure that this type of project is feasible or
practical. Does anyone have any experience doing such a thing? What may be
a viable alternative? Some people have MS Access, but most people do not,
and will not have it installed, so I am trying to do this project in Excel.


Id appreciate any and all input.

Regards,
Ryan---





--
RyGuy