I am writing a vb appplication in MSAccess to extract field info from project
into Access tables. I also would like to ave a copy of the Gantt view when
filters are applied so that I can create a formatted report from MS Access
which presents MS project data organized in a particualr format, with a
corresponding picture at the top of the report.
I have automated the retrievable of all of the MS oproject field data that I
need. Does anyone know how you can save a picture of a filtered view in MS
project into an OLE field in MS Access.
I am able to programatically filter an MS Project file and, using
EditCopyPicture, can save the picture as a gif file with a new name. I would
like to be able to programatically, using vba, add some input strings to the
EDITCOPYPICTURE dialog to change the file type to gif, re-defining the date
range and renaming the final gif files. Can anyone show me how to add an
input string to a dialog which is generated by MS Project? Once I am able to
programatically create gif views, I will then need to read the gif into an MS
Access OLE field ( or link it so it can be refreshed when the graphic
Any help would be appreciated.