VBA line not working

[Ezguy4u]

I have this program that has recently stopped working because of one line. I am getting an error message "Run-time error Automation error Invalid forward reference, or reference to uncompiled type". The program is fairly long but I have narrowed the problem down to 2 lines.
Workbooks.Open Filename:=strFile
Sheets(1).Select
When I run the program or even step thru the program the Workbooks.Open Filename:=strFile does open the workbook. Actually it opens 2 other workbooks before it just fine. It even executes Sheets(1).Select for the 2 other workbooks. But on the 3rd workbook I get the run time error. Now I make sure the 1st sheet is select just to be safe but if all the 1st sheets are selected I can comment out the Sheets(1).Select and the whole program works with no problems. Maybe somebody else has experienced this error. If my explanation isn't clear enough let me know.
Thanks for your time
Arnold

 

[Michael M]

Might be a lot easier to debug if you post ALL of the code, rather than a couple of lines.
When posting the code make sure you enclose the code in code tags....( the little VBA button on the reply toolbar

 

[Trebor76]

I have this program that has recently stopped working

Something must have changed. Has the first sheet (i.e. furthest left) of the third workbook become hidden? If you compile the macro (follow the path Debug > Compile VBA Project from within the Visual Basic Editor) are there any errors? Is there an auto exec macro on the third workbook that's clashing?

 

[Ezguy4u]

Ok so Thank you Michael for your reply. It would be the next step but the program and workbook is really big. I wanted that to be my last resort. Trebor, you motivated me to look at the workbook that the program was opening and there was one of those value change programs attached. I deleted the value change program and ran the big program and it worked. Now all the other workbooks had that same value change program, so I reinstalled the value change program and now everything is working. I don't know how the value change program workbook got changed or corrupted, but in the end, a systematic trouble shooting techniques solved the problem. Thanks all

 

[Trebor76]

I don't know how the value change program workbook got changed or corrupted, but in the end, a systematic trouble shooting techniques solved the problem. Thanks all

Thanks for letting us know and you're welcome