training courses in excel - Can you pull data from Maconomy database using VBA | Excel forum

Resolved · Low Priority · Version Standard

Mon 28 Jan 2008, 11:19 Delegate Simon said...

Simon has attended:
Excel VBA Intro Intermediate course
PowerPoint Intermediate Advanced course

Can you pull data from Maconomy database using VBA

Sat 9 Feb 2008, 11:20 Trainer Stephen said...

RE: Can you pull data from Maconomy database using VBA

Hi Simon

Thank you for your question

This is hard to answer as we don't support Maconomy.

However if the database is an SQL datbase then the answer is very probably yes. You would need to use SQL code embedded in your VB code, and you would need to understand the structure of the database.

I imagine the manufaturers could give you a clearer picture of this

Hope this helps

Regards

Stephen

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips