export a msgbox result from MSP to excel

M

Mohsen

Can someone please tell me if I can export a msgbox result from a macro
of MSP to Excel?
 
R

Rod Gill

Hi,

In future you will be safer posting to the project.developer group as this
one is closing down soon.

If you already have an object pointing to Excel, then

xlApp.range("A1") =MyMsgBoxResult

will work. If you haven't got to the Excel object stage yet, then search VBA
help on working with other applications. My book on Project VBA (see my
signature) has a number of examples of working with Excel!

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more
Project VBA Book now in stock: visit www.projectvbabook.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Using Office Forms and dynamically updating the excel backend 0
How to export html text as word document with specific size and orientation 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Images are pixelated when saving to PDF 0
Converting isse with Export in Outlook 0
Help creating a search form in Access XP 0

Top