Solved

Microsoft Excel: REFERENCE

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

Suggested Solutions

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

948 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now