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 |
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 |
All times are GMT +1. The time now is 04:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com