i work on an Excel sheet to generated automaticely a database on sql server 2000.
My server is a windows server 2003 and excel office 2003.
I load a macro with excel (after created a bouton to activate my macro)
and when i arrived to my interface to created database
i choose the botton
i have this message
"runtime error 52
bad file name or number "
and when i open visual basic debugger
it say to me that i have a problem on this line:
"If Dir(CurrentWb.Worksheets("INI").Range("ENV").Value, vbDirectory) = "" Then
MsgBox "répertoire " & CurrentWb.Worksheets("INI").Range("ENV").Value & " inexistant !", vbCritical
can i have a problem with function DIR in excel 2003 ??
In INI sheet,
I take the way ENV which correspond to the directory where i creaeted objects of my base.
And i do the same (not exactly the same but it the same idear) for the others elements of database...
My work is based on sql server development
and not visual basic competences
so if someone could help me !!!