Please Help! Shared Workbooks & VBA

[swedbera]

I set up a procedure to export data from an Access database to an Excel
template with several tabs. Everything works ok until I try to save the
Excel workbook as a shared document. Is it even possible to save an Excel
workbook as a shared document using vba code from Access ? If so, how do I
do this and how would I unshare the workbook before I attempt to import the
updated spreadsheets back into the database?

I have been looking at both the Excel and Access Discussion groups and
cannot find what I am looking for - only a post that references
ActiveWorkbook.ExclusiveAccess
and ? thisworkbook.MultiUserEditing. There is no other explanation and I
don't know how to implement this.

I would greatly appreciate any help on this.

Arlene

[Tom Ogilvy]

From the Help on MultiUserEditing

To save a workbook as a shared list, use the SaveAs method. To switch the
workbook from shared mode to exclusive mode, use the ExclusiveAccess method.

------------------
so there is an option in SaveAs to make the workbook shared.

--
Regards,
Tom Ogilvy

"swedbera" <swedbera@discussions.microsoft.com> wrote in message
news:69BBDC3D-BCD6-42FF-BCC2-F0646A02A527@microsoft.com...
> I set up a procedure to export data from an Access database to an Excel
> template with several tabs. Everything works ok until I try to save the
> Excel workbook as a shared document. Is it even possible to save an Excel
> workbook as a shared document using vba code from Access ? If so, how do
I
> do this and how would I unshare the workbook before I attempt to import
the
> updated spreadsheets back into the database?
>
> I have been looking at both the Excel and Access Discussion groups and
> cannot find what I am looking for - only a post that references
> ActiveWorkbook.ExclusiveAccess
> and ? thisworkbook.MultiUserEditing. There is no other explanation and I
> don't know how to implement this.
>
> I would greatly appreciate any help on this.
>
> Arlene
>
>

[swedbera]

Tom,

Where are you finding this help? I couldn't find it in Excel Help.

If I can find it, I will try to figure it out myself.

Arlene

"Tom Ogilvy" wrote:

> From the Help on MultiUserEditing
>
> To save a workbook as a shared list, use the SaveAs method. To switch the
> workbook from shared mode to exclusive mode, use the ExclusiveAccess method.
>
> ------------------
> so there is an option in SaveAs to make the workbook shared.
>
> --
> Regards,
> Tom Ogilvy
>
> "swedbera" <swedbera@discussions.microsoft.com> wrote in message
> news:69BBDC3D-BCD6-42FF-BCC2-F0646A02A527@microsoft.com...
> > I set up a procedure to export data from an Access database to an Excel
> > template with several tabs. Everything works ok until I try to save the
> > Excel workbook as a shared document. Is it even possible to save an Excel
> > workbook as a shared document using vba code from Access ? If so, how do
> I
> > do this and how would I unshare the workbook before I attempt to import
> the
> > updated spreadsheets back into the database?
> >
> > I have been looking at both the Excel and Access Discussion groups and
> > cannot find what I am looking for - only a post that references
> > ActiveWorkbook.ExclusiveAccess
> > and ? thisworkbook.MultiUserEditing. There is no other explanation and I
> > don't know how to implement this.
> >
> > I would greatly appreciate any help on this.
> >
> > Arlene
> >
> >
>
>
>

[Tom Ogilvy]

VBA help in Excel. In a module type in

MultiUserEditing

Highlight it and hit F1. should get you the help file on that property

--
Regards,
Tom Ogilvy

"swedbera" <swedbera@discussions.microsoft.com> wrote in message
news:2D343900-F62C-4919-B5A5-C043013FA9C0@microsoft.com...
> Tom,
>
> Where are you finding this help? I couldn't find it in Excel Help.
>
> If I can find it, I will try to figure it out myself.
>
> Arlene
>
> "Tom Ogilvy" wrote:
>
> > From the Help on MultiUserEditing
> >
> > To save a workbook as a shared list, use the SaveAs method. To switch
the
> > workbook from shared mode to exclusive mode, use the ExclusiveAccess
method.
> >
> > ------------------
> > so there is an option in SaveAs to make the workbook shared.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "swedbera" <swedbera@discussions.microsoft.com> wrote in message
> > news:69BBDC3D-BCD6-42FF-BCC2-F0646A02A527@microsoft.com...
> > > I set up a procedure to export data from an Access database to an
Excel
> > > template with several tabs. Everything works ok until I try to save
the
> > > Excel workbook as a shared document. Is it even possible to save an
Excel
> > > workbook as a shared document using vba code from Access ? If so, how
do
> > I
> > > do this and how would I unshare the workbook before I attempt to
import
> > the
> > > updated spreadsheets back into the database?
> > >
> > > I have been looking at both the Excel and Access Discussion groups and
> > > cannot find what I am looking for - only a post that references
> > > ActiveWorkbook.ExclusiveAccess
> > > and ? thisworkbook.MultiUserEditing. There is no other explanation
and I
> > > don't know how to implement this.
> > >
> > > I would greatly appreciate any help on this.
> > >
> > > Arlene
> > >
> > >
> >
> >
> >