training courses in excel - can you pull data

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » training courses in excel - Can you pull data from Maconomy database using VBA | Excel forum

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

resolvedResolved · Low Priority · Version Standard

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

Can you pull data from Maconomy database using VBA

Can you pull data from Maconomy database using VBA

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

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.08 secs.