Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
View workbook
I have 5 remote users, all using workbooks running VB. I therefore cannot
set them as shared. Through the day I need access to there progress ( as recorded on the worksheets) in real time - A bit like big brother The work books are to be saved locally (to me) (networked) Any ideas would be most appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
View workbook
As a suggestion you could try linking to the workbook(s) using Formula.
Something like following may give you something to work with: Sub GetData() Dim ViewData As String 'data location & range to view ViewData = "='C:\[WhatBook.xls]Sheet1'!$B$2:F12" '<< change as required 'link to worksheet 'change sheet name & range as required Worksheets("MySheet").Range("B2:F12").Formula = ViewData End Sub Above should work even if target workbook is closed. Hope helpful -- jb "Auto save and sharing a document" wrote: I have 5 remote users, all using workbooks running VB. I therefore cannot set them as shared. Through the day I need access to there progress ( as recorded on the worksheets) in real time - A bit like big brother The work books are to be saved locally (to me) (networked) Any ideas would be most appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View of Workbook | Excel Discussion (Misc queries) | |||
Workbook View Errors | Excel Discussion (Misc queries) | |||
Change from userform view to excel workbook view | Excel Programming | |||
Can't view Workbook | Excel Discussion (Misc queries) | |||
Set View to 75% upon Workbook open | Excel Worksheet Functions |