Python Automation and VBA Tutorials Helping you save plenty of time by automating your work with simple scripts Python Automation How to read and write files in a directory with pathlib? How to add a string to a path in Python using pathlib? How to fix the Import openai Could Not Be Resolved exception in Visual Studio Code? How to Resolve the nameerror ‘openai’ is not defined in Python IDEs? How to fix the modulenotfounderror no module named langchain in VSCode, and Jupyter? Fix the modulenotfounderror no module named openai exception How to join a path and filename with pathlib? How to solve the Nameerror name path is not defined error? How to fix typeerror can only concatenate str (not “bytes”) to str in Python? How to solve the attribute error: ‘list’ object has no attribute ‘find’? How to solve the attributeerror ‘str’ object has no attribute ‘remove’? Fix the typeerror ‘method’ object is not subscriptable in Python and Pandas? How to get the month and quarter value from datetimes in Python? How to print line numbers of a file in Python? How to convert a string to a path object in Python? How to get yesterday’s datetime in Python and Pandas? How to add months to a date time object in Python? How to fix the typeerror ‘type’ object is not subscriptable error in Python? How to convert Python list elements to integers? Solve attributeerror ‘list’ object has no attribute encode in Python How to find the index of one or multiple element occurrences in a Python list? How to extract and get a file name from a path in Python? How to fix the attributeerror ‘str’ object has no attribute ‘contains’? How to read a text file into a list of words in Python? How to read a long string line by line in Python? Solve AttributeError list object has no attribute replace in Python How to fix modulenotfounderror: no module named cv2 in Python? How to sum days and time to a date in Python? Fix the typerror can’t multiply sequence by float in Python Write to a CSV file row by row with Python How to total DataFrame columns and rows in Pandas? How to solve the No module named boto3 error in Python? Fix modulenotfound error no module named bs4 in Python Fix the module not found import error for urllib2 and urllib3 How to write Python lists to txt and csv files? How to remove newlines from a string in Python 3? How to write text files in Python 3? How to convert a Python string to Hex format? VBA scripts How to Send Emails from Excel using VBA macros? Create shapes and change their color, shape with PowerPoint VBA How to Use Variables in VBA MsgBox and InputBox for Excel and Word? How to Save Excel sheets as PDF with Current Date Using VBA? How to save Excel file with specific name and current date with VBA? How to check if a cell or a range of multiple cells is empty with Excel VBA? How to set an Excel cell color according to a condition with VBA? How to set an Excel spreadsheet column width with VBA? How to make a Macro in Microsoft Visio? How to work with Message and Input Boxes in PowerPoint VBA? How to create and add slides to PowerPoint presentations with VBA? How to display the developer tab in Excel, Outlook and Word 2019 / 365? PowerPoint Macros: How to run VBA in your PowerPoint 2016 and 2019 slides?