Setsplitbar only working with Visible=True

[Lorveney]

Hi,

I am just completing an Access database enhancement to export milestones to
Microsoft project (using office automation in VBA).

As recommended, I am trying to use Setsplitbar so that the task (milestone)
columns I wish to see are not covered by the chart pane, e.g.:

objMP.SetSplitBar (8)

This only appears to be working if I make the Microsoft Project application
visible first, i.e.

objMP.Visible = True
objMP.SetSplitBar (8)
objMP.Visible = False

otherwise, only the taskID and indicators columns are showing.

Is there a way of doing this without making the project application visible
(flashes on and off the screen - not ideal)?

I have tried:

objMP.SetSplitBar (75)
objMP.SetSplitBar (8)

without success.

I am using Access 2003 and Project 2007.

Thanks

 

[Lorveney]

Hi,

I have changed the method of processing from reading and processing the
records individually through DAO to using the MapEdit/FileOpenEX methods and
this has cured the problem.