Python Automation and VBA Tutorials Helping you save plenty of time by automating your work with simple scripts Python Automation How to create and initialize a list of strings in Java? How to check if a Python variable object is a number? 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 fix the TypeError: string argument without an encoding error 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? Solve the attributeerror ‘str’ object has no attribute ‘read’ Solve the attributeerror: numpy.ndarray object has no attribute append error How to convert a date to a string in Python and Pandas? How to get the month and quarter value from datetimes in Python? How to convert an hex number to binary in Python? Fix the Modulenotfounderror no module named selenium 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 lower case a string and a list in Python? How to split a string into a list array in Python? How to write a text file into a numpy array or list? How to write a Python string to a file? 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? Solve the attributeerror str object has no attribute decode error How to fix the attributeerror ‘str’ object has no attribute ‘contains’? How to create a file if not exists with Python? How to write Python lists to files with newlines? How to read a text file into a list of words in Python? How to read a long string line by line in Python? Create a pandas DataFrame from a json file How to overwrite a text file in Python? Solve AttributeError list object has no attribute replace in Python Solve typeerror not supported between instances of str and int (>, <, <=) Fix typeerror: list indices must be integers or slices, not str How to fix modulenotfounderror: no module named cv2 in Python? How to create a list from a string in Python? How to write a dictionary or list to a binary pickle file with Python? How to split a Python list of strings based on condition? How to write a Python dictionary into a json file? Get time difference in seconds and minutes with Python How to convert floats to strings with Python and Pandas? How to drop the last rows in Pandas DataFrames? How to convert strings to datetime objects in Python? How to read files into a string in Python 3? How to solve the no module named error in Python? How to sum days and time to a date in Python? Fix the type error: ‘str’ cannot be interpreted as integer in Python Fix the typerror can’t multiply sequence by float in Python How to subtract dates and times in Python? Write to a CSV file row by row with Python How to round up Pandas column values? Read files in Python line by line into a list How to append text to one or multiple files in Python 3? Solve attributeerror: ‘list’ object has no attribute ‘split’ in Python How to total DataFrame columns and rows in Pandas? How to solve the No module named boto3 error in Python? How to convert a datetime Pandas column to day of week? Fix modulenotfound error no module named bs4 in Python How to add Python to the PATH in Windows? Python: How to replace one or multiple characters in a string? Fix the module not found import error for urllib2 and urllib3 How to save a Python Numpy array to a text file? How to write Python lists to txt and csv files? How to split a string into two halves in Python? How to remove newlines from a string in Python 3? How to write lists and dictionaries into a CSV file with Python 3? How to open and read an excel file with Python? How to write text files in Python 3? How to convert a Python string to Hex format? How to find unique occurrences in a Python list? How to round a number or float list in Python? Convert a list of strings to float numbers in Python? VBA scripts How to check for duplicates in Excel Workbooks using VBA? How to save Excel file with specific name and current date with VBA? How to set Excel text font color with VBA? How to check if a file or folder exists in your computer with Excel 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 subset a dataframe by one or multiple columns? How to create and insert shapes in PowerPoint with 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? How to copy add slides into your PowerPoint presentation with VBA Macros?
