This action will open a new file explorer window with its default page.
#How to open excel file in new window windows
The 2007, 20 versions of the program use the XLSX format by default to save. To open multiple file explorer windows using the mouse, simply hold down the Shift key on your keyboard and click on the File Explorer icon appearing on the taskbar. Before running this program you have to create an excel file name test1.xlsx and add some data in the cell B2. XLS files are Excel workbook files created in Excel 97 or Excel 2003. When you execute this program, the program open the file c:\test1.xlsx and edit the content in the cell B2, it replace the old content to "". Remember that visitors can open a new tab themselves and are irritated when a link opens in a new tab or window without their consent. In this way, you prevent your visitors from returning to your website. Opening external links in a new tab or window will make people leave your website. In the code, Imports Excel = - we assign the excel reference to a vatriable Excel. But it is possible to open hyperlinks in a separate window.
To do so, click on the XLSX file, keep the mouse button held down, drag the file onto the open Excel spreadsheet and then release the button.
If Excel is already open, you can use your mouse to drag the XLSX file onto the open spreadsheet. Imports Excel = Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, _ěyVal e As System.EventArgs) Handles Button1.Click Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook Dim xlWorkSheet As Excel.Worksheet xlApp = New Excel.ApplicationClass xlWorkBook = ("c:\test1.xlsx") xlWorkSheet = xlWorkBook.Worksheets("sheet1") 'display the cells value B2 MsgBox(xlWorkSheet.Cells(2, 2).value) 'edit the cell with new value xlWorkSheet.Cells(2, 2) = "" xlWorkBook.Close() xlApp.Quit() releaseObject(xlApp) releaseObject(xlWorkBook) releaseObject(xlWorkSheet) End Sub Private Sub releaseObject(ByVal obj As Object) Try .ReleaseComObject(obj) obj = Nothing Catch ex As Exception obj = Nothing Finally GC.Collect() End Try End SubEnd Class Step 2: Drag and drop the XLSX file onto an Excel window to open it.
0 kommentar(er)
