Page 1 of 1

Corrupted VBA

Posted: Tue May 08, 2012 12:59 am
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?

Re: Corrupted VBA

Posted: Tue May 08, 2012 8:21 am
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

Re: Corrupted VBA

Posted: Tue May 08, 2012 3:27 pm
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.

Re: Corrupted VBA

Posted: Tue May 08, 2012 4:13 pm
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

Re: Corrupted VBA

Posted: Thu May 10, 2012 1:19 am
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.