PromptBase
Close icon
General
Home
Marketplace
Hire
Create
Login
Sell
Explore
🤖 GPT

Excel Macros Generator

Excel Macros Generator gpt prompt mini thumbnail
27Eye icon
Views
TestedTick icon
TipsTick icon
🖥️Struggling with generating macros code? ➡️Our mega-intelligent AI becomes your personal Macros Mentor, delivering tailor-made macros code based on your specific input fields! ➡️Just input your desired fields, and receive a complete macros code customized to your needs. ➡️Plus, detailed instructions on how to implement and use the code! ✅Say goodbye to coding hassles, and hello to effortless efficiency!
...more
$3.99
Get prompt
After purchasing, you will gain access to the prompt file which you can use with GPT or the app builder. You'll receive 20 free generation credits with this purchase. By purchasing this prompt, you agree to our terms of service.
Over 1 month ago

Prompt Details

Model
Chat - GPT-4 (gpt-4)
Token size
80 ($0.00240 / call)
Example input
[User]: Jane [Step 1]: Open Excel file "SalesData.xlsx" [Step 2]: Filter column "Region" for "North" [Step 3]: Copy all rows in "Sales" column [Step 4]: Paste copied data into new Excel file "NorthSales.xlsx" [Step 5]: Save and close "NorthSales.xlsx" [Step 6]: Email "NorthSales.xlsx" to manager@company.com [Analysis 1]: Code execution time [Analysis 2]: Memory efficiency
Example output
Creating a macros code tailored for Jane's needs involves writing VBA (Visual Basic for Applications) code in Excel. Below is the code along with comprehensive instructions on how to use it. Please note that this code assumes the structure of your Excel file and may need to be adjusted based on your actual data. ### VBA Macros Code: ```vba Sub GenerateNorthSalesReport() ' Step 1: Open Excel file "SalesData.xlsx" Workbooks.Open "C:\Path\To\SalesData.xlsx" ' Step 2: Filter column "Region" for "North" With ActiveSheet .AutoFilterMode = False ' Remove any existing filters .Range("A1").AutoFilter Field:=1, Criteria1:="North" End With ' Step 3: Copy all rows in "Sales" column Columns("B:B").Select Selection.Copy ' Step 4: Create a new Excel file "NorthSales.xlsx" Workbooks.Add ActiveSheet.Paste ' Step 5: Save and close "NorthSales.xlsx" Application.DisplayAlerts = False ' Disable save prompt ActiveWorkbook.SaveAs "C:\Path\To\NorthSales.xlsx", FileFormat:=51 ' FileFormat 51 is for xlsx format Application.DisplayAlerts = True ' Enable save prompt ActiveWorkbook.Close SaveChanges:=False ' Step 6: Email "NorthSales.xlsx" to manager@company.com Dim OutlookApp As Object Set OutlookApp = CreateObject("Outlook.Application") Dim OutlookMail As Object Set OutlookMail = OutlookApp.CreateItem(0) With OutlookMail .To = "manager@company.com" .Subject = "North Sales Report" .Body = "Attached is the North Sales Report." .Attachments.Add "C:\Path\To\NorthSales.xlsx" .Send End With ' Cleanup Set OutlookMail = Nothing Set OutlookApp = Nothing ' Optional: Close "SalesData.xlsx" Workbooks("SalesData.xlsx").Close SaveChanges:=False End Sub ``` ### Instructions for Use: 1. Open Excel. 2. Press `Alt + F11` to open the VBA editor. 3. Insert a new module by right-clicking on any item in the project explorer on the left, then choose `Insert` -> `Module`. 4. Copy and paste the provided code into the module. 5. Close the VBA editor. 6. Press `Alt + F8`, select "GenerateNorthSalesReport," and click "Run." ### Code Execution Time and Memory Efficiency: #### Code Execution Time: Execution time depends on various factors such as the size of your data. This code sequentially performs operations, so its execution time will be influenced by the volume of data in the "SalesData.xlsx" file. You can measure execution time using the `Timer` function in VBA. Example: ```vba Dim StartTime As Double Dim SecondsElapsed As Double StartTime = Timer ' Your code here SecondsElapsed = Round(Timer - StartTime, 2) MsgBox "Execution time: " & SecondsElapsed & " seconds", vbInformation ``` #### Memory Efficiency: The provided code is relatively efficient in terms of memory usage. It loads the necessary data into memory, performs operations, and releases resources promptly. However, memory efficiency also depends on the size of your data. For very large datasets, additional optimizations may be considered, such as processing data in chunks. Remember to always save your work before running any macros and consider testing the code on a backup or sample data first.
Browse Marketplace