I get and error when i try to run a module named 'Merge' in the workbook
section before save.

Sub Workbook_BeforeSave()

Merge

End Sub

How can I make this work?

Kiba,

I see three possible problems:

1. "Merge" is an Excel reverved word, so it's not a good choice for a sub
or function name. Change the name from "Merge" to something else.
2. If it's really a module name, you can't "run" a module, so that might be
the problem in that case.
3. A Workbook_BeforeSave event really starts like this:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
The best way to create this event is to go into the ThisWorkbook module,
choose "Workbook" in the dropdown at the top left and choose the event in
the dropdown at the top right.

hth,

Doug

"Kiba" <(E-Mail Removed)> wrote in message
news:CB85F2EB-9AEA-4E50-94DA-(E-Mail Removed)...
>I get and error when i try to run a module named 'Merge' in the workbook
> section before save.
>
> Sub Workbook_BeforeSave()
>
> Merge
>
> End Sub
>
> How can I make this work?

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Call merge
End Sub

merge must be in a standard module.
--
Gary''s Student - gsnu200808


"Kiba" wrote:

> I get and error when i try to run a module named 'Merge' in the workbook
> section before save.
>
> Sub Workbook_BeforeSave()
>
> Merge
>
> End Sub
>
> How can I make this work?

Gary''s Student ,

"merge must be in a standard module."

Actually it can be in the ThisWorkbook module. Also, the OP doesn't need to
start using Call. For example, this code can all be in the ThisWorkbook
module:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Test
End Sub

Sub Test()
MsgBox "test"
End Sub

Doug

"Gary''s Student" <(E-Mail Removed)> wrote in message
news:9B3BD644-A020-41E1-931E-(E-Mail Removed)...
> Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
> Boolean)
> Call merge
> End Sub
>
> merge must be in a standard module.
> --
> Gary''s Student - gsnu200808
>
>
> "Kiba" wrote:
>
>> I get and error when i try to run a module named 'Merge' in the workbook
>> section before save.
>>
>> Sub Workbook_BeforeSave()
>>
>> Merge
>>
>> End Sub
>>
>> How can I make this work?