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 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
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
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")
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
'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
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' ]
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 xlsxwriter as xw
wbTransaction = xw.Workbook('Transaction Table.xlsx')
wsTransaction = wbTransaction.add_worksheet('Transactions')
transactions = (
['Tran Date', 'Tran Type', 'Tran Amount'],
['5/1/2019', 'Buy', 100.00],
['5/2/2019', 'Sell', 200.00],
['5/3/2019', 'Buy', 300.00],