Brain-Hurts
New Member
- Joined
- Mar 10, 2009
- Messages
- 2
I have a survival level knowledge of Excel and can follow instructions within the UI, but I may need some clarification for any answers regarding VB. I can make the file below available privately if needed, but cannot post it publicly.
INTRO:
My company has for years used a very well put together document for configuring radio equipment and identifying conflicts through a visual representation of the equipment. After a password prompt to open the sheet (which we have) it opens a welcome page that asks if you AGREE/DISAGREE to terms. Clicking on the "I AGREE" button then opens the actual guts of the operation, with it's multitude of tabs and information. None of this is visible until after clicking on that button.
PROBLEM:
The problem is that our company pushed a WIN7/laptop upgrade and opening the document on any of the new laptops brings up the first sheet, but clicking the AGREE button closes it, leaving behind nothing but a blank Excel window.
The sheet was created in 2002 and is saved in .xls format, having been used without issue with Excel 2003 in XP. We are trying to open it in Excel 2007 with Win 7.
The second major problem is support. The original author retired 3 years ago, and our company now funnels all IT issues through HP, and thus, India. They can handle the vanilla PC's they supply for the most part but for any any real problem that does not have a keyword in their knowledge base stops them dead. Escalating back here to the states was a bad idea, because someone decided to mark it as "non-supported" in the new upgrade. The burden falls upon us now
THE QUESTION:
Can I just open the sheet by doing away with the welcome page? Remember, I already have the password to open and access the sheet. Just modifying or exploring deeper ran into the other passwords.
This SEEMS like a very simple problem but it is made complex by lack of understanding of how Excel macros work. I see this is a single, 12Mb file and figured there has to be some type of call/routine when that button is clicked but anywhere I try to look the info is PW protected. I removed the sheet PW with an external app, and ran into yet another PW within the VB area. <---This is futile anyway since I do not know what I am looking for, but I am an investigator so looking for clues is just part of the fun.
SUMMARY:
Macro worksheet worked in Excel 2003/XP. Does not work in Excel 2007/Win7. Introduction/gateway worksheet button no longer opens the main file. I would like to remove/bypass the introduction sheet, or understand and repair the problem altogether. I can send the file privately to someone who has the knowledge to help, but cannot post it publicly.
See some screen caps below and thanks for any help
1. Initial Opening Page
2. Intro/Gateway page
3. Proper function when it works
4. What actually happens
5. windowed version of the above screen
INTRO:
My company has for years used a very well put together document for configuring radio equipment and identifying conflicts through a visual representation of the equipment. After a password prompt to open the sheet (which we have) it opens a welcome page that asks if you AGREE/DISAGREE to terms. Clicking on the "I AGREE" button then opens the actual guts of the operation, with it's multitude of tabs and information. None of this is visible until after clicking on that button.
PROBLEM:
The problem is that our company pushed a WIN7/laptop upgrade and opening the document on any of the new laptops brings up the first sheet, but clicking the AGREE button closes it, leaving behind nothing but a blank Excel window.
The sheet was created in 2002 and is saved in .xls format, having been used without issue with Excel 2003 in XP. We are trying to open it in Excel 2007 with Win 7.
The second major problem is support. The original author retired 3 years ago, and our company now funnels all IT issues through HP, and thus, India. They can handle the vanilla PC's they supply for the most part but for any any real problem that does not have a keyword in their knowledge base stops them dead. Escalating back here to the states was a bad idea, because someone decided to mark it as "non-supported" in the new upgrade. The burden falls upon us now
THE QUESTION:
Can I just open the sheet by doing away with the welcome page? Remember, I already have the password to open and access the sheet. Just modifying or exploring deeper ran into the other passwords.
This SEEMS like a very simple problem but it is made complex by lack of understanding of how Excel macros work. I see this is a single, 12Mb file and figured there has to be some type of call/routine when that button is clicked but anywhere I try to look the info is PW protected. I removed the sheet PW with an external app, and ran into yet another PW within the VB area. <---This is futile anyway since I do not know what I am looking for, but I am an investigator so looking for clues is just part of the fun.
SUMMARY:
Macro worksheet worked in Excel 2003/XP. Does not work in Excel 2007/Win7. Introduction/gateway worksheet button no longer opens the main file. I would like to remove/bypass the introduction sheet, or understand and repair the problem altogether. I can send the file privately to someone who has the knowledge to help, but cannot post it publicly.
See some screen caps below and thanks for any help
1. Initial Opening Page
2. Intro/Gateway page
3. Proper function when it works
4. What actually happens
5. windowed version of the above screen