Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel Runtime Error 52


  • Please log in to reply
No replies to this topic

#1 poosh

poosh

  • Members
  • 2 posts
  • OFFLINE
  •  
  • Local time:03:17 AM

Posted 29 June 2006 - 10:37 AM

hello,
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
Exit Function
End If
"

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 !!! :thumbsup:
thanks

BC AdBot (Login to Remove)

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users