Solved

Share Workbook with Macro?

Posted on 2009-04-07
3
493 Views
Last Modified: 2013-11-25
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.
0
Comment
Question by:quaziblue
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 125 total points
ID: 24093150
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
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 175 total points
ID: 24094561
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
 
LVL 1

Author Closing Comment

by:quaziblue
ID: 31567825
Thanks for the responses.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question