Unnecessarily opening of excel file vb.net
-
Hi, In my code, after execution of the following code.
dim d as new Excel.Application
create an excel instance. and opening an excel file by using the following code.
d.Workbooks.Open(ExsTemplate & "sheet.xls")
Now i try to open an excel file by double clicking it, which is lying in my hard drive. this open sheet.xls file also , in the taskbar. Can you tell me why sheet.xls should open? Thanks
-
Hi, In my code, after execution of the following code.
dim d as new Excel.Application
create an excel instance. and opening an excel file by using the following code.
d.Workbooks.Open(ExsTemplate & "sheet.xls")
Now i try to open an excel file by double clicking it, which is lying in my hard drive. this open sheet.xls file also , in the taskbar. Can you tell me why sheet.xls should open? Thanks
hi, you need to close the excel book in your program. workbooks.close thanks
-
hi, you need to close the excel book in your program. workbooks.close thanks
i HAVE 35-40 LINES OF CODE, before i closes the workbook. and meanwhile user tries to open an excel file, which results in opening the file (Sheet.xls). Any idea?
-
hi, you need to close the excel book in your program. workbooks.close thanks
do u have any idea for the below link http://www.codeproject.com/Messages/3071168/files-names-under-a-process-vb-net-2008.aspx[^]
-
do u have any idea for the below link http://www.codeproject.com/Messages/3071168/files-names-under-a-process-vb-net-2008.aspx[^]
no idea! :^)
-
i HAVE 35-40 LINES OF CODE, before i closes the workbook. and meanwhile user tries to open an excel file, which results in opening the file (Sheet.xls). Any idea?
Yep, when you use Excel in your application, this is the rick you take. A use can launch external .xls files by double clicking on them and they will show up in the Excel that you launched in your code. You can't prevent it. So what's the question?
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
Yep, when you use Excel in your application, this is the rick you take. A use can launch external .xls files by double clicking on them and they will show up in the Excel that you launched in your code. You can't prevent it. So what's the question?
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008Should the file get opened in compatibility mode? Which ever file is opening , the compatibility mode text get appending with the file name, until the instance is killed.
-
Should the file get opened in compatibility mode? Which ever file is opening , the compatibility mode text get appending with the file name, until the instance is killed.
That depends on the file. I have no idea what you're users are opening, so yes, it's possible.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
do u have any idea for the below link http://www.codeproject.com/Messages/3071168/files-names-under-a-process-vb-net-2008.aspx[^]
Set
IgnoreRemoteRequetsto True to force excel to open a new instance of excel.exe for each workbook, this may cause undesired behavior and may cause links to not work. Save your sheet when you setignoreremoterequeststo true. This will prevent all worksheets opened programtically when a user opens a workbook from his desktop.