Export to Excel as a shared file

[ran-d]

Hi All,
I'm running a program (Access 2007) that adds many sheets to an Excel file. The file name, which includes a network path and the xlxs extension are stored as a variable name. When all of the queries and processes are complete, I able able to save the file with the following command:
.Application.ActiveWorkbook.Save



Is there a way to save this as an Excel Shared filed? So far, my attempts have failed. The simpler the better, I'm newer to VBA.
Thanks

[June7]

What do you mean by 'Excel Shared file'? Excel files are locked for editing by the first user to open the file.

[ran-d]

What do you mean by 'Excel Shared file'? Excel files are locked for editing by the first user to open the file.

Within my Access VBA coding, I'm able to successfully export data to an Excel file. I am then trying to make the Excel file a Shared Workbook (file) for multi user use.

[June7]

You mean publish to Sharepoint? http://office.microsoft.com/en-us/ex...005262294.aspx

Sorry, no experience with Sharepoint or with Shared Workbooks.

[ran-d]

You mean publish to Sharepoint? http://office.microsoft.com/en-us/ex...005262294.aspx

Sorry, no experience with Sharepoint or with Shared Workbooks.

No, I believe Sharepoint is different. Thanks.

[June7]

Then need more info. I have never heard of Shared Workbooks and the Sharepoint reference was all I could find.

Where did you get this idea?

[ran-d]

Then need more info. I have never heard of Shared Workbooks and the Sharepoint reference was all I could find.

Where did you get this idea?

Open Excel, go to the Review tab and you'll see Share Workbook. In the subsequent window, checking the "Allow changes by more than one..." box makes this a Shared / Multi User file.

[June7]

Something new every day ...

I guess you want to programmatically change this property for a newly created workbook?

Bing: VBA excel share workbook

Try: http://www.mrexcel.com/forum/excel-q...-workbook.html