MergeWorkbook does not work, SaveCopyAs works.......... ideas?

The following works good, except for, when I open the saved copy it tries to load the Customization assembly.

I tried code to remove customization, but as per the code, no customization exists.

Any help, hugely appreciated!

If (ServerDocument.IsCustomized(absoluteFilePath)) Then 'false

ServerDocument.RemoveCustomization(absoluteFilePath)

End If

Tried this as well, to no avail.............

Dim sd As ServerDocument = Nothing

Try

sd = New ServerDocument(absoluteFilePath) 'Exception {"Unable to retrieve the manifest from the document."}

Catch ex As Exception

Finally

If Not sd Is Nothing Then

End If

End Try

sg@Lehman Bros.

sg@Lehman Bros.

I do not wish to remove the customization from the current workbook, just from it's backup.

I create a copy of the current customized workbook, and then try to remove the custmoization from the copy, not from self.

Further, the lil awkward part is, when I try to access the "workbook copy" using a Console Applicatin\ServerDocument, it actually does not show any manifest information.

However, if I simply lauunch the "workbook copy" by a double-click, it tries to load the customization and fails.

Appreciate your taking time Steve.

Anyways,

I found a workaround, instead of creating a copy of the workbook, I create an empty workbook, and copy all the sheets from the current to the backup, and all works neat, especially since, I do not have code behind the worksheets (just behind the workbook).

Have you tried removing the customization first and then making a copy of the workbook using SaveAs That has always worked for me.

Also, if you are using an Actions Pane, you need to detach that as well before saving and then reattach it.

To detach: Me.ActionsPane.Clear or Globals.ThisWorkbook.ActionsPane.Clear

To reattach: Me.ActionsPane.Show or Globals.ThisWorkbook.ActionsPane.Show

Robert

Hi Bros,

SaveCopyAs and MergeWorkbook are two different functions. They are designed to complete diffirent tasks. These instrutions are from MSDN about these two functions:

Saves a copy of the workbook to a file but doesn't modify the open workbook in memory.

Syntax

expression.SaveCopyAs(Filename)

expression Required. An expression that returns a Workbook object.

Filename Required. Specifies the file name for the copy.

Merges changes from one workbook into an open workbook.

Syntax

expression.MergeWorkbook(Filename)

expression Required. An expression that returns a Workbook object.

Filename Required String. The file name of the workbook that contains the changes to be merged into the open workbook.

So I think when you use the MergeWorkbook function. there must be a workbook file already in the absoluteFilePath.

Thanks

Ji

True, there should be a workbook existing to merge, and actually there is one in my case.

I do a to SaveCopyAs create a backup

And then at a later time do MergeWorkbook to merge this backup(created above) into another spredsheet that I have.

No solution yet, nevertheless, really appreciate you taking time!

Thanks.

Well Ji,

It doesn't copy the customization assembly, and neither do I want it to. But why does it hold the reference to the assembly & try to load it, when opened.

And if it does hold the reference to the assembly, why can't I see it\remove it. (In my posts above, I have detailed my attempts at removal of the reference.)

Thanks,

Saurabh

P.s. Good to know MSFT guys are administering the forums closely. It's critical to!

Saurabh,

I'm trying to understand your scenario here. You have a workbook with a customization assembly. You want to create a copy of that and have that copy not load the customization. Where does the MergeWorkbook come in Are you calling MergeWorkbook in the same customization assembly as the SaveAs

Robert