Hi experts,
i am doing a macro where i want to restrict double file entry while extraction.
i set the the "Log" sheet name where i write all the filename in B column.
Start of the macro i have check the filename in sheets("Log") is exists or not
this is the code i have set
if i run macro for first time of Feb Month then it shows me correct result because Log sheet have no filename.
but if i run second time of same Month (Feb) then it also run but output is totally blank.
i checked the count of running file in msgbox then it show me 0 value but same file is exist in Log Sheet
how this happening?
Please suggest me
Bookmarks