Sharing and VBA don't mix. At least with Excel '02/'03, sharing causes VBA to simply malfunction in ways that cannot or should not be coded around. Rather, I recommend you share your data in a separate shared workbook and keep your VBA in an unshared UI. This approach allows you to take advantage of Excel's built-in features for reconciling changes by mutliple users, without comprimising your VBA or otherwise affecting your UI. Multiple users can either have separate copies of the UI or use |
Option Base 1
Public FileNames$()
Public Function OpenNMostRecentFiles(n As Byte, PartialFileName$, inPath$, Optional PartialNameIsFromEnd As Boolean)
'uses files' creation date to open the N most recent files located in inPath with names starting or ending with PartialFileName
'returns file names to public array "FileNames"
'requires TestLen, WindowIsOpen, TestApp, and SetApp functions (could also SubStart function instead of TestApp and SetApp)
'assumes "option base 1"; uses FileNames public string |
If you have ever wanted to display two or more tables next to one another on a single sheet, you've probably realized that Excel is not designed for that. If you arrange them vertically, there is no way to vary the column widths between tables; and if you arrange them horizontally, there is no way to vary the row heights between tables. This leaves two options: arranging them diagonally (which is not at all desirable in most cases), or giving up and putting them on separate sheets. (You could |
|