You can visit this link which is a good start. Prerna: Can u also provide me the tutorial to learn macros to be used in excel.It would be very helpful '~~> Now you have the MPP file opened, rest of the code goes here Set appProj = CreateObject("Msproject.Application") '~~> This is the Sheet Where you want the data to be copied Since you have not mentioned what you want to copy and where exactly, i will give you a very basic code which you can then work on. See How to: Add an Attachment in Microsoft Excel or Microsoft Project for more information. Click OK to close the References dialog box. 1 It looks like you need to save the email message to the hard drive (see the SaveAs method of the Attachment class) and then add it as an attachment to the Project task. The default location is C:\Program Files\Microsoft Office\Office. If the Microsoft Project 9.0 Object Library is not listed, click Browse to locate the MsprjXX.olb file, which is in the folder where you have Microsoft Project installed. In the Available References list, click to select the Microsoft Project xx.xx Object Library check box. To work with MPP file in Excel, Open the VBA Editor and click References on the Tools menu.
0 kommentar(er)
