Count Open Workbooks

Count Number of Open Workbooks In Excel with Macro. मैक्रो से एक्सेल में open workbook की संख्या की Count करें।   Sub Name_of_Openwork() For Each Workbook In Workbooks Next Workbook End Sub   This code will identify all open workbooks. यह कोड सभी खुली workbook की पहचान करेगा . Sub Name_of_Openwork() For Each Workbook In Workbooks Msgbox workbook.name Next Workbook End Sub Msgbox will display all open workbooks name. Msgbox सभी खुली workbook ka नाम प्रदर्शित करेगा। Now I have to count, […]

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