Solved

Microsoft Excel: REFERENCE

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

777 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