I finally found a couple of references in Help and on this site about going to Tools->Reference, and adding a reference for the app I'm working with. The difficult thing for me was getting Excel to talk to Project. You can use a Condition attribute to provide a default. For example, the following code references the BINPATH environment variable: (BINPATH)\MyAssembly.dll.Reference the environment variable the same way you would a variable declared in your project file. Getting a list of open project, that I can probably figure out. To use an environment variable in an MSBuild project. xls file from within MS Project's VBA, and I'm ok w/ that too. I was able to figure out how to export my data from project into a. But if I have a 25 MB MPP file, it gets exported to 300+ MB XML file. Is it possible I can export the MPP file to XML and read it. I've been doing Excel VBA for years and I'm ok with that part of it. User-1671350859 posted I want the ability to read MS Project file (MPP) into a. Hi, I have a suite of VBA routines in my Excel add-in, and for a new routine I'm working on, I want to have VBA get a list of open MS Project files, allow the user to select which ones to crunch, and then the VBA code will export them into excel, parse the dates and so forth.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |