Call of excel through C#

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Framework
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Deployement I want use Microsoft Office Document Imaging control in the VB.NET application . I added this control to Visual Studion.NET tollbox and used it in my program. This program work coorect in my comuter, but it don't work in other computer, because first must install activex control for this component. Name of dll file for this component is "MDIVWCTL.DLL" and exist in this address: "C:\Program Files\Common Files\Microsoft Shared\MODI\11.0" My problem are: 1) VS.NET Deployement tools can not detect this component automatically when it make setup package, and in result this control don't install in target machine. 2) I can not register this control manually with "regsvr32" command line because I don't know dll file dependencies. Tag: Call of excel through C# Tag: 65105
  - 2
    - quoted-printable Hello, I need to decode an encoded string, it is encoded by using the method called "quoted-printable" and the string is in 7-bit form for transmission by SMTP. Does .NET Framework provide a way to do that? Thanks in advance. Lorenzo Tag: Call of excel through C# Tag: 65099
  - 3
    - VBCodeProvider leaks memory on compile? I've been experimenting with the VBCodeProvider and it appears that it leaks a small amount of memory every time I call CompileAssemblyFromSource(). It seems to leak about as much memory as the resulting size of the compiled DLL on disk. Is it supposed to do this? Any workarounds? I suppose I could do the compile in a separate AppDomain which would then get unloaded? (of course I'd have to use an interface to the code in the AppDomain so I don't lock it into the main domain). Tag: Call of excel through C# Tag: 65097
  - 4
    - Reporting Services Hi, Pls let me know how to show a report designed using Report Designer of SQL Reporting Services from a .NET winform application. TIA -Gopi Tag: Call of excel through C# Tag: 65096
  - 5
    - <seealso cref= to Class Constructor fails I am trying to get a seealso link to the Class Constructor where a Field is set. This seems to be the last major problem to get a Warning free compulation, so it would be nice to get it solved. There are two Constructors in this class and I have tried the following : /// <seealso cref="Cards.Cards(Panel,string,int,int,int)"/> or /// <seealso cref="Cards.Cards()"/> or /// <seealso cref="Cards.Cards"/> all of which failed (Function could not be found - "'Cards.Cards', das nicht gefunden werden konnte"). Any help to get this solved would be nice. Mark Johnson, Berlin Germany mj10777@mj10777.de Tag: Call of excel through C# Tag: 65095
  - 6
    - NEED HELP WITH CERTAIN ASP PAGE NOT DISPLAYING Hello! I have a question about accessing an .asp page. The environment I work in, all county stores can access our intranet fine. However, there is one county that cannot. This county can login to the intranet fine, however, when they choose to search by description, like for instance typing in the item "boots" they press enter and even get to the asp page that shows the different "boot" item numbers. When they click on an item number it just sits there and doesn't do anything and eventually comes to a white page that says Action Canceled. They surf through the Internet fine and even download and upload pages not pertaining to our Intranet fine. The speed is what it should be when they surf through other websites. The thing about is, that all other counties that are hooked up to our systems get in fine. The one county that has problems, has four computers in a small LAN and all four are doing the same thing. I have ran virus checks, removed spyware, cleared cache, reset the web settings, changed security levels in IE, updated Windows, reinstalled IE6, and made sure that no popup blocker or firewall was blocking access to the certain asp page. The county store does have a router and I have, from a remote locale got into their router and even setup the DMZ in the router as the IP address of the computer and still no luck. PLEASE HELP!!!! Tag: Call of excel through C# Tag: 65094
  - 7
    - Downloading a file from a website Hi all, Can anyone tell me which .NET class I need (or provide a code sample) to download file from a website/url (Not FTP) and save it to my hard drive. Kind regards, Chris Tag: Call of excel through C# Tag: 65089
  - 8
    - SQL Server Desktop Installation I recently bought a copy of Visual C#.NET Deluxe Learning addition. I was under the impression that this comes with SQL Server Desktop Engine. I installed everything I should have (I think), but when I type the commands to grant access to SQL at the DOS prompt, it tells me that SQL Server doesn't exist. The actual error message reads as follows: [DBMSLCPN]SQL Server does not exist or access denied. [DBMSLCPN]ConnectionOpen (Connect()). The problem might be that I also bought a learning addtion of Visual Basic.NET, and it told me it was installing "different" components than those already installed. However, I have two DIFFERENT installations of the .NET framework now; one that allows for C# development and one that allows for VB development. I can't imagine that ALL components were overwritten. I suppose I could re-install C# and hope for the best. Does anyone out there have any experience with this? Thanks in advance for your help. Tag: Call of excel through C# Tag: 65088
  - 9
    - Monitor SQL activity through .net Anyone have any ideas of how you would build a .net component to monitor SQL Activity. Here is what I am trying to do: When an insert or update to a SQL table occurs, I want to populate another table (in a different database). I don't want to use a trigger. Thx, Troy Tag: Call of excel through C# Tag: 65084
  - 10
    - Can you redirect framework with config file to an assembly? Here's a catcher for all ya'll I have a 3rd party .Net assembly which is compiled against .Net framework 1.1 and is compatible with v1.0. However, there is not a way to specify to use 1.0, unless I recompile it against v1.0 I have only .Net framework 1.0 installed. I have an assembly that references the 3rd party .Net assembly. I know from MSDN and other postings that a config file can be used with only .exe and web apps to redirect/rebind which .Net framework to use. This gets propogated down to the referenced assemblies too. Is there a way to have my assembly (.dll) to do the exact same behaviour? Utilize the .net framework v1.0 and propogate that down to all the referenced assemblies? Including my 3rd party referenced assembly which compiled against 1.1. Upgrading to v1.1 Framework will not work becuase of the # of projects using the v1.0 framework. If I upgrade then they all have to upgrade, and then the servers have to be upgraded, test, and the list goes on and on. I heard of pilicy files in the GAC, but am not quite sure how signing my assembly and putting that into the GAC will propogate down to any of the referenced assemblies to use the v1.0 framework. Any ideas? Mike Tag: Call of excel through C# Tag: 65079
  - 11
    - Should not be required to release managed resources A while ago I noticed an issue with .NET that just stung me yet again today. I had an object that I wanted to be garbage collected but it registered itself for several events of external objects which entails giving those objects a delegate that contains a reference to the event consuming object. The solution I have seen in Microsoft samples is to unregistered for the events in the Dispose method. Unfortunately, this creates a situation where manual memory management for these objects is a requirement. Dispose must be called or they will never be garbage collected. Garbage collection is supposed to eliminate much of the need for memory management, but it is not perfect and this is one of the cases where it fails miserably and quite often. I came up with a half-solution. I call it the WeakDelegate and it works well, but in order for its potential to be truly realized it would need framework level adoption. The concept is that it is a special kind of delegate that maintains a weak reference instead of a strong one. Then you simply unregistered for the events in a Dispose method and call the Dispose method from the finalizer. Worst case is that the overhead of a finalizer is called. Maybe in future versions of .NET, delegates defined as: delegate returnType DelegateName(parameterList); will really define an abstract class derived from Delegate (or MulticastDelegate or whatever) as well as two dirivatives of DelegateName being WeakDelegateName and StrongDelegateName. Generics may help. I would love to hear feedback, expecially from a Microsoft rep, with regards to this idea. Also, I dug up a prototype from my archives from when I was first learning C#: using System; using System.Reflection; using System.Collections; namespace BDB { /// <summary>Delegate that will not prevent garbage collection</summary> /// <remarks>Static Members not supported: /// Use instance wrapper methods if this functionality is required. /// /// Invoke method called on collected objects or missing methods will fail silently.</remarks> public class WeakDelegate { /// <summary>Construct a WeakDelegate</summary> /// <param name="d">"Strong" Delegate to copy from</param> public WeakDelegate(Delegate d) { referance = new WeakReference(d.Target); methodName = d.Method.Name; } /// <summary>Construct a WeakDelegate</summary> /// <param name="o">Object to invoke method on</param> /// <param name="m">Method to invoke</param> public WeakDelegate(object obj, string methodName) { this.referance = new System.WeakReference(obj); this.methodName = methodName; } /// <summary>Call the method referanced by this WeakDelegate</summary> /// <param name="args">Arguments to pass called method</param> /// <returns>Results of method call</returns> public object Invoke(object[] args) { MethodInfo m = referance.Target.GetType().GetMethod(methodName, BindingFlags.Instance|BindingFlags.Public|BindingFlags.NonPublic); return (m==null? null : m.Invoke(referance.Target, args)); } /// <summary>Determins if the object to invoke the method on is alive</summary> public bool IsAlive { get { return referance.IsAlive; } } /// <summary>Compare WeakDelegates for equality</summary> /// <param name="obj">Compare this to "obj"</param> /// <returns>True if WeakDelegates are equivialent</returns> public override bool Equals(object obj) { if(obj == null || GetType() != obj.GetType()) return false; WeakDelegate d = (WeakDelegate)obj; return ((this.referance.Target == d.referance.Target) && (this.methodName == d.methodName)); } /// <summary>Get the hash code of this WeakReferance</summary> /// <returns>Hash code</returns> public override int GetHashCode() { return methodName.GetHashCode() + referance.Target.GetHashCode(); } private string methodName; private WeakReference referance; } /// <summary>Multicast Delegate which does not prevent garbage collection</summary> public class WeakMulticastDelegate { /// <summary>Call all methods referanced by this WeakMulticastDelegate. /// Also removes any delegates that point to dead objects</summary> /// <param name="args">Arguments to pass all invoked methods</param> public void InvokeAll(object[] args) { WeakDelegate current; for(int i = 0; i < delegates.Count; i++) { current = delegates[i] as WeakDelegate; if(current.IsAlive) current.Invoke(args); else { delegates.RemoveAt(i); i--; } } } /// <summary>Add a WeakDelegate to the invokation list</summary> /// <param name="d">WeakDelegate to add</param> public void AddDelegate(WeakDelegate d) { delegates.Add(d); } /// <summary>Remove a WeakDelegate from the invokation list</summary> /// <param name="d">WeakDelegate to remove</param> public void RemoveDelegate(WeakDelegate d) { delegates.Remove(d); } private ArrayList delegates = new ArrayList(); } } Tag: Call of excel through C# Tag: 65078
  - 12
    - .net & exchange server I am looking for recommendations for the best method to connect to exchange 2000 and read through a particular object's messages, for example to return all of the appointments in a public calendar. Thanks. Tag: Call of excel through C# Tag: 65076
  - 13
    - Get Dhcp Server List I am trying to get the list of DHCP servers directly from AD but I can not find anything on how to do it. Can anyone here point me in the right direction or provide an example please. Jason Tag: Call of excel through C# Tag: 65075
  - 14
    - FxCop on debug or release build? Does it matter whether I run FxCop on the Debug or the Release build? Thanks. Tag: Call of excel through C# Tag: 65072
  - 15
    - Accessing Data Hi Friends, Is there a way to access data from a website that displays its data from a database. For example if i visit http://www.barnesandnoble.com, and if i search for a book on VB.Net, then i would like to access the results of this search programatically. I am trying to access data which is stored in their database. Now i can access this data by reading the webpage which contains the search result. OR If "Barnes And Noble" has created a Web Service, which provides me the access to their database. OR If i have direct access to their database. Are these the only options available to me, to access this data. Is there any other way i can get access to this data? I will be very thankful if you could please provide me any insight on this. Any help/guidance will be greatly appreciated. Thanks and Regards, Mohan Tag: Call of excel through C# Tag: 65070
  - 16
    - DllNotFoundException Hi, I have created a ASP .net client talking to a .net web service. The web service in turn calls a C++ dll to get data from the host. The whole thing is working perfectly fine on my machine, but when I am deploying the components on a Window 2000 server, running the application is throwing this error: System.DllNotFoundException: Unable to load DLL (my.dll) I have tried putting the dll in the system and system32 folders, - also I tried using the whole path of the dll in DLL Import function. None of these worked. Could someone please help me? Thanks! DC Tag: Call of excel through C# Tag: 65069
  - 17
    - HttpWebRequest ReadToEnd and Timeout Problems... Heya, I've found while using HttpWebRequest that when the TCP and/or ActiveSync connection is interrupted (read: remove device from cradle or internet connection drops) the ReadToEnd operation hangs and the Timeout property on the HttpWebRequest does not appear to cause a timeout as one would expect. Do I need to create my own Timer to Abort the HttpWebRequest in case this occurs? Is there a better way to handle this? ~~K Tag: Call of excel through C# Tag: 65066
  - 18
    - I need to do physocal disk reads I want to do something like where: m_Device(_T(\\\\.\\PHYSICALDRIVE1) to read drive 1 I then want to read the physical device till the end and save it in a disk file. Does anyone have an example of doing this in c#. Below are the pertinate lines from c++. The framework does not appear to support physical access. DeviceHandle = CreateFile(m_Device, GENERIC_READ,FILE_SHARE_READ, NULL, OPEN_EXISTING, FILE_FLAG_NO_BUFFERING, NULL); then in a loop rc = ReadFile(DeviceHandle, buffer, sizeof(buffer), &BytesRead, NULL); __ Jim Tag: Call of excel through C# Tag: 65064
  - 19
    - Crystal Reports - with parms - .Export error Hey all, I am trying to try get a crytal report running properly. A "Hello World" report that does not add criteria to the record selection formula of the report (either in the development tool, or in the code) works fine. However, when I try to add any parameter through the record selection formula and/or the report parameters method, the report crashes. I have tried each of the methods: 1. Use the Record Selection Formula property: crReportDocument.DataDefinition.RecordSelectionFormula = "{qryTest.ID} = 54" 2. Use the Crystal Parameters collection(s) crParameterFieldDefinitions = crReportDocument.DataDefinition.ParameterFields crParameterFieldDefinition = crParameterFieldDefinitions.Item ("[@TestID]") crParameterValues = crParameterFieldDefinition.CurrentValues crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue() crParameterDiscreteValue.Value = 54 crParameterValues.Add(crParameterDiscreteValue) crParameterFieldDefinition.ApplyCurrentValues(crParameterValues) Both of the methods above work fine on my development machine but the testing server gives these errors. I also set the record selection formula in the report to automatically set the TestID parameter = 54 and then tested that report on the testing server and everything worked. So the issue seems to be with populating the crystal report's parameters at runtime. The error that comes back with a logon failure at the .Export line. I have tried two methods to logon to the reports: #################### Basic: With tliTableLogonInfo.ConnectionInfo .ServerName = m_strDSNName .DatabaseName = m_strDatabase .UserID = m_strUserId .Password = m_strPassword End With 'setup each connection in the report For Each tTable In crReportDocument.Database.Tables tTable.ApplyLogOnInfo(tliTableLogonInfo) Next tTable #################### and Complex (loops through sub-reports): Dim mySection As Section Dim mySections As Sections Dim myReportObject As ReportObject Dim myReportObjects As ReportObjects Dim mySubReportObject As SubreportObject Dim mySubRepDoc As New ReportDocument() 'Declare all of the sections of the main report mySections = crReportDocument.ReportDefinition.Sections 'Loop through the sections in the main report to find the subreport objects 'then set the logon information to the subreport Dim myLogin As CrystalDecisions.Shared.TableLogOnInfo For Each mySection In mySections myReportObjects = mySection.ReportObjects For Each myReportObject In myReportObjects If myReportObject.Kind = ReportObjectKind.SubreportObject Then 'Subreport Found - convert the report object to a sub report type mySubReportObject = CType(myReportObject, SubreportObject) 'Set the specific instance of this subreport mySubRepDoc = mySubReportObject.OpenSubreport (mySubReportObject.SubreportName) 'Set the login information for the current subreport(found) For Each crTable In mySubRepDoc.Database.Tables myLogin = crTable.LogOnInfo myLogin.ConnectionInfo.ServerName = m_strDSNName myLogin.ConnectionInfo.DatabaseName = m_strDatabase myLogin.ConnectionInfo.UserID = m_strUserId myLogin.ConnectionInfo.Password = m_strPassword crTable.ApplyLogOnInfo(myLogin) Next End If Next Next #################### Does anyone know of other methods to filter a report at runtime? Or is there a Crystal DLL that I need to move from my dev machine to the server to allow for the record selection properties to be set at runtime? OR ANY OTHER INFO WOULD BE GREAT!!! Thanks, TJ Tag: Call of excel through C# Tag: 65060
  - 20
    - just in time debugger is there a way to keep a C++ .exe built in .net 1.1 from bringing up the just in time debugger? i don't want this. during normal running, we want the application to just die on a crash. what happens is the just in time comes up on the server and it just sits there with the app in a hung state. we have another process running that if any .exe "disappears", it restarts it. when JIT comes up, it doesn't disappear and the server just sits there dead. of course we need to find what is causing this, but when running in production state, we need jit to be disabled. how can this be done? thanks. Tag: Call of excel through C# Tag: 65059
  - 21
    - C# Training Videos Currently our C# Videos are free. Check them out at: http://www.vtmag.com P.S. After viewing the videos go back to the website and rate them or send an email to let us know how we are doing! Thanks, Wade Beasley *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Call of excel through C# Tag: 65055
  - 22
    - Problems with enum Documentation (NDoc Problem?) No "Description" in resulting HTML File using NDOC (Version 1.2.1303.41457). From the Framework side I think I am doing everything correctly, because the resulting XML has the coments. Is this a known NDoc problem? Is there a NDoc newsgroup? C# : public enum Back { /// Crosshatch/CROSSHATCH (0) - CardsDll (53) Crosshatch, ... } resulting XML : <member name="F:mj10777_Cards.Back.Crosshatch"> Crosshatch/CROSSHATCH (0) - CardsDll (53) </member> Mark Johnson, Berlin Germany mj10777@mj10777.de Tag: Call of excel through C# Tag: 65052
  - 23
    - wierd problem happening when debugging and AppDomain.UnhandledException event is handled I can't explain why this is happening but here goes I have a class library being called by a Windows forms app [all VB.Net], option strict is ON before the Application.Run(new frmMain), I call AddHandler AppDomain.CurrentDomain.UnhandledException, addressof AppDomain_UnhandledException theres a call into the class library, several calls down the line is a P/invoke to a 3rd party DLL when I step INTO the function it all works if I step over/run the function the process immediately terminates... no warnings, no errors displayed in VS.Net's output anybody got any ideas? i bet this is gonna be a tough one -- Eric Newton C#/ASP Application Developer http://ensoft-software.com/ eric@cc.ensoft-software.com [remove the first "CC."] Tag: Call of excel through C# Tag: 65044
  - 24
    - Asp.net project Hi, I have Visual Studio.net installed successfully on my new XP system. I wanted to create a Visual C# project using Asp.net Web Application template. I select the template and enter OK. I have new POPup Message "Create New Web" and it displays the message for 30 - 45 mins and fails. Creating the Web "http://localhost/testWebapplication1". I appreciate if any one help me out. Thanks in advance, Tag: Call of excel through C# Tag: 65043
  - 25
    - Uninstalling a NT Service programmatically Hi NG, I'm writing a management tool for our software, that among other should be able to install and uninstall some of our NT services. The problem is that when I uninstall the services (using ManagedInstallerClass.InstallHelper with the "/u" parameter) the services are uninstalled, but they are still running until I close my management application. This is a problem since I want to remove the service assemblies as a part of the uninstallation. I read the Knowledge Base-article 287516 (http://support.microsoft.com/default.aspx?scid=kb;en-us;287516), which seems to be addressing my problem. It claims that all handles to the services needs to be closed before the service can be uninstalled. Thats fair enough, but eventhough all my ServiceControllers are Close()'d and Dispose()'d the problem persists. Is there a way to release all handles to a service allowing it to be uninstalled at once? Or is there another way to do this? Thanks for your time, Ricky Tag: Call of excel through C# Tag: 65037
- Next
  - 1
    - Enumerating windows from an NT service Hi all, The service I have written can not enumerate the current user's desktop windows when running as a service. I read where one solution to this is to install the service with "SystemAccount" rights and "Allow service to interact with desktop" but I know it leaves the system vulnerable to maliciousness. Is there a way to programmatically enumerate through the current desktop windows when running as a service? Also, How I can know the name of the user when he logged? Thanks in advance Tag: Call of excel through C# Tag: 65035
  - 2
    - AxWebBrowser control BeforeNavigate2 event does not fire This is a multi-part message in MIME format. ------=_NextPart_000_0070_01C3C474.C151CD80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;325079 tried the proposed solution and provided alternate methods to capture = the event, still doesn't fire. Anyway to fix this? Erez ------=_NextPart_000_0070_01C3C474.C151CD80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2><A=20 href=3D"http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;325079"= >http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;325079</A></FO= NT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>tried the proposed solution and = provided alternate=20 methods to capture the event, still doesn't fire.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Anyway to fix this?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Erez</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0070_01C3C474.C151CD80-- Tag: Call of excel through C# Tag: 65033
  - 3
    - .Net Framework SDK Licence Agreement and OpenSource I am looking to start an Open Source project using C# but the requirements of the project require that the project must be written in a language that has freely available compilers. I am correct in think that the .Net Framework SDK is a free download from Microsoft and could be used for such an Open Source project with these requirements? I have tried finding an End User License agreement for the SDK without success. Can someone provide me with a URL to such an agreement so that I can provide this to the administrators of the Open Source project to satisfy their concerns. Thanks in Advance Heath Tag: Call of excel through C# Tag: 65031
  - 4
    - activex textbox vs windows forms textbox I'm porting an MS Access application to a .NET windows forms application. For several forms I need to use textboxes which support input masks and whose border color I can change, neither of which seem native to .NET. Is the addition of activex controls my only solution. So far, I've only found Microsoft's masked edit control (V6) which supports the input mask, but doesn't give me any control over the border color. Does anyone know if there are any better activex textboxes out there which fit the bill, or if there is a native dotnet solution that I'm missing and I could implement? Ta Tag: Call of excel through C# Tag: 65030
  - 5
    - clearing back history in IE Hi all! Can anyone tell me how do I clear the history in Internet Explorer's Back button, so that when the app gets redirected to a certain form the user won't get the possibility of getting back to the previous one using the back button... In particular, I have a login form, and after the user logs in, I don't want the user to get back there unless he/she logs out Thanks ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Call of excel through C# Tag: 65028
  - 6
    - { in a string.Format How do you escape a { in a format string for string.Format? I want to have a format string that builds code, something like "static void {0}() { {1} }". I know there are other solutions like building the {1} with the brackets. Tom Tag: Call of excel through C# Tag: 65020
  - 7
    - GetObject in .NET c# Dear All, I have to move my VB code to C#. But I have no idea on the GetObject method in Vb. ----------------------------------------- Set dom = GetObject("WinNT://" & domain) ----------------------------------------- This is easy for VB to get the object by COM monikor interface. However, what I use the following code to active a object via monikor in c#, what I got is a OBJECT Type. ---------------------------------------------- Marshal.BindToMoniker("WinNT://" + strDomain); //c# code ---------------------------------------------- Is there any way for me to KNOW the returned object type and case it to the right type in .net??? Thanks very much! -yy Tag: Call of excel through C# Tag: 65018
  - 8
    - ebXML I just want to find out about ebXML and if microsoft does use or support this standards, also find out if the ebXML has a seperate editor for the code or is it similar to the XML editor. Tag: Call of excel through C# Tag: 65017
  - 9
    - Configurable print formats. Hi; We have a requirement in our application wherein all the TEXT in the application especially the print formats for the documents and reports are configurable files that would be part of the software packaging. In other words, these formats can be changed, but the software need not be re-loaded. We will just need to download the latest formats on the handheld. I would appreciate any pointers on how to go about doing this. Thanks and Kind Regards; Ajit Goel Tag: Call of excel through C# Tag: 65014
  - 10
    - HttpWebResponse can't handle duplicate header Hi, HttpWebResponse will just display the last value of those same name http header. Ex. Aheader: a value Bheader: b value Cheader: c value 1 Cheader: c value 2 Cheader: c value 3 Dheader: d value Retrieving the Cheader value by the headers property of httpwebresponse will only return the "c value 3". Is there any workaround? Thanks MrJun Tag: Call of excel through C# Tag: 65012
  - 11
    - How to detect files copying Hi, I mean: I would like that my software has capacity to detect files-copying process into my harddisk (it is the same Norton Antivirus detects what files are copying and do stop that copying process). So, my software can prevent process of copying(installing) of somefiles. My question is how can I know that process (where is it copy from?, What is its name? ...) I attempted to use FileSystemWatcher() but I couldnot know where files come from. What I need is prevent copying from somefiles (they come from Floppies, CDROM) so I must know where those files come from. Please help me as soon as possible. It is urgent for me. Thank you. Tag: Call of excel through C# Tag: 65010
  - 12
    - How to detect files - copying... Hi, I mean: I would like that my software has capacity to detect files-copying process into my harddisk (it is the same Norton Antivirus detects what files are copying and do stop that copying process). So, my software can prevent process of copying(installing) of somefiles. My question is how can I know that process (where is it copy from?, What is its name? ...) I attempted to use FileSystemWatcher() but I couldnot know where files come from. What I need is prevent copying from somefiles (they come from Floppies, CDROM) so I must know where those files come from. Please help me as soon as possible. It is urgent for me. Thank you. V. Tag: Call of excel through C# Tag: 65009
  - 13
    - Alternatives to visual studio .net ? Hi all, I was wondering are there any free IDE's for .net development in particular aspx ? I really like Visual Studio, but can't stump up the cash at the moment for it. Thanks, -A Tag: Call of excel through C# Tag: 65006
  - 14
    - line control in VStudio.NET Looking for the good ol' Line Control in Visual Studio.NET that earlier used to be part of the standard toolbox in VB6. Any suggestions. If there is no such control in VS.NET can anyone recommend a good way to draw lines on WinForms. thanks, -paul Tag: Call of excel through C# Tag: 65003
  - 15
    - Select client channel for a remote call. All: I have registered several client-side channels, each with a different set of credentials. When I want to make a remote call, how can I specify which client-side channel I want to use to make the call? Thanks, Bill Tag: Call of excel through C# Tag: 65002
  - 16
    - System.Array.Rank (MS BUG?) The docs say System.Array.Rank will provide the number of dimensions in the array. But does not seem to work. I get 2 back for both 2 and 3 levels of dimensions in the array. I am forced to use Com interop, could that be breaking this? I am also using VB.NET. Strange output. See my code and locals window copy below: Looks like a MS bug to me Schneider '---CODE-------------------------------------------------------------------- ------------------- Public Shared Function ScheduleSink(ByVal InstrId As Integer, ByVal value As System.Array, ByVal MatureDate As System.DateTime, ByVal IssuedAmmout As Double) As PosMan.InstrMaster.ClsScheduleSink Dim u As Integer Dim v As Integer Dim tSched As New PosMan.InstrMaster.ClsScheduleSink Dim rnk As Integer Try If InstrId = 61091 Then Dim a As Integer a = 1 End If rnk = value.Rank Select Case rnk Case Is = 2 '--------------------------------------------------------------------------- -------- '-------LOCALS Copy for debug mode-------------------------------------------------- ' Notice rnk=2!, with three elements! '--------------------------------------------------------------------------- -------- rnk 2 Integer ScheduleSink Nothing PosMan.InstrMaster.ClsScheduleSink + tSched {PosMan.InstrMaster.ClsScheduleSink} PosMan.InstrMaster.ClsScheduleSink u 0 Integer v 0 Integer - value {System.Array} System.Array (0,0) "12/01/2016" String (0,1) "100.0000" String (0,2) "650000.00" String (1,0) "12/01/2017" String (1,1) "100.0000" String (1,2) "675000.00" String (2,0) "12/01/2018" String (2,1) "100.0000" String (2,2) "725000.00" String (3,0) "12/01/2019" String (3,1) "100.0000" String (3,2) "800000.00" String (4,0) "12/01/2020" String (4,1) "100.0000" String (4,2) "850000.00" String (5,0) "12/01/2021" String (5,1) "100.0000" String (5,2) "900000.00" String (6,0) "12/01/2022" String (6,1) "100.0000" String (6,2) "975000.00" String (7,0) "12/01/2023" String (7,1) "100.0000" String (7,2) "1050000.00" String (8,0) "12/01/2024" String (8,1) "100.0000" String (8,2) "1125000.00" String (9,0) "12/01/2025" String (9,1) "100.0000" String (9,2) "1200000.00" String (10,0) "12/01/2026" String (10,1) "100.0000" String (10,2) "1300000.00" String (11,0) "12/01/2027" String (11,1) "100.0000" String (11,2) "1400000.00" String (12,0) "12/01/2028" String (12,1) "100.0000" String (12,2) "1500000.00" String (13,0) "12/01/2029" String (13,1) "100.0000" String (13,2) "336850000" String '-------LOCALS Copy for debug mode-------------------------------------------------- ' Notice rnk=2! '--------------------------------------------------------------------------- -------- rnk 2 Integer ScheduleSink Nothing PosMan.InstrMaster.ClsScheduleSink + tSched {PosMan.InstrMaster.ClsScheduleSink} PosMan.InstrMaster.ClsScheduleSink u 0 Integer v 0 Integer - value {System.Array} System.Array (0,0) "06/01/2002" String (0,1) "20000000.0000000" String (1,0) "06/01/2003" String (1,1) "20000000.0000000" String (2,0) "06/01/2004" String (2,1) "15000000.0000000" String Tag: Call of excel through C# Tag: 65000
  - 17
    - Update on timer question... The behaviour I'm getting is that my timer is going off like an infiniant loop, sending hundreds of requests to my e-mail function. Sorry not to include that in my original post. Carlo Tag: Call of excel through C# Tag: 64997
  - 18
    - Is there an upward limit to the System.Timers.Timer.Interval value? I am using a timer in my Windows service previously discussed in my previous post to send warning e-mails to users who's account activity idle for a given number of days. Currently I have it set for 30 days, which I multiply by a base value for one day in milliseconds. The value that is currently being used is: 2592000000, which when divided by 24 * (60^2) * 1000 comes out to 30 days as it should. Can the timer not be used in this way? If it can't how does one accomplish this type of timing? Carlo Tag: Call of excel through C# Tag: 64996
  - 19
    - Process.Exited doesn't throw? I am writing a Windows Service that monitors a running instance of another (third-party) application by using the Process component. I set it up to listen for the Process.Exited event, but that event never seems to be raised. I tested further, using a .dll that runs in NUnit (just a handy place to test little hypotheses when I run into questions like this) and it still wouldn't recognize the closure, cancelling, killing or otherwise ending an application. I tried running on a different machine, and no dice. Is this a known issue? I'm responding to this event just as I would any other event. Is there something I missed? I'd rather not do a timer loop that constantly checks the state of the Process. Thanks for your help. -Marc Tag: Call of excel through C# Tag: 64990
  - 20
    - Query AD Does anyone know if it is possible or have an example of retrieving a list of DHCP servers directly from active directory? Tag: Call of excel through C# Tag: 64988
  - 21
    - FileSystemWatcher I set up a FileSystemWatcher to watch one specific file, code sample below. I have set the NotifyFilter to NotifyFilters.LastWrite. When the file is saved Class1.WeChanged is fired 2 times. Does anyone know why this would be? I understand that a rename or a move causes multiple events to be fired but don't know why LastWrite would get fired more than once. FileSystemWatcher fs = new FileSystemWatcher ( ); fs.Path = ".\\"; fs.Filter = "Test.dat"; fs.NotifyFilter = NotifyFilters.LastWrite; fs.Changed += new FileSystemEventHandler ( Class1.WeChanged ); fs.EnableRaisingEvents = true; Thank You Ken Tag: Call of excel through C# Tag: 64987
  - 22
    - Generating Html Pages Hi all, I need some help, I need to generate Html Files taking data from the database (SQLServer) to the specified network path on Button click of the windows form. I need to use only windows forms not web forms. Please can somebody tell me what to do Thanks in advance Tag: Call of excel through C# Tag: 64983
  - 23
    - Initializing ADO.Net SQL connection in Windows Service. I am trying to initialize an ADO.Net SQL connection to an sql server in my Windows service and I'm getting the following exception while trying to initialize the SqlConnection Object. The language is C#. System.ArgumentException: Unknown connection option in connection string: user. at System.Data.SqlClient.ConStringUtil.ParseStringIntoHashtable(String conString, Hashtable values) at System.Data.SqlClient.ConStringUtil.ParseConnectionString(String connectionString) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at NotifyExpiredResume.NotifyExpiredResume.OnStart(String[] args) in c:\documents and settings\carlo razzeto\my documents\visual studio projects\notifyexpiredresume\expiredresume.cs:line 111 Here is what my connection string looks like and initializer looks like: private string ConnectionString = "Data Source=(local); User=sa; Password=****; Initial Catalog=JobSite"; public SqlConnection SQLConnection; try { SQLConnection = new SqlConnection(ConnectionString); } catch(Exception ex) { EvntLog.WriteEntry("There has been an exception trying to init SQLConnection:\n" + ex.ToString(), EventLogEntryType.Error); EvntLog.Dispose(); return; } Tag: Call of excel through C# Tag: 64982
  - 24
    - reading machine.config file I have a problem that involves many technologies - if anyone thinks there's a better group to post this to, don't yell and scream, just let me know. OK, our company is developing apps with VB.Net (using Remoting) and Crystal Reports. To solve the problem of creating multi-language reports, I wrote a UFL (User Function List) to do all the translating. I won't get into specifics, but this UFL is just an ActiveX dll written in VB6 (Crystal doesn't support writing them in .NET) that reads the translations from a SQL Server database. In addition, we have many apps and they use about 10 different databases. Since we're using remoting, the data access objects reside on our web server. All the info this data access object needs to connect to the databases is stored in the machine.config file of our web server (I know the machine.config is probably not the best .config file to store this info in - but that's where my boss says it has to be!) Finally, my problem. The Crystal reports are also running on the web server and I would like my ActiveX dll to be able to read the machine.config file for the SQL Server logon info (for it to get its translations) just like my .Net apps do. Obviously, I can't use the framework methods since the dll is written in VB6. What's the best way to find the location of the latest framework verion's machine.config file. I know I could write some hokey folder traversal method to try and find what version folder to look in. I may also be able to look in the registry, but I'm just looking for a cleaner solution. In conclusion, I'm looking for an easy and clean way to find the location of the latest version of the machine.config file without using the framework methods. Thanks in advance! Tag: Call of excel through C# Tag: 64980
  - 25
    - ShowHelp() and weird window behaviour Why is it that ShowHelp causes the Help file to show up as some sort of child to the main application? (I've tried this with MS help files and it does the same, it isn't my help file per-say) You can't click on the application without bring the help file to the front, you can't alt+Tab between the help file and the application etc. This is highly not a good thing. It should be a separate application for all intents and purposes. Anyone have any ideas? Thanks, James Hancock Tag: Call of excel through C# Tag: 64975

I use the following code in order to open a excel file
through my code.

Application excel = new Application();

excel.Workbooks.Open(....

The problem is that I can't find which parameters I have
to pass the open function. The excel version in my pc is
excel 2000.

Thanks

Top

Re: Call of excel through C# by Alvin

Alvin
Thu Dec 18 10:52:08 CST 2003

I believe it is overloaded, one of the takes a file path. Have a look at
this for guidance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office01042001.asp

--
Regards,
Alvin Bruney
Got DotNet? Get it here
http://home.networkip.net/dotnet/tidbits/default.htm
"dimitris" <xernos.dimitris@lannet.gr> wrote in message
news:066b01c3c553$c3b7b5a0$a301280a@phx.gbl...
> I use the following code in order to open a excel file
> through my code.
>
> Application excel = new Application();
>
> excel.Workbooks.Open(....
>
> The problem is that I can't find which parameters I have
> to pass the open function. The excel version in my pc is
> excel 2000.
>
> Thanks

Top