Corrupted VBA

Need Help with the Loot Divider?
Ask in this section!
Post Reply
jetstrike
Squire
Squire
Posts: 3
Joined: Tue May 08, 2012 12:50 am

Corrupted VBA

Post by jetstrike »

I purchased the loot divider over at paizo's website. Every time I load it in excel 2007 it gives an error saying "The Visual Basic for Applications (VBA) macros in this workbook are corrupted and have been deleted. The macro corruption most likely exists in the current file. To recoiver the macros, open a backup copy of this file if you have one." I have tried redownloading the sheet a few times. Parts of the sheet seem to work while others such as the Player's Loot Section never populate with items assigned. What can I do to fix this?
User avatar
admin
-={ ARCHMAGE }=-
-={ ARCHMAGE }=-
Posts: 11402
Joined: Wed May 25, 2005 5:51 pm
Location: Golarion
Contact:

Re: Corrupted VBA

Post by admin »

This is not caused y the Loot Divider itself.
A google search turns up many possible explanations for this error.

Do you get this error with ANY workbook that contains Macros?
If yes, then (according to this) your VBA component in Excel are not installed. You need to install it.

Other possibilities (according to this):
- Interference from Virus Checker
- Bad Excel installation

Have you tries the LD on another installation/computer?
You can try a google search for more info...

admin
jetstrike
Squire
Squire
Posts: 3
Joined: Tue May 08, 2012 12:50 am

Re: Corrupted VBA

Post by jetstrike »

I see I never had a problem with macro's previously however very few files I have had used macros. I am reinstalling microsoft office to see if this resolves my issue. Thank you for the timely response.
User avatar
admin
-={ ARCHMAGE }=-
-={ ARCHMAGE }=-
Posts: 11402
Joined: Wed May 25, 2005 5:51 pm
Location: Golarion
Contact:

Re: Corrupted VBA

Post by admin »

jetstrike wrote:I see I never had a problem with macro's previously however very few files I have had used macros. I am reinstalling microsoft office to see if this resolves my issue. Thank you for the timely response.
You can try this small workbook to test your macros.

admin
Attachments
TestMacros.zip
(8.01 KiB) Downloaded 409 times
jetstrike
Squire
Squire
Posts: 3
Joined: Tue May 08, 2012 12:50 am

Re: Corrupted VBA

Post by jetstrike »

I no longer get macro errors but when I assign treasure to a player on the treasure page It never appears in the play loot tracker page.
Post Reply

Return to “Help Desk”