Hi, Kindly assist here to solve my issue.
I am getting error as Run time error 52 Bad file name or Number
and showing bug at highlighted line
I also seen the file name in Immediate window, pls check in below picture.
Kindly advise what can be the VBA code to handle this error.
The code should be
Code is typed not tested but this is the syntax for Dir and checking if the file is found
Please Login or Register to view this content.
Last edited by Keebellah; 04-23-2018 at 03:13 PM. Reason: Type ooo
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hi Keebellah, It is the same error again appeared at highlighted line even after modified as per your code.
If you do not have a drive D, you get that error.
Try something like this...
Please Login or Register to view this content.
Last edited by AlphaFrog; 04-23-2018 at 03:32 PM. Reason: missed the Else command
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
The you have either not assigned a value to WSAdmn
If I type
it works here so the problem lies in the variables you're using.Please Login or Register to view this content.
@Alpha, Yes your guess is absolutely right, in my PC D: refers to CD drive...
I applied your code but same error again appeared
Try using the FileSystemObject instead of Dir.Originally Posted by naveenmarapaka
Declare and set fso before your loop.
Please Login or Register to view this content.
What is the value op the cell you're readin?
WSAdmn.Range("P" & admnRow).value
I would not close my thread as solved without saying Thank you to you Alpha.
It really worked like a wonder finally.
thanks a million.
You're welcome. Thanks for the feedback.
You should thank Keebellah as well.
Yes Ofcourse thank you Keebellah for your great Support as well
You're welcome, nice to hear we all added our grain of sand to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks