Using access VB to add columns in Excel

S

skelly

I am building a spreadsheet that is an order form for my client's customers..

Access 2007 stopped outputting columns with formulas so I need to be able to
add some formulas to an spreadsheet using an Access Module..

Can someone direct me to a tutorial on how to (using Access VB) open an
existing Excel worksheet to ..
1. create a column in excel that extends 2 columns (Quantity & Price)
2. At the bottom of that column put the order total..

Thanks in advance.

Frozen like a popsicle in Portland,
skelly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Automating Excel Spreadsheet 1
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Import data from Access to Excel containing VB code 3
Matching data in columns 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
How do I freeze columns in Access 2007 when scrolling 2

Top