Adding function to Excel

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
    - Error 1935 I received this message while reinstalling a program. I tried to reinstall framework 1.1 but it will not install. Help? Tag: Adding function to Excel Tag: 91794
  - 2
    - what is best practises for sending out emails from .net? What are the best practises people have found for sending out emails with their web apps in .net? I've read a few places that talk about using the System.Web.Mail namespace. But I think that namespace requires an SMTP server does it not? And if it does, do people redirect the SmtpServer to their own email servers or to IIS SMTP service and have it use SmartHost to goto their email server, or just have IIS forward the emails on? I'm sorry if this has been covered before, I'm just getting into this now and would appreciate some ideas on what you guys/gals have found that worked. Thanks. Tag: Adding function to Excel Tag: 91793
  - 3
    - problem registering some file extension in winXP shell Hi: I'm trying to register some file extension in the system (.abc). According the documentation the next example should be enough, but my result is that the icon of my application appears on the Windows explorer with the files, and the description too, and the files are associated with my application correctly, but int the "Open With" submenu, and in the dialog used to select applications, there is only an Icon, the name of the application does not appear. I also have realized that the problem appears only with a .net exe file. Even creating a new .txt file and renaming it to .exe, "Open With" shows the name of the "application", but if the command key is set to a path pointing to a .net exe file, only the icon is showed. what have I missed? According to the documentation (wich is not specific to .net applications): HKEY_CLASSES_ROOT .abc = MyApp.abc.1 MyApp.abc.1 = MyApp document DefaultIcon = "c:\MyApp.exe",0 shell open command = "c:\MyApp.exe" "%1" //CODE: string extension = ".abc"; string description = "MyApp document"; Microsoft.Win32.RegistryKey rkey = Microsoft.Win32.Registry.ClassesRoot; rkey.CreateSubKey ( extension ).SetValue("", "MyApp" + extension + ".1" ); rkey = rkey.CreateSubKey( "MyApp" + extension + ".1" ); rkey.SetValue( "", description ); rkey.CreateSubKey("DefaultIcon").SetValue("", "\"" + Application.ExecutablePath + "\",0"); rkey = rkey.CreateSubKey("shell"); rkey.CreateSubKey ( "open" ).CreateSubKey ( "command" ).SetValue ( "", "\"" + Application.ExecutablePath + "\" \"%1\""); Tag: Adding function to Excel Tag: 91789
  - 4
    - .NET Framework 1.1 Configuration won't launch I get the following error when trying to launch the .NET Framework 1.1 Configuration Snap-in: Snap-in failed to initialize. Name:.Net Framework 1.1 Configuration CLSID:{1270E004-F895-42BE-8070-DF90D60CBB75} Clicking 'OK' on the message box allows the MMC to start, which displays the following message: Snap-in Creation Failed. The snap-in is not created, it may not be installed properly. If I open an MMC console and try to manually add the .NET Framework 1.1 Configuration snap-in, the MMC hangs when I select the snap-in from the list of Available Standalone Snap-ins and click "Add". The MMC must be killed with Task Manager. I'm running Windows XP SP2. It's a new Dell Optiplex that came preconfigured with .NET Framework 1.1 eight weeks ago, but our domain has a GPO that installs .NET framework 1.1 on client workstations. This resulted in the .NET Framework appearing twice in Add/Remove programs. I couldn't be sure which resulted from the GPO, so I uninstalled one, and had to remove the other entry via the registry. Then I rebooted so the GPO would reinstall the .NET Framework. It shows installed, but will not run. The relevant registry key reports that my .NET 1.1 SP level is SP1. No programs that rely on the .NET framwork will run. Any help appreciated. Thanks, Bryan Tag: Adding function to Excel Tag: 91788
  - 5
    - Creating Collections in Classes In: microsoft.public.dotnet.framework.performance Hi, can someone give links either in msdn.microsoft.com or other sites that tell me what are the best ways to create Collection properties in a class written in Visual Basic.NET? Eg., say I create a Class that instantiated allows you to get a property of collections: Forms.Controls, TreeView.Nodes etc etc. In my work, I only used ArrayList to create Collections but want to try other interface classes such iCollection, hasttables, etc etc. Thanks in advance. Tag: Adding function to Excel Tag: 91787
  - 6
    - Bursty data - SendBuffer TCP socket .NET, use messaging queue? Hello I am developing an application that sometimes ends up sending a large burst of data on the socket. My understanding is that the kernel will drop queued data randomly if the Send Buffer is overwhelmed with data. In order to prevent this there is the "SendBuffer" (One of the the enumeration values in SocketOptionName - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemnetsocketssocketoptionnameclasstopic.asp I have not been able to determine the largest possible value that SendBuffer can be assigned; I really doubt if it is unlimited upto the system memory. I am hoping to get information about platforms running *WinXP* as well as *CF* so I am placing the post on both the groups. Extrapolating the question, *if* the SendBuffer is limited to a few tens of kB then is there a built in queueing mechanism to make sure that data trickles into the TCP connection when the burst comes? This is a real-time app (with almost gaming like requirements) so I am not sure if using a messaging queue would be very useful because the messaging queue stores stuff on the hard-disk sometimes. Anyone had any experience with these type of issues? Thank you very much for reading. -Jumu Tag: Adding function to Excel Tag: 91784
  - 7
    - scheduled windows task How to write a scheduled windows task . Not a windows service I want to schedule this exe in windows task scheduler. Thanks ajit Tag: Adding function to Excel Tag: 91783
  - 8
    - dll inside a dll? is it possible to reference a dll that is inside another dll? in our program we have a solution called functions.dll and we are also using the mysql.data.dll in all our other solutions. is there a way to reference the mysql.data.dll in each solution by only making the functions.dll one of the references? i tried it by just having the "using mysql" in the functions.dll but it does not seem to work. is this possible or not? thanx in advance for the help Tag: Adding function to Excel Tag: 91782
  - 9
    - Microsoft: Help with OLE documents... Hi all. I have an application to draw and design different documents, that supports linking and embedding of other documents (like, for instance, Corel Draw or Word). Then, the user can print their designs "WYSIWYG", so I load the external document inside an OLE document container control (VB6), get a handle to the object and invoke OleDraw with the hDC that I want the object in. This have been working excellent, and this application is largely distributed among our clients. The problem is we want to migrate to .NET (any language, VB, C#, C++, ...), but there's no OLE container that lets me obtain a handle to an OLE document. I know you could import COM and ActiveX, but this particular control (included in VB6) CANNOT BE IMPORTED NOR INSERTED in .Net. Microsoft calls this a "migration issue" and warns us about it, but how, then, can I draw an Ole document inside our application (let alone open, edit, update, etc)? Is Microsoft planning to update this component for VS.Net 2005? Or is there an alternative? I know I could load an OLE document "the hard way", but those are methods so obscure, I get lost before even starting to insert the document in a container... If this is the only solution, is there an easy (as easy as this can be) example that can lead me to accomplish the insertion of a document inside mine? I know it can be done, because RTF editor lets you do it. It even lets you open and edit the document, and "paste special", but I don't seem to accomplish getting a handle to any of those inserted objects... Thank you for your time, VBen. Tag: Adding function to Excel Tag: 91781
  - 10
    - Memory leak ? iexplore.exe? Our applicaiton Windows Forms controls in IE browser. I noticed that some times iexplore.exe process stays on the taskmanager even after closing the browser window. The behavious is not consistent and does not happen on all machines. However it is consistent if we open a PDF file from our application in the browser. Why iexplore.exe process never closed? Is it because we are hosting .NET controls in IE ? Why is the memory not released for IE process? Please help, any suggestions? Thanks, Srini Tag: Adding function to Excel Tag: 91780
  - 11
    - Regex to identify asp.net server control in a given html I am not sure if it is the right forum for Regex topic. If not, please point me the right forum. For a given HTML, I need to identify each asp.net server control. I am not an expert in regex, can someone give me a hint to write it? In the HTML, I need to identity the patterns for <tag * runat="server" * /> or <tag * runat="server" * > * </tag> In which tag is in the pattern of *:* Then I need to get the start index and end index of the string that match the pattern. Thank you very much for your help! Tag: Adding function to Excel Tag: 91778
  - 12
    - Socket.GetSocketOption MaxConnections bug ? After calling mySocket.Bind(someEndpoint) to an IP endpoint I immediately attempt to get the MaxConnections allowed through mySocket.GetSocketOption(System.Net.Sockets.SocketOptionLevel.Socket,System.Net.Sockets.SocketOptionName.MaxConnections) and a socket exception is thrown. Is this a bug in the .NET 1.1 framework, or is there something I do not understand in this call ? Tag: Adding function to Excel Tag: 91777
  - 13
    - How to Deserialize to a specific object instance. Hi, I would like to be able to deserialize a stream to a specific instance. Deserialize returns me a new instances and that is not really what we need, we need to deserialized to an existing instance. Can anyone point me in the rigth direction? Regards -Martin Tag: Adding function to Excel Tag: 91765
  - 14
    - VS 2002 and Framework 1.0/1.1 SP upgrades This is a question regarding service packs for the .NET Framework. We are still using Visual Studio .NET 2002 development environment to write our ASP.NET apps. However, on our app servers we also have .NET Framework 1.1 installed. Our current versions of framework offerings are 1.0 SP2 and then framework 1.1 with NO service pack. I know that as far as coding against the .NET Framework goes, since we are using VStudio 2002, we are coding against the 1.0 Framework. So my question is, when there are new Framework service packs released, do we need to only install the 1.0 SPs since we are coding with VStudio 2002? Or do the latest 1.1 framework SPs essentially rollup all the 1.0 changes? Since we code against the 1.0 Framework, just seems upgrading 1.1 service packs wouldn't do anything. Right now the 1.0 Framework is up to SP3 and the 1.1 Framework is up to SP1. I just want to know if I only need to install 1.0 SP3, only 1.1 SP1 or both. Thanks! -Mike Tag: Adding function to Excel Tag: 91761
  - 15
    - How to disable event Hello, I am writing vb .net win form application. The code for disable button event at C# is: button1.Click -= new System.EventHandler(button1_Click); How can this be done at vb .net? Thank you. Tag: Adding function to Excel Tag: 91755
  - 16
    - xcel error at web server Hello, I am writing c# web application with Excel 2000. I have Excel 2000 install at my workstation, but not at the web server. My code is: Excel.Application EXL; EXL = new Excel.Application(); --> This row return the following error at the web server: COM object with CLSID {00024500-0000-0000-C000-000000000046} is either not valid or not registered. We don't want to install Excel at the web server. What should be done? Thank you. Tag: Adding function to Excel Tag: 91754
  - 17
    - How to assign value to Excel 2000 worksheet cell Hello, I am writing c# web application with Excel 2000. My code is: Excel.Application EXL; EXL = new Excel.Application(); Excel.Worksheet WSheet = new Excel.WorksheetClass(); string FileName = MapPath(".") + "\\..xls"; WSheet = (Excel.Worksheet)EXL.Workbooks.Open(FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing).Worksheets.get_Item(1); Excel.Range rng = WSheet.get_Range("H12", Type.Missing); string H12 = "H12: " + rng.Value2.ToString(); // Works fine How can I assign value to cell? rng.Cells[6, 3] = "a"; --> return the following error: error: cannot assign '"a"' into 'rng.Cells[6,3]' Thank you. Tag: Adding function to Excel Tag: 91753
  - 18
    - Excel process doesn't shut down Hello, I am writing c# web application with Excel 2000. My code is: Excel.Application EXL; EXL = new Excel.Application(); Excel.Worksheet WSheet = new Excel.WorksheetClass(); string FileName = MapPath(".") + "\\..xls"; WSheet = (Excel.Worksheet)EXL.Workbooks.Open(FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing).Worksheets.get_Item(1); Excel.Range rng = WSheet.get_Range("H12", Type.Missing); string H12 = "H12: " + rng.Value2.ToString(); EXL.Workbooks.Close(); EXL.Quit(); Although I use EXL.Quit, Excel process doesn't shut down (still running at windows task manager). Why? Thank you. Tag: Adding function to Excel Tag: 91752
  - 19
    - Method for finding dotnet version Hi All, I am using Visual studio 2002. The dotnet version that comes with this, is dotnet version 1.0. I have installed dotnet framework version 1.1 recently. How can I associate dotnet version 1.1 with the VS 2002 ? Also, what is the dotnet API in C# to find the version of dotnet? best regards sijo Tag: Adding function to Excel Tag: 91750
  - 20
    - System.Web.Mail Error Hi, We are trying to send the mail using these framework set of classes from the namespace - System.Web. We are getting the following exception. Does anyone know about this problem? Exception - "Unable to send mailSystem.Configuration.NameValueFileSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 does not implement IConfigSectionHandler" Environment Details: In our client's machine - we have both Framework 1.0 & Framework 1.1. And our application needs both the frameworks. Developed Application: This is the data feed process developed using the C#.Net application; the error log will be thrown to the configured email address using the System.Web.Mail. Since the above exception is throwing, we are not getting any email. Can you please let me know the solution for this pronlem. Thanks in advance, Kiran Nakhate +91-98805-94142 Tag: Adding function to Excel Tag: 91745
  - 21
    - Simple: Excel Jet 4.0 Link vb 2005 I need to link an excel file to a VB.Net program, so that the host computer doesn't need excel on it to read the cells. I don't need any functions of excel, just values from cells for viewing in textbox's. I am trying to link the file using the database explorer, but, after right clicking and selecting new database ole connection, then Jet 4.0 and the file name, I am being told that : "Could not find installable ISAM" I have looked on the newsgroups, and I have made sure that I have the latest versions of the Jet 4.0 installed I have the latest service pack, Office 2003 and VB 2005 express beta1. I'm thinking that maybe this a bit of a bad combination?? Tag: Adding function to Excel Tag: 91744
  - 22
    - ENTER and forms Can I use ENTER to submit my form using C#? I have used Page.RegisterHiddenField("__EVENTTARGET", "btnFind"); This works SOMETIMES but not all the time. I saw http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwindowsformsformclassactivatedtopic.asp and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwindowsformscontrolclassgotfocustopic.asp which explains that ENTER is not used since the Activate is used for Forms. I understand the logic but I still cant get my forms to always submit on ENTER and instead it uses the first control (a list) and ends up being redirected. Enter has been used for decades to submit a request dating back to "dumb terminals" and even typewriters. So it makes sense to use the ENTER to submit forms. Tag: Adding function to Excel Tag: 91742
  - 23
    - Help for SocketOptionName.PacketInformation Hello, need aynone knowing something about the SocketOptionName.PacketInformation! Background: I have a little app sending and recieving ICMP-Echo and Echo-Replies. Now I wonder if it's possible to determine the MAC-Address of the answering Machine. After searching in MSDN-Library I found the SocketOptionName.PacketInformation and thought it could give me some details of the recieved pakcet. Now I'm trying to implement it but it doesn't gave me information at all. I tried a socket.getsocketoption() with an predefined byte-Array but afte the call the byte array is empty. So is there anybody able to tell me how to use this SocketOption correctly? Or does anybody know how to retrieve the MAC-Address from the Echo-Reply-Packet recieved by my socket? looking forward for the solution ;-)))) Tag: Adding function to Excel Tag: 91741
  - 24
    - reflector Do you know Lutz Roeder's Net Reflector.. it is disassembler for .net framework dll and exe. How can i protect my dll from disassemble program like this... Tag: Adding function to Excel Tag: 91740
  - 25
    - How does IIS or Framework set the Content-Length header ? Hello, I'm experiencing a strange problem with an aspx page. This page does NOT set the Content-Length header. When hosted on my development PC (with IIS 5.0 and .Net 1.1), the HTTP response however contains a Content-Length header. When hosted on our test server (IIS 5.0 and .Net 1.1 as well) the Content-Length is not set, causing the server to send the response (roughy 10KB) in several chunks which seems to dramatically decrease performances. My questions are: - How does IIS (which layer or component and with which algorithm) sets the Content-Length for a dynamic page ? - Which conditions would make our test server not to fill this header hencing causing (I guess so) this chunked encoding response ? Any thoughs or idea ? Thanks in advance Arno Tag: Adding function to Excel Tag: 91739
- Next
  - 1
    - mscorwks.dll I have an application that runs for about 1 minute before an exception window comes up saying: SV_TpeConsole.exe - Application Error The instruction at "0x7931529c" referenced memory at "0x00000000." The memory could not be "read". The .Net debugger only gives the assembly code. Is there a way to find out the call stack for this error or some other more useful information? None of the timers in the program are invoking this error, as they have been checked. Tag: Adding function to Excel Tag: 91731
  - 2
    - Record my webcam Hello, I'm trying to record the video and audio streams from my webcam/microphone to a file on the disk. Can someone point me in the right direction on how to accomplish this? Thanks, Eric Tag: Adding function to Excel Tag: 91724
  - 3
    - .net and mysql join i'm curious if there are any known issues with the 2. i've tried it in vc# and vb and i get the same results with both. every time i run a join and it gets to a 0 or null it makes everything following it in that column null. the mysql statement is: "select customers.name, customers.firstname, customers.customerid, customers.contact, customers.memorec, extinfo.info, memos.memo from customers left join extinfo on customers.rec=extinfo.rec left join memos ON customers.memorec=memos.rec where customers.rec=extinfo.linkrec and extinfo.identifier=1 and extinfo.primarytype=2 and customers.inactive=0 order by customers.name asc" the memorec points to the coresponding rec in the memo file. the problem is that if a customer has a 0 memorec (no memo) then the dataset makes it null and all the memos following it. is this a known bug or am i doing something wrong? is there a better way to do this? Tag: Adding function to Excel Tag: 91717
  - 4
    - Windows service & Web service Interprocess Communication Hello all! I need an easy way to pass data between windows service & Web service For example pass a data set, or recordset , Both written in C# , Both running on the same machine so I'm trying to avoid Sockets / network communication Any .Net solution? Thank you! Sharon Tag: Adding function to Excel Tag: 91687
  - 5
    - Debugging windows service hosted remote classes I have a windows service hosting remoted classes(SAO) I want to debug these classes My client is windows application, objects remoted using TCP channel Any help is appreciated Thanks John Tag: Adding function to Excel Tag: 91686
  - 6
    - How to make an assembly search for its dependent DLLs in a specific path (other than the installed directory) Hi I've two products which share lot of common DLLs. I want to create a common directory and store these common DLLS. Now how can i make my executables (or other assemblies) search for the dependecnt DLLs in this common directory ? Thanks -sudhakar Tag: Adding function to Excel Tag: 91685
  - 7
    - .NET error using Group Policy Management Console? I make extensive use of Group Policy on our SBS 2003, so a few weeks ago I finally installed the Group Policy Management console snap-in on my XP Pro SP2 workstation. I've been successfully managing Group Policy via this console, but today when I selected a GPO and clicked the Settings tab, it hung on the message "Generating Report..." for much longer than usual, and finally displayed the following error message: "An Error occurred while generating report: File or assembly name System, or one of its depedencies, was not found." Efforts to run down this message mostly lead to discussions of version errors with the .NET framework that I don't completely follow. However, I tried uninstalling and reinstalling the .net framework, and checking my service pack level (I thought I might have applied .NET Framework SP2, but it doesn't appear to be installed on my system). I'm not sure what's next. Should I try uninstalling and reinstalling the GPM console? I'd rather not work blindly, so I don't want to try too much until I have a better idea of what went wrong in the first place. Thanks in advance, Bryan Tag: Adding function to Excel Tag: 91680
  - 8
    - Impersonate call fails even after duplicating token here is the code: IntPtr token1 = IntPtr.Zero; int loggedOn = -1; loggedOn = LogonUser(lpszUsername,lpszDomain,Pwd,LOGON32_LOGON_INTERACTIVE,LOGON32_PROVIDER_DEFAULT,ref token1); if(loggedOn == 1) { IntPtr dupeTokenHandle = new IntPtr(0); bool retVal = DuplicateToken(token1, SecurityImpersonation, ref dupeTokenHandle); WindowsIdentity newId = new WindowsIdentity(dupeTokenHandle); CloseHandle(dupeTokenHandle); CloseHandle(token1); System.Security.Principal.WindowsImpersonationContext wimp = newid.Impersonate(); } The Impersonate() line fails with this error: System.Security.SecurityException: Unable to impersonate user. Tag: Adding function to Excel Tag: 91674
  - 9
    - I need some help with remote acces to a help file I have a program that is resident in the web server. It is one-touch installed on the client system and it is activated via URL so that it runs in IEEXEC. This program has a .chm file associate with it. The problem is 1) - Every time I try to reference the .chm, I get a dialog warning me that .chm files might not be safe and ask if to continue 2) - When I do continue to access the .chm, none of the positioning to the different TAB (index, search, contents) work, but if the same program is run from a command line from the same directory, this positioning works. 3) - Of course opening the help with a position to a keyword does not work either. Question. What is the best method for utilizing help files when the help file is remote to the system the program is being run on? ------------------------------------------- Roy Chastain KMSystems, Inc. Tag: Adding function to Excel Tag: 91673
  - 10
    - StreamWriter.close() hangs in multithreaded execution I've got a program accessing a HTTP service to get som XML data. The code receiveing the data looks something like this: stream = new StreamWriter(httpRequest.GetRequestStream(),Encoding.UTF8); stream.Write(body); stream.Close(); The httpRequest is a HttpWebRequest object. This works fine from a single thread execution, but when I'm accessing this method on its own thread, the Close() method seems to hang. Any ideas as to what I'm doing wrong? Jan -- Do or die.. Tag: Adding function to Excel Tag: 91672
  - 11
    - Windows Service and User Credentials How can I get the credentials of the currently logged on user in a Windows Service? The service is running under the user account and I need to pass the credentials to other business layers. Tag: Adding function to Excel Tag: 91669
  - 12
    - what is the best way to read text file Dear sir/lady, I need to process our web server log file every day. Normally, this file is about 50MB - 100s MB big. How can I read the file in a effective way. I can open a streamreader to read it and use readline() function to read line by line and process them. However, this sounds very slow. I can also use readtoend to read everything into a string, but then I am afraid that it will be too big for memory. How should I read the file? Tag: Adding function to Excel Tag: 91668
  - 13
    - How to prevent double logins Hi, I would like to prevent users to login more than one time with single user/password to my .NET web application at the same time. I managed to achieve this by writing combination of last access time and userid to application and session object but this solution is not stable enough, because my ISP's web server is doing application pool recycling frequently. Any help or hint appreciated. Tag: Adding function to Excel Tag: 91667
  - 14
    - VS.NET & client script viewer? Dear All, How can I access the client side scripts (javascript) for ASP.Net page. Through the IDE of Visual studio .Net AS We were did with Visual Interdive 6. There was ability to see server and client side script, and overall object,... I miss VID 6 !! Any help ? -- MCSD not .Net yet :( Tag: Adding function to Excel Tag: 91663
  - 15
    - FTP Dir List with .NET Framework 1.1 Does anyone have knowledge of code that will get the directory list off an FTP site? There doesn't seem to be support in .NET Framework 1.1. I found code at the MSDN Longhorn help site but that code didn't work. I think it was for a newer version of .NET not yet released. Any insight would be greatly appreciated. Thanx, Poe Tag: Adding function to Excel Tag: 91652
  - 16
    - FRMWK 2 BETA VERSION PROBLEM Hello, I have downloaded and installed the fmwk 2 beta version V2.0.40607 from the MS site. I try to install the SQL SERVER 2005 Express manager, but it needs the version 2.0.40903. Does someone have an idea where I can find that version ? Thanks -- Alain CAVROT DataBases on the Web & on the LAN Tag: Adding function to Excel Tag: 91650
  - 17
    - Microsoft .NET Framework 1.1 I am trying to install the Microsoft .NET Framework 1.1 and get a debug error... the long and short of it is this when I click cancel.... cordbg.exe..... error... what is up with this... From http://www.developmentnow.com/g/6_0_0_0_0_0/dotnet_framework.htm Posted via DevelopmentNow Groups www.developmentnow.com/g www.developmentnow.com Tag: Adding function to Excel Tag: 91646
  - 18
    - how to Drag & Drop Files? I have a picture box control with an image loaded. I would like to be able drag the image from the picture box into an email or the desktop. Does anyone know how to do this? Using the DoDragDrop with Outlook, i have been able to drag the filename into an email. Is there any way to drag the picture instead? Tag: Adding function to Excel Tag: 91645
  - 19
    - .net 2.0 beta 2 where is download for this version ? w/regards Pawel Tag: Adding function to Excel Tag: 91635
  - 20
    - native .NET equivalent of Microsoft Script Control ? Is there a native .NET equivalent of the Microsoft Script Control, particularly the Eval method? See here: http://www.devx.com/vb2themax/Tip/18773 It works great - it even compares string expressions. I just would prefer a native .NET version over COM if at all possible. Sample code: Dim scriptControl1 As New MSScriptControl.ScriptControl Dim sExp As String scriptControl1.Language = "VBScript" Textbox1.Text = "" sExp = "12 + 3 * 10" Textbox1.Text += sExp & " = " & scriptControl1.Eval(sExp) & vbCrLf sExp = "(`abba` < `bagel`)" sExp = Replace(sExp, "`", Chr(34)) Textbox1.Text += sExp & " = " & scriptControl1.Eval(sExp) & vbCrLf sExp = "(`red` < `bagel`)" sExp = Replace(sExp, "`", Chr(34)) Textbox1.Text += sExp & " = " & scriptControl1.Eval(sExp) & vbCrLf sExp = "((1*5)*5)" sExp = Replace(sExp, "`", Chr(34)) Textbox1.Text += sExp & " = " & scriptControl1.Eval(sExp) & vbCrLf sExp = "( (`abba` < `bagel`) and true) or ( ((1*5)*5) = 25 ) " sExp = Replace(sExp, "`", Chr(34)) Textbox1.Text += sExp & " = " & scriptControl1.Eval(sExp) & vbCrLf Tag: Adding function to Excel Tag: 91630
  - 21
    - Mysteries of a font in the PropertyGrid... I would like to know by what mechanism a font displayed in a PropertyGrid, shows children (like Bold) that correspond to Properties that only have a get, no set. Is there a special class in the framework that gives the PropertyGrid the list of rows to display for the font, and when a new value is entered by the user, the way to modify the underlying font (since a bold attribute is assigned to the font inside a FontStyle) ? Thank you for your help. Herve Tag: Adding function to Excel Tag: 91629
  - 22
    - "Com object with CLSID {...} is either not valid or not registered." Hello. I want to use CAPICOM in my application, but a System.Runtime.InteroptServices.COMException is thrown, with an error message as in the subject. How do i fix this? How do i register the dll (capicom.dll) so i can use it? Thanks, Ivan Zuzak Tag: Adding function to Excel Tag: 91627
  - 23
    - Want to deserialize a property to *one* XmlElement I have an object deserializing from an XML stream, and I want to use behavior similar to that you get by tagging a public class member with a [XmlAnyElement] attribute. But instead of deserializing any number of elements into XmlElement[], I want to deserialize into a *single* public member XmlElement. Somebody know how to do this? Simply making a member and mapping it via an attribute like below doesn't seem to be working. [XmlElement("tagname")] public XmlElement myMember; Or perhaps the above should work and I just have something else failing? TIA, -- kov Tag: Adding function to Excel Tag: 91626
  - 24
    - How to auto-convert types? Well, I'm programming in vb.net and I'm developing a custom class (named XmlEl) that inherits from the XmlElement class. It has a New routine that receives an xmlelement and constructs the XmlEl instance. But in certain occasions I need the machine to auto-convert an xmlelement to an xmlel, rather than having to type all the time New XmlEl(XmlElement). As I've noticed the CType function exists for that cause. For example, to convert an xmlnode to a xmlelement, one could use Ctype(XmlNode, XmlElement). That's how I want to use my class: CType(XmlElelement, XmlEl). So, how can I achieve it? I also noticed in the SDK the class TypeConverter but I just don't know how to use/apply it on my class. Any ideas or tips?? Tag: Adding function to Excel Tag: 91623
  - 25
    - How to auto-convert types? Well, I'm programming in vb.net and I'm developing a custom class (named XmlEl) that inherits from the XmlElement class. It has a New routine that receives an xmlelement and constructs the XmlEl instance. But in certain occasions I need the machine to auto-convert an xmlelement to an xmlel, rather than having to type all the time New XmlEl(XmlElement). As I've noticed the CType function exists for that cause. For example, to convert an xmlnode to a xmlelement, one could use Ctype(XmlNode, XmlElement). That's how I want to use my class: CType(XmlElelement, XmlEl). So, how can I achieve it? I also noticed in the SDK the class TypeConverter but I just don't know how to use/apply it on my class. Any ideas or tips?? Tag: Adding function to Excel Tag: 91622

Hi,
Using Add-In project, I can't find how to make my public functions available
in Excel ?

Thks for help.

Re: Adding function to Excel by Carlos

Carlos
Thu Feb 17 08:38:12 CST 2005

You would have to ellaborate a bit more your problem, but basically using
.NET you have:

- Add-Ins for the VBA Editor of Excel.
- Add-Ins for the Excel itself.
- .NET DLLs exposed as ActiveX (COM) DLLs that you can reference from the
VBA Editor of Excel.
- Visual Studio Tools for Office (VSTO), to have a .NET assembly linked to
your Excel file instead of using embedded VBA code.

So, what are you trying to do?

--

Carlos J. Quintero

MZ-Tools 4.0: Productivity add-ins for Visual Studio .NET
You can code, design and document much faster.
http://www.mztools.com

"Franck" <nospam@nospam.com> escribió en el mensaje
news:421263a0$0$22950$636a15ce@news.free.fr...
> Hi,
> Using Add-In project, I can't find how to make my public functions
> available in Excel ?
>
> Thks for help.
>

Top