I have built a couple macros that automagically get the attached spreadsheets from an email and apply a reformat function, but I need to specify which reformat is required via an InputBox.

Issue is that the InputBox is asking from Outlook but I need it to open in the Excel application. I thought something like this would work:

__

'code from outlook's vba (ThisOutlookSession)

Dim Xl As Object

Set Xl = New Excel.Application

Xl.MsgBox "Test"

__

This syntax/code is completely wrong as the 'Application' object (Xl) doesn't have a 'MsgBox' property, but I hope it demonstrates what it is i'm trying to achieve.

Thanks for your time