Hi. I've been looking for a solution for at least an hour. I have this code:
The fact is, the macro is always in a different workbook, which is always name with 5 numbers, for example 36916. But, in some times, we must use the same number several times so we add for example -A. We I run the macro and the workbook name is just 36916, everything works fine. But when the workbook name is 36916-A, it says the macro cannot be run.
Someone can help me ? thanks!!
Steeven
Code:
Private Sub EXPORTER_Click()
If ActiveSheet.Name = "MODULES" Then
Application.Run ActiveWorkbook.Name & "!QUESTION_EXPORTER_VERS_TECHNIQUE_MODULE"
ElseIf ActiveSheet.Name = "ACCESSOIRES" Then
Application.Run ActiveWorkbook.Name & "!QUESTION_EXPORTER_VERS_TECHNIQUE_ACCESSOIRE"
End If
Unload Me
End Sub
The fact is, the macro is always in a different workbook, which is always name with 5 numbers, for example 36916. But, in some times, we must use the same number several times so we add for example -A. We I run the macro and the workbook name is just 36916, everything works fine. But when the workbook name is 36916-A, it says the macro cannot be run.
Someone can help me ? thanks!!
Steeven