vba problem when upgraded to version 6.1

[DrSmyth]

HI,

We've just finished upgrading to version 6.1a and are having a few problems:

Firstly, i used to run some reports as scheduled tasks from windows. I just put some vba behind an auto open routine on a document and it ran when the document was opened... simple... for some reason none of my auto open routines work anymore, it's as though the code isn't running when the document is opened..

Second, someone else has upgraded a couple of other pc's in my office and they don't seem to be able to connect to the repository anymore. If they try and open an existing file then it tells them that they do not have the security to do so, and when they try to create a new document none of the universes in the repository are available to them, they just get the option of using one of the default bo universes (the ones that come on the installation disk).

the only thing we've done that is out of the norm is to install the upgrade from our server (someone in head office has copied the installation disk onto our server)

this is a bit of a lengthy query but any help will be appreciated..

Cheers

 

[DrSmyth]

OK... Update, we've fixed the other users not being able to connect to the repository problem, now we're just stuck with the vba issue...

Had to do a reinstal in the end and it seemed to sort everything (apart from the vba problem) out...

 

[DrSmyth]

Update... Have now sorted the VBA problem, basically i've had to change all of my coding so that every line refers to an object from intrinsically.. eg:

version 5.6 i had:
dim doc as document
dim rep as rep
set doc = application.documents.item(1)
set rep = doc.reports.item(1)
doc.refresh
rep.exportastext("filename")

whereas in version 6.1 i have to put:
application.documents("Documenta").refresh
application.documents("Documenta").reports("Report1").exportastext("filename")

This has proved to be a right pain, don't spose anybody knows whats going on here do they?