Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Opening A Specific Excel Sheet
Hello all,
Is there anyway to code in HTML to open a specific sheet in excel? Like is there some way that I can make a link for my webpage that when clicked, will go to let say, sheet 2? |
#2
|
|||
|
|||
SPatel,
If you save your workbook with sheet2 as the active (showing) sheet then it will always open with that sheet showing. If the HTML page can save the workbook then you need to put this code in This Workbook Alt + F11, Double click ThisWorkbook in the project pane and paste this in. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheets("sheet2").Select End Sub Henry wrote in message ups.com... Hello all, Is there anyway to code in HTML to open a specific sheet in excel? Like is there some way that I can make a link for my webpage that when clicked, will go to let say, sheet 2? |
#3
|
|||
|
|||
I don't speak HTML, but maybe:
<a href="file://c:/yourfolder/book1.xls#'sheet 1'!A1"click me</a wrote: Hello all, Is there anyway to code in HTML to open a specific sheet in excel? Like is there some way that I can make a link for my webpage that when clicked, will go to let say, sheet 2? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Excel won't copy outside sheet | Excel Discussion (Misc queries) | |||
opening multiple instances of excel | Excel Discussion (Misc queries) | |||
Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel | |||
Excel crashes when opening excel document by double-clicking icon | Excel Discussion (Misc queries) |