Dump/Load Custom Field and Outline Code definitions?

[G Lykos]

Greetings! Anyone aware of a pair of macros to dump and load custom field
and outline code definitions, to facilitate the re-hosting of schedule data
from a corrupted Project file to a fresh empty one?

Thanks,
George

 

[John]

Greetings! Anyone aware of a pair of macros to dump and load custom field
and outline code definitions, to facilitate the re-hosting of schedule data
from a corrupted Project file to a fresh empty one?

Thanks,
George

George,
Since the file is corrupt, I assume you can't even open it to run a
macro to get the data. Depending on the level of corruption it may be
possible to directly query the Project database to get the information -
at least it might be worth a try. If not, grit you teeth and start over.

For the table definitions in the database, look for the Project database
description file called projdb.htm (or something similar) on your hard
drive.

Hope this helps.
John
Project MVP

 

[G Lykos]

John, to see if there might be further options available - the file
corruption in this case is to the VBA pocket in the project file, provoking
a "VBA file not found" error message upon entering and leaving VBA-land when
that project file is open, and the file-resident VBA library to not be seen
or accessible in Navigator. I saw a macro to list custom field definitions
mentioned, I believe. Is there a pair of them to serve dumping and then
loading definitions?

Thanks,
George

 

[John]

John, to see if there might be further options available - the file
corruption in this case is to the VBA pocket in the project file, provoking
a "VBA file not found" error message upon entering and leaving VBA-land when
that project file is open, and the file-resident VBA library to not be seen
or accessible in Navigator. I saw a macro to list custom field definitions
mentioned, I believe. Is there a pair of them to serve dumping and then
loading definitions?

Thanks,
George

George,
We've had posts before concerning the "VBA file not found" problem but I
don't remember if there were any good solutions. You might try a search
in this newsgroup or in the main newsgroup. My thinking is that if a VBA
module doesn't show in the Project Explorer yet the error message
appears, then it it probably a corrupt Private module.

It sounds like you can open the Project file itself. I don't know if
this will help, but you might try one of the suggestions listed under
FAQ 43 - File Bloat? Might be corruption on our MVP website at:
http://www.mvps.org/project/faqs.htm

With regard to existing macros to list custom fields, I don't know of
any. The only thing that comes close is fellow MVP, Jack Dahlgren's
Macro called "Check Field". You can access Jack's website at:
http://masamiki.com/project/macros.htm

Hope this helps.
John
Project MVP