Forum

A S
@ac-porta-via
Active Member
Joined: Nov 7, 2020
Topics: 0 / Replies: 6
Reply
RE: Open last modified file

If you want to open last modified file in the folder, try below code Sub openLastModified() Dim FolderPath As String, tableName As String, latestTb...

3 years ago
Forum
Reply
4 years ago
Forum
Reply
RE: Using Macro to add and name command button

Try this Sub ADD_BUTTON_UnprotectWorksheets() Dim ws As Excel.Worksheet Dim btn As BUTTON With ActiveWorkbook.ActiveSheet Set btn = ActiveSheet....

4 years ago
Forum
Reply
RE: Macro written in 32 bit System - Not working in 64 bit System[ Win 10 and Office 2019 Prof]

Thanks Miguel for changing the code to get path in column B but I was hoping more to get hyperlink in column B that I can click on it and get file ope...

4 years ago
Forum
Reply
RE: Macro written in 32 bit System - Not working in 64 bit System[ Win 10 and Office 2019 Prof]

is it possible to change the code and have full path as hyperlink in column B

4 years ago
Forum