Error - Incorrect Function

  • Thread starter Thread starter Oggy
  • Start date Start date
O

Oggy

Hi
I have the following code in a addin to close a spreadshhet and go
back to the menu. Everything works fine but i keep getting a error
message Incorrect Function.


Sub backtomenupo()

Dim Filename As String
Filename = Range("z1").Value & ".xlsm"
Workbooks(Filename).Close savechanges:=True
Workbooks("Menu.xlsm").Activate
End Sub

Please advise how i can fix this problem

Thanks in advance
 
What line causes the problem?
What's in Z1 of the activesheet?
What's the exact error message that you see?
 
What line causes the problem?
What's in Z1 of the activesheet?
What's the exact error message that you see?










--

Dave Peterson- Hide quoted text -

- Show quoted text -
Click to expand...

The problem occurs when i run the macro
Range Z1 is the file name which is also a purchase order number
The error message is "Incorrect Function"

Thanks
 
So how do you run this subroutine?

What particular line causes the problem?
What's the actual value in Z1?
 
So how do you run this subroutine?

What particular line causes the problem?
What's the actual value in Z1?








--

Dave Peterson- Hide quoted text -

- Show quoted text -
Click to expand...

I am running Excel 2007 and the sub routine is run by a custom xml
ribbon button.
The value of Z1 varies but would be on a number and letters combines
ie PO15

Thanks
 
I don't know enough about the ribbon to know.
I am running Excel 2007 and the sub routine is run by a custom xml
ribbon button.
The value of Z1 varies but would be on a number and letters combines
ie PO15

Thanks
Click to expand...
 
Back
Top