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

[suznal]

Do you want to open a new sheet within your active workbook? Or do you want to open a new workbook?

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

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.

[suznal]

If in a new workbook use this code...


Sub NewSheet()
Application.Workbooks.Add
End Sub