Excel Text To Column Tips-1

We have the data like this. मेरे पास ऐसा डाटा है                       We need output like below. we have to split year, month & day. हमें नीचे की तरह आउटपुट चाहिए।                     Use of text column feature, we have to extract year, month & day. Text to Column feature का उपयोग कर , हमें वर्ष, महीना और दिन निकालना है । […]

Read more

Work on worksheet tab in excel

  To go to first or last sheet First और last sheet पर जाने के लिए.               In excel 2010 or previous version we had the button to scroll to the first and last sheet. Excel 2010 या पिछले versions में हमारे पास first और last sheet पर जाने के लिए  scroll button था।   But from excel 2013 that buttons have been removed. लेकिन एक्सेल 2013 से उस बटन को हटा दिया गया […]

Read more

Open Last Modified Excel File From A Folder Through Vba

Dear All,   We can use below vba code to open last modified excel file from a folder.   Sub Last_Modified_File() x = InputBox(“put Folder Path”) folder_name = x & “\” flname = Dir(folder_name & “*.xlsx”) Do While Len(flname) > 0 dttime = FileDateTime(folder_name & flname) If dttime > qq Then qq = dttime End If flname = Dir() Loop folder_name = x & “\” flname = Dir(folder_name & “*.xlsx”) Do While Len(flname) > 0 dttime = FileDateTime(folder_name & flname) […]

Read more

MKDIR Function in Excel Vba

MKDIR   In excel vba we use MKDIR vba function to create folder. MKDIR Function का उपयोग हम excel vba में folder बनाने के लिए करते है. I have to make a folder in D Drive which name will be computer. For this we have type code हमें D drive में एक फोल्डर बनाना है जिसका नाम COMPUTER होगा. इसके लिए हमें यह कोड लिखना होगा. Sub MakeFolder() MkDir “D:\COMPUTER” End Sub This Code will make folder in D Drive. यह […]

Read more