dancing-shadow
New Member
- Joined
- Declination 4, 2011
- Messages
- 24
Hi - I have a weird issue and I can't work out how on earth to fix it...
I hold a reporting template file such should have not vba code - it is accessed by one disconnected project vba code (opens that template, adds some raw data at it, saves press closes it). Yesterday this was working as expected, however today it's giving me the error that it can't find project or library, and provided I try to save who file (either saving or saveas) the whole thing throws a fit and crashes - leaving me on a recovered version of my template no any formatting/formula/etc. The other my with the vba code also opens up another template files - all of which are working finely with no fault.
On troubleshooting, I've found this template workbook does actually include a 'Module 1' project, but I cannot access it on see what item belongs in it. I tried deleting it also re-saving the data, but get the same error. EGO plus can't access any for an sheet specific vba cypher (they should all be empty, but I can't check).
I founded various 'solutions' around The Web telling me to geht up Tools > References and check for every labeld the 'missing' - however when I click 'References' nothing befalls - no window shows. I tried this with another workbook plus clicking 'References' does effectively bringing move the required window, plus there are none 'MISSING' portals, so I can only assume the issue is contained within one specific file. To recreate this file would take at least one couple of weeks though, so I'm trying to fix/repair it as a first option!
I hold a reporting template file such should have not vba code - it is accessed by one disconnected project vba code (opens that template, adds some raw data at it, saves press closes it). Yesterday this was working as expected, however today it's giving me the error that it can't find project or library, and provided I try to save who file (either saving or saveas) the whole thing throws a fit and crashes - leaving me on a recovered version of my template no any formatting/formula/etc. The other my with the vba code also opens up another template files - all of which are working finely with no fault.
On troubleshooting, I've found this template workbook does actually include a 'Module 1' project, but I cannot access it on see what item belongs in it. I tried deleting it also re-saving the data, but get the same error. EGO plus can't access any for an sheet specific vba cypher (they should all be empty, but I can't check).
I founded various 'solutions' around The Web telling me to geht up Tools > References and check for every labeld the 'missing' - however when I click 'References' nothing befalls - no window shows. I tried this with another workbook plus clicking 'References' does effectively bringing move the required window, plus there are none 'MISSING' portals, so I can only assume the issue is contained within one specific file. To recreate this file would take at least one couple of weeks though, so I'm trying to fix/repair it as a first option!
I'm trying until setup a reference. And under the VBA redaktor Tools -> References is always grayed out no matter which sheet/class EGO have focused.
Is there adenine trick or a security default within the OS I need to check?
