Search results for query: *

I was trying to write a macro in VBA in Excel which will print a number of schedules (using Adobe PDF, i.e. save as PDF files) ith Status date 1 Sep 11 for the period from 1 Apr 11 to 31 Mar 12. For some reason print out includes some months outside of that period. Does anyone have any idea...

The message still pops up :(

it works if u set Adobe pdf printer as default before openning MS project But wont work through code

Hi,I have a list of projects in Excel and I have written a macro to run through the projects, open it one by one in MS Projects, manipulate the view and print to PDF file. I have a line in the beginning of my code before I start looping through files: Application.ActivePrinter = "Adobe PDF on...

Hi,I have a list of projects in Excel and I have written a macro to run through the projects, open it one by one in MS Projects, manipulate the view and print to PDF file. I am struggling to automate "saving" process. File name + "Enter" is requested to be entered. Could anyone suggest how I...

* corrections: macro opens projects one by one

Hi, I have a list of projects in Excel and I have written a macro to run through the projects, open it on by on in MS Projects, manipulate the view and print to PDF file. My problem is that I cannot bypass "Links to Projects" window that pops up on some projects as it required user interaction...

This works: ActiveProject.BuiltinDocumentProperties("Keywords") = "Your text here

Hi,Can anyone help with writing a macro in VBA to change File properties in MS Project?I.e. File --> Properties --> Title, Author, Keywords etc.We need to change Keywords on a number of projects every month and I wanted to automate it but didn't have much luck.Used BuildInDocumentProperties in...