Share Workbook with Macro?

Hi Experts-

I have several workbooks that I run simple formatting macros on.  In one of the final macros, I'd like to add code that converts the file to a shared workbook.  Is this possible?  Any help would be appreciated.  Thanks.

Q

P.S. I've tried searching for my answer in the knowledgebase, but wasn't able to find something general enough to be my solution.
LVL 1
quaziblueAsked:
Who is Participating?
 
Rory ArchibaldCommented:
I totally agree with Patrick as regards the reliability of Shared Workbooks but I know that there are situations where you have no choice so, for the record, you could use code like that below. Avoid it if possible though!
Rory

Sub ShareWorkbook()
   Application.DisplayAlerts = False
   ActiveWorkbook.SaveAs ActiveWorkbook.FullName, accessmode:=xlShared
   Application.DisplayAlerts = True
 
End Sub

Open in new window

0
 
Patrick MatthewsCommented:
Hello quaziblue,

The consensus opinion of Experts here is that using 'share workbook' should be assiduously
avoided.  This is a poorly implemented feature in Excel that leaves workbooks highly
vulnerable to corruption.  If true multi-user capability truly is needed, then the best practice
is to use a database platform such as Access, SQL Server, MySQL, etc.

Regards,

Patrick
0
 
quaziblueAuthor Commented:
Thanks for the responses.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.