Introduction:
While developing my simple application I used functions to open Microsoft Excel to import some data to the database. Recently I moved the website to IIS on a separate PC and... of course turned out that Excel starts on the server instead of client PC. How can I change that?
Source code:
Protected Sub btnImport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnImport.Click
System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US")
Dim fs = CreateObject("Scripting.FileSystemObject")
Dim myDB As New DataClassesDataContext()
Dim xlApp As Microsoft.Office.Interop.Excel.Application
D ...
Go to the complete details ...