fx Automation

Practical VBA Projects

45 मिनट3 पाठ9 प्रश्न

पाठ

1. Sheet splitter — split one sheet into separate files by column value15 min 2. Bulk PDF export loop15 min 3. Automated email with attachment from Outlook15 min

अभ्यास फ़ाइल

⬇ डाउनलोड करें automation-practice.zip

Automation practice bundle

One ZIP serves all seven modules. It contains a generated, macro-free automation-practice.xlsx, bilingual solutions, three intentionally messy CSVs, Python report/email/pipeline scripts, requirements, a Windows launcher, a sample GitHub Actions workflow, and a README. No credentials or executable VBA are embedded.

The workbook contains Read Me, ROI, Data, Output, Sales, Products, Customers, Invoices, Statement, Orders, Rates, and Log. Data has 30 stock rows (15 reorder, 3 out of stock, total shortfall 45). Sales has 30 rows: North/South 8 each and East/West 7 each; three salespeople have 10 rows each. Five customer balances are 1200, 0, 800, 0, 500. Statement is an exercise template, not a completed statement.

The separate CSV project has 10 input rows: 7 valid unique, 2 rejected and 1 duplicate. Regional totals: South 96000, North 92000, West 61000; overall 249000. Rejected rows preserve original field values, including the literal NA amount.

Extract the ZIP and follow README.md to install the Python requirements and run the examples. Start with python pipeline.py --no-email using copies of the sample data. Desktop VBA, Outlook and xlwings exercises require the applications listed in their respective lessons. The bundle includes no credentials or enabled schedules.

मॉड्यूल प्रश्नोत्तरी (9)

1. What copies only the filtered rows?

SpecialCells(xlCellTypeVisible)

2. Why use a dated output folder?

So older files are never overwritten

3. Which line saves the new file as a normal .xlsx?

SaveAs with FileFormat:=xlOpenXMLWorkbook

4. Which method creates the PDF?

ExportAsFixedFormat with Type:=xlTypePDF

5. What controls what part of the sheet goes into the PDF?

Page Layout settings — print area, orientation, scaling

6. Why call Application.Calculate in the loop?

So the template updates for each customer

7. Which Outlook versions support this macro?

Classic Outlook desktop on Windows

8. How do you keep your signature?

Call .Display first, then add your text before .HTMLBody

9. Why keep a Status column?

As a log and to avoid sending twice