How would I open a MsgBox or Inputbox in Excel, but from Outlook's VBA session?
I have built a couple macros that automagically get the attached spreadsheets from an email, open them, prompt the user and then 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 absolutely need it to open in the Excel application. I thought something similar 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.
I have been googling for a couple days now, have asked in 4 or 5 forums and nobody seems to know how to do this. Am willing to pay someone for the answer at this point, if it is at all possible!
Thanks for your time :)
