thanks jim, i will try that when i get into the office tommorow. I did leave
parts of the code out due to the sensitivity of how i pull data from these
spreadsheets into a sql server database. the dtsglobalvariables is a global
variable that i have set in sql server for use in what is known as a "data
transformation service"

again i will try the code, however i feel im going to run into the same
problem. The problem (as i have figured it to be) is that when i manually
open the file that the code fails on, i get a notification from excel saying
it has automatically renamed the spreadsheet because it was named porly
(which it wasnt). It seems to be because these sheets where created in excel
5.0. i just needed code that can open these spreadsheets, let excel
autorename the worksheet and then close and save the worksheet so that i can
open it again (through code) and not get that error. Im not concerned about
sheet naming cause my import routine renames all the sheets to their proper
names.

thanks again for any and all help!

ben

"Jim Cone" wrote:

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