Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workbook Refreshes For Multiple Users
I'm using this to create new workbooks. The workbook gets re-saved every every few seconds. Is it possible to allow another user to have this workbook open and see the changes as they are happening ? I tried the "External Data" but could not get it to work. Sheets(Array("strings")).Select Sheets("strings").Activate ChDir "J:\PROJECTS\Carl\New Folder" Dim sh As Worksheet Dim Nwb As Workbook Application.ScreenUpdating = False For Each sh In ActiveWindow.SelectedSheets sh.Copy Set Nwb = ActiveWorkbook Nwb.SaveAs Filename:=sh.Name Nwb.Close False Next Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
A Excel workbook, on a shared drive, gets different results from different users | Excel Discussion (Misc queries) | |||
Mulit Users in a shared protected workbook | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
How can I allow other users to make changes in a shared workbook | Excel Discussion (Misc queries) |