PC Review


Reply
Thread Tools Rate Thread

Adding a command button to open another spreadsheet

 
 
=?Utf-8?B?Sm9lbA==?=
Guest
Posts: n/a
 
      17th Oct 2007
Hi

CAn anyone tell me the VBA for opening another spreadsheet if I place a
command button on my Spreadsheet so I can create an index page

Thanks Joel
--
N/A
 
Reply With Quote
 
 
 
 
New Member
suznal's Avatar
Join Date: Oct 2007
Posts: 6
 
      17th Oct 2007
Do you want to open a new sheet within your active workbook? Or do you want to open a new workbook?
 
Reply With Quote
 
JW
Guest
Posts: n/a
 
      17th Oct 2007
Sub likeThis()
Workbooks.Open "C:\Book18.xls"
End Sub

Or, you can simply create hyperlinks to your workbooks instead of a
button for each one.

Joel wrote:
> Hi
>
> CAn anyone tell me the VBA for opening another spreadsheet if I place a
> command button on my Spreadsheet so I can create an index page
>
> Thanks Joel
> --
> N/A


 
Reply With Quote
 
ryan.fitzpatrick3@safeway.com
Guest
Posts: n/a
 
      17th Oct 2007
On Oct 17, 9:00 am, Joel <J...@discussions.microsoft.com> wrote:
> Hi
>
> CAn anyone tell me the VBA for opening another spreadsheet if I place a
> command button on my Spreadsheet so I can create an index page
>
> Thanks Joel
> --
> N/A


Joel,

I recorded this macro.

Sub Add_Sheet()
Sheets.Add
End Sub

This is create a blank worksheet in a workbook. If you're looking for
another excel workbook then I don't know.


 
Reply With Quote
 
New Member
suznal's Avatar
Join Date: Oct 2007
Posts: 6
 
      17th Oct 2007
If in a new workbook use this code...


Sub NewSheet()
Application.Workbooks.Add
End Sub

 
The phonebooks are here!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command Button to open a password protected excel spreadsheet james Microsoft Access Forms 0 22nd Feb 2010 11:04 AM
Command Button to open a password protected excel spreadsheet james Microsoft Access Form Coding 0 22nd Feb 2010 11:03 AM
Send Open Spreadsheet using Command button sbloem@steelcase.com Microsoft Excel Misc 0 23rd Aug 2007 01:08 PM
Open spreadsheet with command button in form =?Utf-8?B?TmluaWVs?= Microsoft Access 1 18th Aug 2006 09:14 PM
Command button on form to open excell spreadsheet Microsoft Access Forms 1 12th Aug 2004 07:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:32 AM.