How to invoke a spreadsheet

S

subbu

Hi,
I have a requirement to open a excel spreadsheet when a
button is clicked.Any pointer to this is highly appreciated

subbu
 
T

Tim Ferguson

I have a requirement to open a excel spreadsheet when a
button is clicked.Any pointer to this is highly appreciated
Click to expand...

varMyVal = Shell("d:\mysheets\myspreadsheet.xls")

The long way round is to create an Excel object, get it to open the
workbook etc etc.


Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Need Help with Macro Security 1
You'll need a new app to open this about link 1
Integrating information from Word to Excel (not mail merge) 1
Protecting Word 2019 document 0
Mail Merge Directory Conditional Page Break 0
Using Office Forms and dynamically updating the excel backend 0
Linking data in MS Word into Excel 5

Top