excel does not opens on IIS

[Alex]

I have a simple c# application

Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;
string workbookPath = "/book.xls";
excelApp.Application.Workbooks.Open(workbookPath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);


excelApp.Cells[1, 1] = TextBox1.Text;

When I run it from VS development Server it open Excel file Ok, but when I
put it in virtual directory it runs excel.exe process and shows nothing, no
errors

what can it be?
thanks

 

[Joel]

I think your problem is the filename "/book.xls". The forward slash will go
to the root directory and look for book.xls. Your file is not on the root
directory and needs a longer path name.

 

[ryguy7272]

Perhaps something such as this:
Dim Path as String
Path = ActiveWorkbook.path
Set eastBook = Workbooks.Open(path & "\" & "East.xls")
'etc., etc., etc., etc., etc.,

Regards,
Ryan---
--
RyGuy

I think your problem is the filename "/book.xls". The forward slash will go
to the root directory and look for book.xls. Your file is not on the root
directory and needs a longer path name.

I have a simple c# application

Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;
string workbookPath = "/book.xls";
excelApp.Application.Workbooks.Open(workbookPath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);


excelApp.Cells[1, 1] = TextBox1.Text;

When I run it from VS development Server it open Excel file Ok, but when I
put it in virtual directory it runs excel.exe process and shows nothing, no
errors

what can it be?
thanks

 

[Alex]

it is thw same if I do this


Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;
excelApp.Application.Workbooks.Add(true);
excelApp.Cells[1, 1] = TextBox1.Text;

I think your problem is the filename "/book.xls". The forward slash will go
to the root directory and look for book.xls. Your file is not on the root
directory and needs a longer path name.

I have a simple c# application

Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;
string workbookPath = "/book.xls";
excelApp.Application.Workbooks.Open(workbookPath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);


excelApp.Cells[1, 1] = TextBox1.Text;

When I run it from VS development Server it open Excel file Ok, but when I
put it in virtual directory it runs excel.exe process and shows nothing, no
errors

what can it be?
thanks