1,322 reputation
11529
bio website
location Turkey
age 33
visits member for 5 years, 4 months
seen 7 hours ago

My Name is NT..!


Jan
28
comment Batch File for Download + Unzip (.7z) + Delete + Rename
Thank you @Tyler for your fast solutions. I just have downloading issue to be solved, I'm trying to understand wget structure but did not succeed yet.
Jan
27
comment Batch File for Download + Unzip (.7z) + Delete + Rename
Yes, that's why I've added a comment under the question.I don't know why the renaming code does not work with " - " sign? Which part of the code do I have to change to rename FILE-Date?
Jan
27
comment Batch File for Download + Unzip (.7z) + Delete + Rename
I've started by renaming function. Your rename code works fine with "" delimiter but when I try to use it with "-" delimiter it does not work, do I make sth. wrong? Just replaced "" by "-" in the code --> for /f "tokens=1,2 delims=-" %%A in ('dir /b *.mdb') do ren %%A_%%B %%A.mdb
Jan
27
revised Batch File for Download + Unzip (.7z) + Delete + Rename
added 101 characters in body
Jan
27
comment Batch File for Download + Unzip (.7z) + Delete + Rename
Thanks for sharing the first steps, I have realized that the link for files is on internet not on intranet. So I edited my question (Step1) So I think I should use another function in order to download files from internet (asking login and password if it's not saved on cache)
Jan
27
revised Batch File for Download + Unzip (.7z) + Delete + Rename
Changed "intranet" with "internet", added more details
Jan
26
asked Batch File for Download + Unzip (.7z) + Delete + Rename
Jan
15
awarded  Notable Question
Jan
9
comment highlighting duplicate rows in excel by VBA macro
Which part do I need to edit for new colors? @Ron Rosenfeld
Jan
8
comment highlighting duplicate rows in excel by VBA macro
Works like a charm after renaming the class module.Big thanks for the code...
Jan
8
accepted highlighting duplicate rows in excel by VBA macro
Jan
8
revised highlighting duplicate rows in excel by VBA macro
added 186 characters in body
Jan
8
comment highlighting duplicate rows in excel by VBA macro
1st of all, thank you for the code. First- I've inserted a class module and pasted the first part of the code inside. Then- I've inserted a (regular) module and pasted 2nd part of the code. Finally, I ran the macro by selecting the active sheet with the data to be checked. I gives me following warning (imageshack.com/a/img913/3478/U6F1pV.jpg) and opens debugger. Do I make sth. wrong? Here is screenshot of the the code debugging screen :imageshack.com/a/img661/6750/58Eka6.jpg Here is the sample data that I run the macro : imageshack.com/a/img631/4632/IPStdS.jpg
Jan
8
comment highlighting duplicate rows in excel by VBA macro
yes you're right, I just gave some examples. I did not mention all table...
Dec
30
comment highlighting duplicate rows in excel by VBA macro
this method highlights only the rows which are exactly same. It does not take into account "/" should be assumed as "+" or "-" during duplicate detecting. So it's does not solve my problem.Moreover, as it's done by conditional formatting not by VBA macro, it's not applicable for me.
Dec
28
revised highlighting duplicate rows in excel by VBA macro
deleted 190 characters in body; added 1 character in body
Dec
28
comment highlighting duplicate rows in excel by VBA macro
Edited the text box...I made red texts in order to underline that for those cells, the "/" value behaves like "+" or "–"
Dec
28
revised highlighting duplicate rows in excel by VBA macro
edited body
Dec
26
asked highlighting duplicate rows in excel by VBA macro
Dec
18
awarded  Popular Question