Trouble Opening Workbook

[Steve Andrews]

Hi All,

A macro of mine opens another workbook with the statement:

Workbooks.Open FileName:="C:\request.xls"

As I trace through it, it would previously open the
appropriate workbook. But now this statement and some
others to follow do not change my instance of Excel in the
slightest. Why is my trace so silent all of the sudden?
Any ideas?

Steve

 

[Guest]

Hi Steve,

I have a similar problem in that a VBA macro that used to work now quits executing after it opens a file. I have no suggestions, but it sounds similar to your problem. Perhaps the gurus will have a suggestion.

I reduced my macro to the following and it always opens the file but stops executing before the move to the last entry in column B.

ChDir "C:\Documents and Settings\bill\My Documents\NewCode\TestFileOpen"
Workbooks.Open Filename:="TestFile.xls"
Range("B2").End(xlDown).Select
...

Let's hope someone knows what our problem is.