suhaslsawant
07-06-2008, 10:20 AM
I have created macro for my project. when i open the workbook directly through excel application i got runtimeerror no. 75. but when i open the same workbook using explorer and run macro it works smoothly without any error message. Can somebody give me the reason behind the error.
the error is very ignorable. i have created 4 directories for temp files and for debugging if necessary. near the ending of programm i have removed all the files in the folder than i removed the folder. all the folders and files are removed using RmDir but one empty folder gave me runtime error 75. the path is not accessable.
I have marked another thing that when excel is open i can not remove that perticular folder and i got display alert that the folder is being used by other program. but when i go through explorer it removes without any display alerts.
i have find out the property readonly or link but i do not able to debug this problem. kindly help me out.
SUHAS SAWANT
the error is very ignorable. i have created 4 directories for temp files and for debugging if necessary. near the ending of programm i have removed all the files in the folder than i removed the folder. all the folders and files are removed using RmDir but one empty folder gave me runtime error 75. the path is not accessable.
I have marked another thing that when excel is open i can not remove that perticular folder and i got display alert that the folder is being used by other program. but when i go through explorer it removes without any display alerts.
i have find out the property readonly or link but i do not able to debug this problem. kindly help me out.
SUHAS SAWANT