Visual Basic的应用程式 Jobs

My main Excel workbook refuses to load correctly. The moment I try to open it, Excel throws the warning: “Excel cannot open the file because the file format or file extension is not valid.” If I continue, the file does open, yet every sheet is visibly corrupted—numbers, formulas and formatting are all unreadable. The goal is simple: restore this file so it opens in modern Microsoft 365 without errors and displays its original data, formulas, charts and pivots intact. You may rely on any recovery approach—built-in repair, VBA, third-party tools, hex or binary editing, even temporary conversion through LibreOffice—as long as the outcome meets the criteria below. Acceptance criteria • A clean .xlsx that opens with zero error prompts • Origina...

I need an Excel workbook that lets my team enter sales figures through a user-friendly form and, with one click, posts each record into a master sheet. The whole point is to make data collection painless and consistent so I can move straight into analysing sales performance later. Data validation is non-negotiable. The form must stop typos and out-of-range numbers, force date entries to the current financial year, and offer drop-downs for product SKUs and sales reps. Whether you prefer VBA, Office Scripts, or Power Automate is up to you—as long as the solution runs inside Microsoft 365 on both desktop and (ideally) the web. Deliverables • Excel workbook with built-in form and automated submission • All validation rules implemented and tested against sample sales data ...

The goal is to turn raw accounting exports into a clear Management Information System inside Microsoft Excel. The workbook must display financial data only, with live views on Revenue & Expenses, Profit Margins, and Cash Flow. I will supply the source files (CSV and XLSX). Your job is to design the data model, automate the refresh, and present the numbers through clean charts, pivot tables, slicers, and conditional formatting so that anyone on the team can spot trends in seconds. Power Query or VBA is welcome if they simplify the workflow, but the final file has to stay fully portable in standard desktop Excel. Deliverables • One .xlsx file containing the dashboard and underlying data model • Simple “Data Refresh” button or documented refresh steps &bull...

I need a single, well-organised system that keeps every reinsurance policy I handle in one place, tells me instantly which market fits each risk, reminds me before anything falls due, and produces clear reports for management. Core workflow • Policy tracking: an easy data-entry form (policy number, cedant, premium, sum insured, occupancies, dates, notes) that saves into a searchable table. • Market insights: the moment I fill in premium, sum insured or occupancies, the tool should suggest the appropriate market automatically. • Reminder emails: automatic Outlook-ready messages for renewals, premium receipts or any custom date I define, with editable templates pulled straight from the record. • Reports: quick buttons to create production, renewal pipeline and ou...

Right now, colleagues type a mix of numbers and text straight into our Excel template every time we receive a new submission. I want that manual step gone. The goal is a simple, bullet-proof automation—ideally a VBA macro, Power Automate flow, or an add-in—that takes incoming mixed data and drops each field into the correct cell or table row without human involvement. It must preserve all existing formulas and formatting in the workbook and work on current Microsoft 365 versions. Deliverables • A working automated solution (VBA file, flow, or equivalent) • Clear setup notes so I can deploy it on other machines • A quick demo file or screen-record showing it in action I’ll test by running the tool on sample data and confirming every value lands ...