Skip to content

Instantly share code, notes, and snippets.

View DataSolveProblems's full-sized avatar
💭
Github Working In Progress

Jie Jenn DataSolveProblems

💭
Github Working In Progress
View GitHub Profile
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()
import sys
from pprint import pprint as pp
from PyQt5.QtWidgets import QWidget, QGridLayout, QPushButton, QSizePolicy, QApplication
class GridDemo(QWidget):
def __init__(self):
super().__init__()
values = [ '1', '2', '3',
'4', '5', '6',
'7', '8', '9' ]
'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
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
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")
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
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
import qrcode
qr = qrcode.QRCode(
version=1,
box_size=15,
border=5
)
data = 'your text here'
qr.add_data(data)
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