This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub List_Hyperlinks() | |
Dim ws As Worksheet, wsOutput As Worksheet | |
Dim hlink As Hyperlink | |
Dim row_insert As Long | |
row_insert = 2 | |
Set wsOutput = ThisWorkbook.Worksheets.Add | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import xlsxwriter as xw | |
workbook = xw.Workbook('MyWorkbook.xlsx') | |
worksheet = workbook.add_worksheet() | |
worksheet.write('A1', 'Hello World') | |
worksheet.write(0, 1, 'Goodbye') | |
workbook.close() |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'CDO Documentation https://docs.microsoft.com/en-us/previous-versions/office/developer/exchange-server-2003/ms877946(v%3dexchg.65) | |
Sub Send_Email_With_Gmail() | |
Dim newMail As CDO.Message | |
Dim mailConfiguration As CDO.Configuration | |
Dim fields As Variant | |
Dim msConfigURL As String | |
On Error GoTo errHandle | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Option Explicit | |
Dim wsMerge As Worksheet | |
Dim RowInsert As Long | |
Sub Merge_Files() | |
Const FolderPath As String = "" | |
Dim Files As String | |
Dim wbTemp As Workbook |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub Retrieve_SubFolder_Emails() | |
Dim ns As NameSpace | |
Dim olInboxFolder As MAPIFolder, olSubFolder As MAPIFolder | |
Dim msg As MailItem | |
Set ns = GetNamespace("MAPI") | |
Set olInboxFolder = ns.GetDefaultFolder(olFolderInbox) | |
Set olSubFolder = olInboxFolder.Folders("Sub Folder") | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub Delete_Strikethrough_Rows() | |
Dim ws As Worksheet | |
Dim LastRow As Long, RowNumber As Long | |
Application.FindFormat.Font.Strikethrough = True | |
Set ws = ThisWorkbook.ActiveSheet | |
With ws |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Option Explicit | |
Private Const Password As String = "xyz" | |
Sub Protect_Data_Sheets() | |
Dim ws As Worksheet | |
For Each ws In ThisWorkbook.Worksheets | |
If UCase(ws.Name) <> "SUMMARY" Then |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import qrcode | |
qr = qrcode.QRCode( | |
version=1, | |
box_size=15, | |
border=5 | |
) | |
data = 'your text here' | |
qr.add_data(data) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Option Explicit | |
Private Const Password As String = "xyz" | |
Sub Protect_Data_Sheets() | |
Dim ws As Worksheet | |
For Each ws In ThisWorkbook.Worksheets | |
If UCase(ws.Name) <> "SUMMARY" Then |