Is there a way to get VBA script on BCA to refresh a Doc p

ng it as version 4?

I have developed a VB script for Emailing BO docs. The script sits on our BCA as a VBA Add-In. However, I have one remaining problem, whereby when the script refreshes, saves and sends a V4 doc, it converts the doc to V5. I would like the script to refresh and send V4 docs as V4 and not convert them to V5 in the process.

Now I do know the BCA can refresh V4 docs (preserving them as V4) when choosing a the Refresh Action when sending the doc to a BCA from a 4 client - and have done this. However, when I try and do the same thing within my VB code it coverts a V4 doc to V5, i.e.

V4 doc in
|
V
doc.refresh

doc.save

… followed by my procedure for sending via MAPI

|
V
V5 doc out!

I think that when I omitted the doc.refresh action out, doing this by choosing the Refresh Action when scheduling it did send the doc as V4, unfortunately when trying this method out it simply sent unrefreshed V4 doc (i.e. the script wasn’t actually picking up refresh doc) … anyway I would prefer the V4 user not to have to select the Refresh option.

Anyone out there got any ideas???

Is there a way to doc.refresh & doc.save within a VB script running on the BCA preserving it’s V4ness?

Alternatively is there a tool out there that can downgrade a V5 doc to V4?

Regards,

Daniel.


Listserv Archives (BOB member since 2002-06-25)

ervi ng it as version 4?

William,
Can you send me the script. I am looking for a script to email documents from BCA.
Thanks
Nilesh


Listserv Archives (BOB member since 2002-06-25)

ervi ng it as version 4?

Christophe,

Thanks very much for that!

I have one further question to make a complete solution… Is there a way to find out if the doc sent to the BCA was originally V41, so as to only apply the “doc.DesiredFormatVersion41 = True” V41 docs, hence making the script work for both V41 & V5 docs.

Regards,

Daniel.

Daniel,

There is a hidden property for a document object.

Insert this line in your script :

doc.DesiredFormatVersion41 = True

Good luck,
Christophe


Listserv Archives (BOB member since 2002-06-25)

erving it as version 4?

William,
Same here, a VBA script to mail refreshed documents from BCA would be most helpful. I think that Business Objects automatically converts a 4.x document to 5.x when you installed the 5.0 upgrade. This is the first time I have heard a request for a utility to convert back from a 5.x document. I am not sure what the benefit would be. Could you elaborate?

Thanks
Jim Lafferty


Listserv Archives (BOB member since 2002-06-25)