Hi all, I am trying to take an excel file and protect the worksheets.  Does anyone know of a good video to watch for this or a good starting point.  I am trying to use the following but getting an active x error on the oExWb = CreateObject("Excel.Workbook").  Not even sure if I am on the right road with this though.

Thanks,

Randy

ok, got it all to work on my local, but does not work on server...???  Works perfectly on my machine, on server it dies out somewhere that it starts in with the Excel.  I can tell this because it does the copying of files and everything up to that point.  Any ideas from anyone??  Here is code that worked.

Dim iWsCount As Integer
iWsCount = oExWb.Worksheets.Count
For Each oExWs In oExWb.Worksheets
oExWs.Protect("Safety732")
Next

The server has Office XP installed and I am using Office 2003 and Office 2007.  Do I need to update the Office version??  I copied the DLL files to it that were added to my Bin directory when I added the Office 11 Excel Library....  But it is still needing something...   Do I have to have Office 2003 to use with Interop

Well, since the server had Office XP, I installed XP on my system and added the reference to "Microsoft Excel 10.0 Object Library" and am still having the same problem.  I hate for this to be such a show stopper, since it is working....  Just not on the server, which of course is the whole point....  I deleted the reference to 11 in my web.config, but noticed that there was no reference to "Microsoft Excel 10.0 Object Library" in there???  But there was a DLL in the Bin, so I gather that is what it is using??  Or does there need to be a reference in the web.config for it??  It still works just fine on my local system, so not sure that is even an isuue.

Thanks
Randy

A little bit of new information, I have the error now...  Hopefully this will help someone...

System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for
component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005.
at _CopyBranchDriversMatrixUpload5826klo.Button1_Click(Object sender, EventArgs e) in
E:\Inetpub\wwwroot\website\Copy of BranchDriversMatrixUpload5826klo.aspx.vb:line 58

This is line 58:

Dim oExApp As New Excel.Application

Thanks
Randy

Am I asking this in a confusing manner or does just no one else have any idea on this either??  Just want to make sure the problem is understood.  I have seen other people on the web having similar problems, but no answers...  Here is the revised code, but I don't think the code is the problem, since it runs fine on my local system and just not on the server, error is in above post:

' =================== Protect Worksheets
Dim oExApp As New Excel.Application
Dim oExWb As Excel.Workbook
Dim oExWs As Excel.Worksheet
oExWb = oExApp.Workbooks.Open(path & BranchName)
Dim iWsCount As Integer

iWsCount = oExWb.Worksheets.Count
For Each oExWs In oExWb.Worksheets
oExWs.Protect("Safety732")
Next
oExWb.Save()
oExWb.Close()
oExWs = Nothing
oExWb = Nothing
oExApp = Nothing
command.Connection.Close()
Label1.Text = "File uploaded!"
Catch ex As Exception
Label1.Text = ex.ToString

I have fixed the problem.  I had to add ALL USERS to the Excel Application and that got it working.