Solved

Microsoft Excel: REFERENCE

Posted on 2013-01-12
3
188 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
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Outlook Free & Paid Tools
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

839 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