Trouble Opening Workbook

  • Thread starter Thread starter Steve Andrews
  • Start date Start date
S

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
 
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.
 
Back
Top