Solved

Microsoft Excel: REFERENCE

Posted on 2013-01-12
3
195 Views
Last Modified: 2013-01-14
Hi,

This is related to Microsoft Excel. Somebody (by your own wordings) would you please tell me a little bit of  the REFERENCE and how to use it“  (some examples or tutorial will be great).

Thank you

tjie
0
Comment
Question by:tjie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
3 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 38771145
References are libraries of functions, subs, constants etc that are not by default included in your vba environment.

You can add them from the vba editor

Tools--> references

As an example, in Access's vba editor, you do not by default have Excel vba functions available for use in your code.

If you check the Excel reference, excel functions, constants etc are then available.
0
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 500 total points
ID: 38771149
By the way, you are specifically mentioning Excel,  but you have Access included in your question topics.   You might want to describe your setup an goals a little to help people tailor their responses to your needs.
0
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 500 total points
ID: 38771165
A little more...  those object libraries (references)  basically allow you to automate various  things from the environment you are working in... for example an Excel reference in an Access database lets you progrmatically open Excel and do just about anything that you can do directly in Excel. ... which is far mor powerful than default available functions such as TransferSpreadsheet.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Hash on Excel 13 44
MS Access Combobox to Disable Controls on a Separate Form 10 26
Macro problems with Excel file 6 27
SQL Query logic question 14 30
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question