View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geoff Geoff is offline
external usenet poster
 
Posts: 371
Default VBA freezes after opening file

I have just encountered an error where stepping through code, the following
assignment statement fails:

Set fOut = Workbooks.Open(fNameOut)

fOut is a workbook variable and fNameOut is its name - basically the
workbook opens fine, but the value of fOut is Nothing. When I try to step
into the code from this point, the program refuses to go any further. There
is no error message, and execution refuses to move past the highlighted line.

--
There are 10 types of people in the world - those who understand binary and
those who don't.