How would I open a MsgBox or Inputbox in Excel, but from Outlook's session?

[VBEveryday]

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

[dflak]

I work this issue from the Excel Side. I have a spreadsheet where you fill in the Outlook folders to find the email and it goes out and downloads the attachments to whatever Excel folder that is filled in on this master spreadsheet.

I also have code, in a different workbook, that opens a workbook and runs the macro you specify.

These two pieces of code could be married - if you are willing to use Excel to pull from Outlook rather than use Outlook to push to Excel.