Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help! Shared Workbooks & VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help! Shared Workbooks & VBA
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help! Shared Workbooks & VBA
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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help! Shared Workbooks & VBA
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" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared Workbooks-shared headers and footers | New Users to Excel | |||
Shared workbooks | Excel Discussion (Misc queries) | |||
suddenly my excel workbooks are "shared workbooks" | Excel Discussion (Misc queries) | |||
Shared Workbooks | Excel Programming | |||
Shared Workbooks | Excel Worksheet Functions |