Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sharing violation while saving file after adding this macro
Running XP Pro, Office 2003 all with latest updates installed.
Attempting to write macro to export a module from current workbook, then import to another workbook that is also open. Got the following code from CPearson's site: Dim FName as string With Workbooks("Book2") fName = .Path & "\code.txt" .VBProject.VBComponents("Module1").Export.FName End With Workbooks("Book1").VBProject.VBComponents.Import FName code executes just fine, exporting, then importing 'module1' Attempts to save either workbook generates a 'Sharing violation' message. I've tried 'Save As' to a new file name to my local drive, no luck. Any help would be appreciated. Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel 2007, Sharing Violation when saving file | Excel Discussion (Misc queries) | |||
sharing violation when saving an excel file | Excel Discussion (Misc queries) | |||
Sharing Violation when saving | Excel Discussion (Misc queries) | |||
File Sharing Violation | Excel Discussion (Misc queries) | |||
How do I stop sharing violation errors in Excel 2003 - file NOT sh | Excel Discussion (Misc queries) |