Hi all. I love the mod and have followed for some time, but I've never felt the need to post. I'm having trouble with the FFH editor. First, when I open the editor in Excel 2007 I have to enable macros and links for it....that's perfectly fine. However, after I do so, I get a message saying that "The workbook contains one or more links that cannot be updated" If I choose to 'edit links' I see a link w/source "Ffh editor old.xls" type "worksheet" update "A" and status "Error: Source not Found." The location of the item is listed as "C:\Documents and Settings\Derek\Application Data\Microsoft\Excel. This looks to be a reference to someone else's file structure (I have no users on this machine named Derek). If I ignore/move past the error (the only thing I can think to do) I get an error when I try to 'Export Unit Information' from the 'Units' tab. I get kicked into Visual Basic and get the message 'Compile Error: Can't Find Project or Library'. I don't know enough about Visual Basic to fix this myself. All of the other export macros work perfectly well. Has anyone else run into this and/or is there a fix/known problem I've missed? Thanks!
-
We are currently performing site maintenance, parts of civfanatics are currently offline, but will come back online in the coming days. For more updates please see here.
Excel Error...
- Thread starter Dunraven
- Start date
BeefontheBone
Windbag of the sea
- Joined
- Nov 7, 2005
- Messages
- 2,018
That's a reference to Kael's file structure - looks like some sort of leftover from when he switched the editor to Excel 2007.
Farmer Bobathan
Sanity is for the weak
how do you get excel 2007?
Nikis-Knight
Deity
I've seen the same thing. It's motivated me to dig around the xml, which is fairly straight-forward, though of course not as easy as the editor.
Kael
Deity
I think I have those errors all fixed in the "Shadow" version, so it should be useable soon.
Kael
Deity
Check out the version of the editor that comes with patch "l" and let me know if it fixes the errors you were seeing.
Thanks for looking into it! Unfortunately, the patch L version only seems to fix half of the problem. The "The workbook contains one or more links that cannot be updated" error no longer occurs. However, the 'Export Unit Information' button still produces the 'Compile Error: Can't Find Project or Library' message. It then opens the sheet 5 code in visual basic and highlights "Private Sub CommandButton1_Click()" (the lead line) in yellow. I've opened up some of the other sheets' code and can't find any differences off in the similar sections...but I really don't know what I'm looking for...Like I said though, thanks for looking into, I know you have a lot on your plate already! 
