View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Open method of worksbooks class failed

Actually, I just commented out the line with DTSGlobalVariables.

Jim Cone


"Jim Cone" wrote in message ...
You had better ask Ben. The code he provided was only a partial.
The FileSystemObjects variables, DTSGlobalVariables
and others are undeclared. To get my test code to work I had to
arbitrarily declare them as I saw fit...
Dim DTSGlobalVariables as String

Jim Cone


"GregR" wrote in message
oups.com...
Jim, in using your code, I get a not defined error for
DTSGlobalVariables. TIA
Greg