Workbook Refreshes For Multiple Users

C

carl

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro for saving worksheets as workbooks 0
Modifying a Macro - Auto Save WorkSheets as Workbooks 1
Macro: Save Sheets as Workbooks Part 2 0
XLS to CSV Code Problem 0
Copy and paste 2 excel sheets in message body of email 5
problems getting this macro to work 8
Open four Wbooks, copy four columns from each to Master Wbook 16
Split workbook into multiple workbooks 2

Top