Results 1 to 4 of 4

Thread: ?Excel: How to SaveAs workbook as SHARED?

Threaded View

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Resolved ?Excel: How to SaveAs workbook as SHARED?

    Esteemed Forum Participants and Lurkers:

    I have a requirement to save a set of macro generated Excel single-sheet workbooks as SHARED workbooks. I don't have any problem at all saving the required files ... I just don't know how to set the SHARED property.

    Here is what I have so far:
    ActiveWorkbook.SaveAs _
    fileName:=myPath & myName, _
    FileFormat:=xlNormal, _
    Password:="", _
    WriteResPassword:="", _
    ReadOnlyRecommended:=False, _
    CreateBackup:=False

    I tried to record a macro to save a SHARED file, but this is not allowed. The macro gets closed and does not reveal any information about saving as Shared. I of course rummaged throug my reference books and did a search on this forum, all to no avail.

    Thank you for any and all comments, suggestions, and
    assistance.
    Last edited by Webtest; Oct 11th, 2004 at 10:34 AM.
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width