?
Solved

Microsoft Excel: REFERENCE

Posted on 2013-01-12
3
Medium Priority
?
205 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 2000 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 2000 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 2000 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

743 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