Excel in Office 2007

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Dotnet
- 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
 - Can legacy code call .NET? At our company we have some old code written using Powersoft's Power++ (a RAD C++ product). Power++ has been discontinued for quite a while now so we don't want to use it for new projects. We'd like to write a program in .NET that can be called by an old program we wrote in Power++. I'm assuming it is impossible to do that on the code level. Is there perhaps another way that a legacy .dll or .exe can call functionality in a .NET assembly? Usually all the stuff I see on the internet is about .NET code calling legacy code. And even then, it seems like it is calling .COM stuff or unmanaged Visual C++ code. Tag: Excel in Office 2007 Tag: 228696
 - 2
 - CustomValidator in GridView getting "no message" on errors I have a gridview and have placed customvalidator controls in it. If I put a break on the sub to do custom validation, run the page, select a row and press the EDIT button, putting me into Update/Cancel mode, I can edit the date textbox putting in garbage and press update. It takes the breakpoint, I step thru, it sets value.isValid=False, and when I exit routine, same sub fires again (hits same break point) and flow values same path. Garbage date value still there. If I continue on now, it displays the gridview, original value of date textbox is back, my error message is not displayed, but I'm still in Update/Cancel mode,not Edit mode so the update didn't take place. <asp:TemplateField HeaderText="Date Stamp" SortExpression="date_stamp"> <EditItemTemplate> <asp:CustomValidator ID="Date_Stamp_Update_Validator" runat="server" ControlToValidate="Date_Stamp_Update_Txt" OnServerValidate="Date_Stamp_Update_Txt_Validate" ValidateEmptyText="true" Display="Static" SetFocusOnError="true" ErrorMessage="Must be YYYY-MM-DD!" ></asp:CustomValidator> <asp:TextBox ID="Date_Stamp_Update_Txt" runat="server" Text='<%# Bind("date_stamp") %>' BorderStyle="Ridge" BackColor="LightYellow" MaxLength="10" Width="65px"></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Date_Stamp_Label" runat="server" Text='<%# Bind("date_stamp") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Left" VerticalAlign="Bottom" Width="9%" Wrap="True"/> <HeaderStyle VerticalAlign="Bottom" /> </asp:TemplateField> Protected Sub Date_Stamp_Update_Txt_Validate(ByVal sender As Object, ByVal value As ServerValidateEventArgs) ' Must be YYYY-MM-DD Format: If value.Value.ToString.Length = 10 Then Dim dte As DateTime If DateTime.TryParse(value.Value, dte) Then value.IsValid = True Else value.IsValid = False End If Else value.IsValid = False End If End Sub Tag: Excel in Office 2007 Tag: 228695
 - 3
 - Different OutputCache Client and Server Helo, I have include @OutputCache on my ASPX with location=3D"Any" =BFCan I ser different cache time from client than from server? I would like to cache the home page of my site 3 minutes on the Server (so that it don't hit de DB) And Also i would like to cache that page un the client, 4 hours. I've tried puting the directive, <%@ OutputCache Duration=3D"120" VaryByParam=3D"IDWeb" Location=3D"Server" %> AND (Page_Load) Response.ExpiresAbsolute =3D System.DateTime.Now.AddHours(4) But the header get Expires =3D -1 Any comment, will be thank Tag: Excel in Office 2007 Tag: 228694
 - 4
 - WebRequest POST XMLDOM Not XMLDOM.xml I am trying to post an XML DOM to an ASP page using WebRequest. (C#) I know how to use a stream to send xml data but a stream is primarily intended for text. The asp page expects an XML object. Any help would be GREATLY appreciated. dave.harknessNOSPAMMING@comcast.net Tag: Excel in Office 2007 Tag: 228690
 - 5
 - What Framework Classes Do You Use the Most? I could use some feedback from you all in the .NET community. Here's the question, in a nutshell: Aside from the data types shown below, what classes in the .NET Framework do you use most frequently in the applications that you develop? The data types and classes I'd like to exclude from this list are: * Array * Boolean * Byte * Char * IDbConnection * DateTime * Decimal * Double * Enum * Int16 * Int32 * Int64 * List * Object * SByte * Single * String * IDbTransaction * UInt16 * UInt32 * Uint64 Once you've thought about this, I'd like to ask a follow-up question: When using these objects as parameters to methods or constructors, how do you typically test them for validity? For example, do you test them for null, string length, values, status, etc.? The Why of It All ------------------------- I'm working on an open source parameter validation framework written in C#. You can find the thing at www.nvalidate.org. The idea is that it turns this: if (null == foo) throw new ArgumentNullException(foo); if (string.Empty == foo) throw new ArgumentException("foo", "string parameter cannot be empty."); Into this: Demand.That(foo, "foo").IsNotNullOrEmpty() It's already had an alpha release, and provides validators for all the data types listed above. (There's a test matrix available on the web site that details the supported test types.) What I'd like to do now, in the next release, is expand the supported tests to increase its utility. I'm already casting my steely gaze on the following Framework classes: HashTable * IsNotEmpty * IsNotNull * HasCount(int) * IsFixedSize * IsNotFixedSize * IsReadOnly * IsNotReadOnly * IsSynchronized * IsNotSynchronized * Contains(string key) * Contains(string key, object value) Stack * IsNotEmpty * IsNotNull * HasCount(int expectedCount) * HasCount(int minCount, int maxCount) * HasMaxCount(int expectedCount) * HasMinCount(int expectedCount) DataReaders: * OdbcDataReader * Contains(string columnName) * Contains(string columnName, DbType type) * Contains(string columnName, DbType type, int length) * HasFieldCount(int expectedCount) * HasRows() * IsNotNull() * IsOpen() * OracleDataReader * Contains(string columnName) * Contains(string columnName, DbType type) * Contains(string columnName, DbType type, int length) * HasFieldCount(int expectedCount) * HasRows() * IsNotNull() * IsOpen() * SqlDataReader * Contains(string columnName) * Contains(string columnName, SqlDbType type) * Contains(string columnName, SqlDbType type, int length) * HasFieldCount(int expectedCount) * HasRows() * IsNotNull() * IsOpen() * Socket * Is(socket) * IsAvailable * IsBlocking * IsNotBlocking * IsConnected * IsNot(socket) * IsNotConnected * IsNotNull * IsValid(addressFamily, protocolType, socketType) * HasAddressFamily(addressFamily) * HasLocalEndPoint(endPoint) * HasProtocolType(protocolType) * HasRemoteEndPoint(endPoint) * HasType(socketType) * HasValidHandle Streams: * BufferedStream (Inherits StreamValidator) * CryptoSream (Inherits StreamValidator) * Stream * CanRead * CanSeek * CanWrite * HasLength(int expectedLength) * HasLength(int minLength, int maxLength) * IsAtEndOfStream() * IsAtPosition(int expectedPosition) * IsAtStartOfStream() * IsEmpty() * IsNotEmpty() * IsNotNull() * FileStream (Inherits StreamValidator) * HasName() * HasValidHandle() * IsAsync() * IsNotAsync() * MemoryStream (Inherits StreamValidator) * HasCapacity(int expectedCapacity) * HasMinimumCapacity(int expectedCapacity) * NetworkStream (Inherits StreamValidator) * HasDataAvailable() I think you get the idea. :-) So, the questions stand. What classes do you guys use, and what kinds of parameter tests do you *actually* perform on them? I'd rather focus on the classes that get the most use, and the tests that provide the biggest bang for your buck. Any help you can provide would be GREATLY appreciated! Thanks! Mike Hofer NValidate Developer http://www.nvalidate.org http://www.linkedin.com/in/mikehofer P.S. If anyone wants to help with this thing, drop me a line! Tag: Excel in Office 2007 Tag: 228689
 - 6
 - Speech application and grammar Hi all I am trying to write an application that will respond to voice commands and then give feedback with voice using text to speech. This is being written in .NET 3.x using C# I got the TTS stuff working but am having a bear of a time with the speech recognition. There does not seem to be much written about it and what is written often is just plain wrong. Or I am just stupid. Either way, I am having problems. The xml grammar file is blowing my mind. I can get very simple one word or a hard coded sentence to be recognized but I know the app should be much more flexible than that. What I would like to do is have a group of 4 commands that can be recognized as single words OR as words embedded in common phrases. Basically, I am only interested in the single command but would like the user to be able to ask it in several different ways. Once a command is chosen, I would like to then have another set of commands be available and perhaps more commands under each of them in a tree type structure. However, the user should only be able to issue commands that are current at a particular node level of the tree. None below, above, or siblings should be able to be issued. I know that this can be done with an xml based grammar file but I am floundering at the moment. Could someone please upload a simple example of how I could implement such a thing in the xml grammar? Or point me to a resource that is more clear than the current dot net documentation? many thanks, clay Tag: Excel in Office 2007 Tag: 228684
 - 7
 - SPF: Grid in a context menu - is this possible? In Visual Studio, if you hover over an item, the IDE open up a context menu with an expandable [+] sign. Clicking on this then brings up a context menu that appears as a grid. Clicking on sub items with a [+] then open up further contextmenus etc, etc. I'd like to be able to open up a context menu in WPF that also contains a grid (ideally data-bound to a List(of myObject)) but don't know how to do this....any ideas? Thanks Griff Tag: Excel in Office 2007 Tag: 228683
 - 8
 - Question from .net beginner regarding rebuilding custom class library I have two vb.net projects, one that creates a class library and another that uses ("consumes") the class library. Whenever I rebuild the class library project then use it in the consumer project the consumer project won't compile unless I delete the reference to the class library in the consumer project then re-add the reference. This is time consuming and error-prone. ? Is there a better way to handle this situation ? Thanks Tag: Excel in Office 2007 Tag: 228682
 - 9
 - FIND THIS INTERESTING BUG IN C# THIS SEEMS TO BE A BUG !! Watch this : (In C# ) IHTMLElement oElement = (IHTMLElement)myChildren.Current; I have created an object of IHTMLELement interface. Now when i do the following : Line 1) oElement.setAttribute("uip_copyZeroLeft",oElement.style.pixelLeft, 0) ; Line 2) oElement.setAttribute("uip_copyZeroTop",oElement.style.pixelTop,0); i.e. i am making new attributes & assigning the already defined values to them. The issue i get it after the first line is executed, a value of pixelLeft say 112 is stored in uip_CopyZeroLeft. Now, when the Line 2 is executed a new attribute is not created(i.e. uip_CopyZeroTop) is not created rather the previous attribute uip_CopyZeroLeft is overwritten with the latest value given(i.e. now uip_CopyZeroLeft stores the value of pixelTop). This is rather funny. If anyone can have the will n time to get a fix/a corresponding suggestion to this problem, i would be really grateful. Thanking all, SHYAM B url:http://www.ureader.com/gp/1444-1.aspx Tag: Excel in Office 2007 Tag: 228676
 - 10
 - Public Shared Dataset I'm just trying to wrap something around my head and am looking for some pro's vs con's on this scenario of what I am thinking of trying... If someone with some experience with this could point me in the right direction - Lets say you have an MDI and 2 forms that open in that app. Each form looks at the customer database but displays it differently. If a customer gets added on form1, you would want it to instantly show up on form2. Same data - just displays the info differently. So im assuming there are 2 options to do this: 1. on the MDI form, have a 'global' public shared dataset, so as a dataset gets refreshed, it refreshes the new records instanlty on both 2. Keep track if the other form is open, if it is, and a refresh occurs on this dataset, and its connection, refresh the other / shoot the one new record over Thanks, Miro Tag: Excel in Office 2007 Tag: 228675
 - 11
 - ANN: Version 3.1 of VintaSoftTwain.NET Library has been released. What's new in this version: - Acquisition algorithm has been optimized for compatibility with HP and Fujitsu scanners. - Opportunity to use any authentication schemes (such as basic, digest, NTLM, and Kerberos authentication) at image uploading has been added. - Redirection functionality has been added to image uploading algorithm. Tag: Excel in Office 2007 Tag: 228673
 - 12
 - Implementing Unmanaged Interface in C# Hi, I have an unmanged interface which i have exposed through COM to C#. I have been able to implement the interface in one of the C# classes (say Class1) as well. But now what i want to do is that i need to pass the reference of the object of Class1 to this COM wrapper...and then from inside that wrapper i want to call one of the func of that class1. What i did roughly is something like this: / *********************************************************************************************************/ //this is the interface that was exposed // IExportedClassWrapper [ object, uuid("7DD5445A-A8AE-471C-A065-629C3A004362"), dual, helpstring("IExportedClassWrapper Interface"), pointer_default(unique) ] __interface IExportedClassWrapper : IDispatch { [id(4), helpstring("method CheckInterfaceOne")] HRESULT CheckInterfaceOne(IDispatch* a, [out,retval] LONG* RetParam); }; / *********************************************************************************************************/ / *********************************************************************************************************/ STDMETHODIMP CExportedClassWrapper::CheckInterfaceOne(IDispatch* a, LONG* RetParam) { // TODO: Add your implementation code here IExportedClassWrapper* objI = static_cast<IExportedClassWrapper*>(a); //THIS IS THE LINE ON WHICH I'M GETTING EXCEPTION //SAYING THAT THE CALLING CONVENTION IS NOT RIGHT.... objI->MethodSampleReturn(RetParam); return S_OK; } / *********************************************************************************************************/ / *********************************************************************************************************/ //then the C# class implemented it like public class Class1 : SampleCISCOATLCOMWrapper.IExportedClassWrapper { public Class1() { // // TODO: Add constructor logic here // } #region IExportedClassWrapper Members public int CheckInterfaceOne(object a) { // TODO: Add Class1.CheckInterfaceOne implementation //THIS IS THE METHOD THAT I WANT TO CALL FROM COM return 20; } #endregion } / *********************************************************************************************************/ //and then i used this interface like this in C# SampleCISCOATLCOMWrapper.CExportedClassWrapperClass objCl = new SampleCISCOATLCOMWrapper.CExportedClassWrapperClass(); Class1 objClass = new Class1(); int nRet = objCl.CheckInterfaceOne(objClass); / *********************************************************************************************************/ this whole thing is sort of circular....:) I think you got an idea of what i want to do... Is it possible? :) And how? Note: I dont have much experience in COM ... Thanks, Saad. Tag: Excel in Office 2007 Tag: 228672
 - 13
 - Installing VS - sql develop edition I am installing VS 2008 pro, First I uninstalled all express editions, and also sql express. Then installing vs 2008 pro it installed sql express again. Then inserting cd #2, for the SQL developer edition, it wants to update sql express, but i notice with the service pack 2 that not all options are available for the sql instance. Should I have re-uninstalled sql express after vs2008 installed it again and have just 1 clean developer edition on? I am a bit confused. In the mean time I will uninstall all sql instances and then try to re-install from the cd from scratch. Seeing that I can always re-install sql express if thats the way to go about it. Thanks, Miro Tag: Excel in Office 2007 Tag: 228670
 - 14
 - Interfaces to MS Exchange/Outlook to add Calendar appointments or My organization currently has interfaces in place to generate MS Outlook emails from our business applications. I am trying to determine if it is possible and how difficult it might be to interface with MS Ecxhange or Outlook from a business application and add items to a user's calendar, task list, or at a minimum to set a follow up flag in an email. We are running Exchange 2003 and a variety of MS Outlook 2000 and 2003. We do have plans to upgrade to Office/Outlook 2007 in the near future and I'm not sure when an exhange server upgrade is being planned for. So the solution we put in place will need to be upward compatible for when we upgrade. -- EM Tag: Excel in Office 2007 Tag: 228661
 - 15
 - Is it possible/how to skip the first dialog in setup bootstrap? Hi, We have created a setup project for an app in MS VS .Net with Windows Installer Bootstrapper selected. When installing the app, we wonder if it is possible to start the installation using setup.exe without being asked the question to either start the installation or to quit the installation (the first dialog that appears)? Can it be done in Orca or in another tool and how? (We know that this behaviour is accomplished when we start the installation using the msi file but we'd like to use setup.exe) Regards, Ulf Tag: Excel in Office 2007 Tag: 228657
 - 16
 - TransactionScope MSDTC has been disabled error only on 2nd ExecRea Hi, I'm using TransactionScope to do a serie Insert, Update, Delete operations with the ExecuteNonQuery and some Selects with ExecuteScalar everything works fine with multiple connections in the same scope. Problem is that when i do two Selects with ExecuteReader (to fill datasets) it shows the folowing error: >Exception: Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool. >InnerException: The transaction manager has disabled its support for remote/network transactions. Im'm working with SQL2005 and .net3.5 Tag: Excel in Office 2007 Tag: 228651
 - 17
 - facing data loss problem in socket programming while using IIS I am facing a very strange problem in my websevice which is working on socket communication. While i am publishing my webservice to the IIS and invoking a method, a data loss problem in occuring. I seems strange because when i am using the .net framework's inbuild application development server that comes along with 2.0 framework,I am not facing this problem. I dont know why it is not working with IIS while it is working with other server? Is there is any drawback of IIS in socket communication ? I am using TCPClient to establish the connection. Tag: Excel in Office 2007 Tag: 228650
 - 18
 - How to get the path of "Common Files" directory Hello, is there a way to get the path of the directory "Common Files" via .NET? I was not able to find a proper function in class Path. Thank you, Norbert Tag: Excel in Office 2007 Tag: 228649
 - 19
 - XP Administrator password My teens access/delete/change my administrator password easily. In fact I see there are a multitude of resources available, ostensibly catering to people who have forgotten their password, for deleting and changing them. But look for advice on securing your password, what do you find? It doesn't matter how clever your password is if someone knows how to access and change it, so is there a solution or not? -- Confused old guy Tag: Excel in Office 2007 Tag: 228648
 - 20
 - The young golfer from Wales believes "Discipline is definitely The young golfer from Wales believes "Discipline is definitely learned and gets better with practice." Doctors and scientists said that breaking the four-minute mile was impossible, that one would die in the attempt. Thus, when I got up from the track after collapsing at the finish line, I figured I was dead. http://shenrilaa.googlepages.com/ Tag: Excel in Office 2007 Tag: 228644
 - 21
 - Office Accounting 2008 - how do I invoice an expense item? I've rented equipment for a job, I've created an expense report for that cost. I'd now like to be able to assign this expense to my client, I'd also like to be able to include this expense as a non-taxible line item in an invoice to that client so they can reimburse me. Thanks in advance! - Will Tag: Excel in Office 2007 Tag: 228641
 - 22
 - Bind error during Install of Published VB 2008 App PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Common Language Runtime : 2.0.50727.1433 System.Deployment.dll : 2.0.50727.1433 (REDBITS.050727-1400) mscorwks.dll : 2.0.50727.1433 (REDBITS.050727-1400) dfdll.dll : 2.0.50727.1433 (REDBITS.050727-1400) dfshim.dll : 2.0.50727.1433 (REDBITS.050727-1400) SOURCES Deployment url : file:///C:/Documents%20and%20Settings/Pete/My%20Documents/Visual%20Studio%202008/Projects/Sudoku/Sudoku/publish/Sudoku.application ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of C:\Documents and Settings\Pete\My Documents\Visual Studio 2008\Projects\Sudoku\Sudoku\publish\Sudoku.application resulted in exception. Following failure messages were detected: + The application binding data format is invalid. (Exception from HRESULT: 0x800736B2) COMPONENT STORE TRANSACTION FAILURE SUMMARY No transaction error was detected. WARNINGS There were no warnings during this operation. OPERATION PROGRESS STATUS * [11/03/2008 7:42:47 PM] : Activation of C:\Documents and Settings\Pete\My Documents\Visual Studio 2008\Projects\Sudoku\Sudoku\publish\Sudoku.application has started. ERROR DETAILS Following errors were detected during this operation. * [11/03/2008 7:42:47 PM] System.Runtime.InteropServices.COMException - The application binding data format is invalid. (Exception from HRESULT: 0x800736B2) - Source: System.Deployment - Stack trace: at System.Deployment.Internal.Isolation.IStore.GetAssemblyInformation(UInt32 Flags, IDefinitionIdentity DefinitionIdentity, Guid& riid) at System.Deployment.Internal.Isolation.Store.GetAssemblyManifest(UInt32 Flags, IDefinitionIdentity DefinitionIdentity) at System.Deployment.Application.ComponentStore.GetSubscriptionStateInternal(DefinitionIdentity subId) at System.Deployment.Application.SubscriptionStore.GetSubscriptionStateInternal(SubscriptionState subState) at System.Deployment.Application.SubscriptionStore.CheckAndReferenceApplication(SubscriptionState subState, DefinitionAppId appId, Int64 transactionId) at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation) at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options) at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension) at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state) COMPONENT STORE TRANSACTION DETAILS No transaction information is available. Tag: Excel in Office 2007 Tag: 228640
 - 23
 - Internationalization Support in 3.5 - What's New? I'm preparing for a major ASP.NET development effort that will require extensive internationalization support. I have a bunch of resources and I'm happy with those - with the exception that they cover the 2.0 version of the .NET Framework. I would appreciate it if someone could point me to some online resource that describes "what's new with internationalization" in .NET 3.5. And yes, I'm clear on the fact that 3.5 is additive to 2.0 and so the 2.0 features are still "current.". I'm just wanting to ensure that I'm not missing anything new (to the 3.5 bits regarding internationalization) before I finalize my design. Oh, and google proved unhelplful - or at least I failed to enter whatever search term(s) would return what I'm specifically looking for. Thanks. Tag: Excel in Office 2007 Tag: 228638
 - 24
 - .NET VB WinForms reference to the class Hi, In C++, if there's a class named clsMyForm, which has a static ("shared" in VB.NET) member variable named "Total" , and an instance (object) of the class named oMyForm, the static member of the class, can be referenced thru the instance as follows: oMyForm::clsMyForm.Total In VB .NET, if I have a Windows Form class named clsMyForm, which has a shared member variable named "Total" , and an instance of the class named oMyForm, how do I reference the shared members of the class thru the instance oMyForm? Thanks in advance, Rick Tag: Excel in Office 2007 Tag: 228634
 - 25
 - Desktop will not display shortcuts I down loaded and installed iTunes update. Noted that it took a long time to "finalize". When finished iTunes shortcut had disapeared. When I restarted computer all shortcuts were gone from desktop. Restore function will not restore to any point prior to install. Shortcuts sent to desktop do not appear. Any ideas? -- RFP Tag: Excel in Office 2007 Tag: 228633
- Next
 - 1
 - Error "Extensibility DTE object unavailable" When I open my Visual Studio 2005 for C#.NET, and when I double-click on a Form, the error pops up: "Extensibility DTE object unavailable." Below are messages under the error: at EnvDTE.Project.get_DTE() at Microsoft.VisualStudio.Design.Toolbox.ProjectAutoToolboxManager..ctor(AutoToolboxManagerService ownerService, IServiceProvider provider, IVsHierarchy hierarchy, Boolean& keepMe) at Microsoft.VisualStudio.Design.Toolbox.AutoToolboxManagerService.GetAutoToolboxManager(Object vsHierarchy) at Microsoft.VisualStudio.Design.Toolbox.AutoToolboxManagerService.GetAutoToolboxManagerFromHost(IDesignerHost host) at Microsoft.VisualStudio.Design.Toolbox.AutoToolboxManagerService.OnDesignerLoadComplete(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.ComponentModel.Design.DesignerHost.OnLoadComplete(EventArgs e) at System.ComponentModel.Design.DesignerHost.System.ComponentModel.Design.Serialization.IDesignerLoaderHost.EndLoad(String rootClassName, Boolean successful, ICollection errorCollection) at System.ComponentModel.Design.Serialization.BasicDesignerLoader.OnEndLoad(Boolean successful, ICollection errors) at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.OnEndLoad(Boolean successful, ICollection errors) at System.ComponentModel.Design.Serialization.BasicDesignerLoader.System.ComponentModel.Design.Serialization.IDesignerLoaderService.DependentLoadComplete(Boolean successful, ICollection errorCollection) at System.ComponentModel.Design.Serialization.BasicDesignerLoader.BeginLoad(IDesignerLoaderHost host) at System.ComponentModel.Design.DesignerHost.BeginLoad(DesignerLoader loader) Anyone could advise me on what to do to get this fixed? Tag: Excel in Office 2007 Tag: 228632
 - 2
 - how to end a thread without an exception? I have a thread that ends with system.threading.thread.currentThread.Abort() method.. . but, it throws me an exception.. is there any other way to end a thread? Tag: Excel in Office 2007 Tag: 228627
 - 3
 - Associate .SLN with Visual 2005 not 2003 When i doubleclick on an .SLN file it attempts to open up the solution in Visual Studio 2003. Is there a way to change the default so it will automatically open the solution in 2005? Thanks, John Tag: Excel in Office 2007 Tag: 228626
 - 4
 - Server Replication Software: What are folks using? It's that time of the year again where we get annoyed with our internal product and hope to find something newer and better out there. Alas, we usually don't find anything. The scenario: We use a home-grown .net CMS product that we've built in a staging/live server enviornment. We have one staging server and 2 live, load-balanced servers. Most web content is in the DB and migrated in a workflow manner from staging to the public. However, documents and images need to be replicated via the filesystem. We've been using repliweb for years. And it works. Usually. But it's termpemental, and can often go down seemingly randomly. The bigger issue we have is its rather obtuse interface. Is anyone familiar/using any other server replication software? Any recommendations? Any newer products out there? -Darrel Tag: Excel in Office 2007 Tag: 228624
 - 5
 - SmtpClient.UseDefaultCredentials does not work in Authenticated SM I use SmtpClient to send email in my program, and I set the UserDefaultCredentials to true to use the logged on user's credentials. However it doesn't work on authenticated SMTP server. It will throws exception saying 'System.Net.Mail.SmtpException: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.3 Client was not authenticated' However if I set UserDefaultCredentials to false and hard-coded my login and password for SmtpClient.Credentials, it works. It seems as if the UseDefaultCredentials does not set loggon user's credentials correctly. Any help would really appreciated. Vik Tag: Excel in Office 2007 Tag: 228623
 - 6
 - CLR doesn't do warm start? Hi, As this article (http://msdn2.microsoft.com/en-us/magazine/cc163655.aspx) mentions, there is a cold and warm start time for managed apps. I'm running a few .net 2.0 winforms apps on my desktop (XP) and until last week, I had the expected cold followed by warm time. Now, my cold and "warm" times are about identical. I don't know what changed. It could be something else that's running in memory and being a hog, but I'm wondering if there is some CLR switch that says "disable warm starts" that I can look at? Thanks... -Ben Tag: Excel in Office 2007 Tag: 228618
 - 7
 - connect to paradox db from sqlserver database table how to write data from data set in dotnet to paradox database in c# In this code from Archive Sql Server database, Table named:tmsarcdata I want all the details from tmsarcdata table to move to paradox database My paradox database path is: =@"D:\\ArchiveBase\\CDFilesa" This is the code I tried,but did not work: private void button1_Click(object sender, System.EventArgs e) { try { string pPath=@"D:\\ArchiveBase\\CDFilesa"; string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+pPath+";Extended Properties=Paradox 5.x;"; string command="select * from tmsarcdata"; OleDbCommand mCommand = new OleDbCommand(); OleDbConnection mConnection=new OleDbConnection(strConnection); mConnection.Open(); mCommand.CommandText=command; mCommand.ExecuteNonQuery(); } catch(System.Exception Ex) { //Ex.Message; } } Please help..... Tag: Excel in Office 2007 Tag: 228613
 - 8
 - \\servername\sharename is unavailable Lately we get the problem on our server that it cannot reach the backupserver by \\servename\sharename, but when we use \\IP-adress\sharename it is no prblem. When we ping the backupserver we get the right IP-adres back. After reboot of the server the problem is gone for a while, but returns everytime. We use Windows Server 2003 Standard Edition SP2 Harry Veenkamp Villeroy & Boch Wellness Bv Tag: Excel in Office 2007 Tag: 228612
 - 9
 - trying to print smaller picture Hi - I have a picture that is 8.5 x 11 and I need to print it to a smaller size and centered on the page. Any idea how to do this? Thanks - -- Heather Tag: Excel in Office 2007 Tag: 228611
 - 10
 - DOWNLOADED ITUNES BUT CANNOT RUN I DOWNLOADED ITUNES THE DOWN LOAD WAS SUCCESFUL BUT I HAVE ERROR MESSAGE WHICH SAYS '' ITUNES ENCOUNTED PROBLEM AND CANNOT START. Tag: Excel in Office 2007 Tag: 228610
 - 11
 - Live One Care Restore When I restore a backup from some earlier time, do I lose work that has been saved since the backup? -- bazzandjo Tag: Excel in Office 2007 Tag: 228608
 - 12
 - www.dotnetvideos.net releases 10 New video Tutorials Hi all, www.dotnetvideos.net released 10 new videos on the following category. every registered user of this site still gets a FREE subscription to asp.netPRO magazine. chek it out!! An Overview of Editing and Deleting Data in the DataList (7 Videos) at http://www.dotnetvideos.net/OverviewofEditingDeletinginDList/tabid/127/Default.aspx Performing Batch Updates (3 Videos) at http://www.dotnetvideos.net/PerformingBatchUpdates/tabid/128/Default.aspx ---venkat Tag: Excel in Office 2007 Tag: 228604
 - 13
 - Property Set procedure with a structure array Apologies in advance for what is a very simple question, but I just cannot get my head around it. I have a public class Something with a public structure T mapped to the local variable m_Test(). Whenever I try to set the value of the property Test, I get the error "Expression is a value and therefore cannot be the target of an assignment." Test code is below. Can anyone tell me what I'm doing wrong? Public Class Something Public Structure T Public a As Integer Public b As Integer End Structure Private m_Test() As T Private m_CurrentIndex As Integer Public Property CurrentIndex() As Integer Get Return m_CurrentIndex End Get Set(ByVal Value As Integer) m_CurrentIndex = Value If Value > m_Test.GetLength(0) - 1 Then ReDim Preserve m_Test(Value) End If End Set End Property Public Property Test() As T Get Return m_Test(m_CurrentIndex) End Get Set(ByVal Value As T) m_Test(m_CurrentIndex).a = Value.a m_Test(m_CurrentIndex).b = Value.b End Set End Property End Class Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim s As Something s.CurrentIndex = 1 s.Test.a = 2 '* Error!!! End Sub End Class Tag: Excel in Office 2007 Tag: 228603
 - 14
 - convert int to numeric (formatted) string vs2005 c# hi: need to convert a simple int to a format nnnn. if I have int 1 I want the result to be padded with 0s as 0001 on a string I have int 1 and I want "0001" any help. Thanks so far these dont work field.ToString("nnnn") or field.ToString("####") Tag: Excel in Office 2007 Tag: 228600
 - 15
 - Environment.GetFolderPath returns wrong path I have an application that during installation access the My Documents path. I am using Environment.GetFolderPath( Environment.SpecialFolder.MyDocuments) + restOfPath ) to get the path to the file in question. This works fine most of the time. The only time it fails is when the My Documents is recirected using group policy. In this case, the method continues to return a local path instead of the correct network path. Does anyone know a way around this issue? Tag: Excel in Office 2007 Tag: 228599
 - 16
 - .net windows service using alot of Paged pool Hi We have a windows service implemented in C# that will call some legacy VB6 COM objects. This is a memory intensive application that will create alot of objects but looking at the memory and virtual memory footprint it will remain under the 70meg level. On the other hand the Paged pool will keep going up and up. What would be the cause of this? Tag: Excel in Office 2007 Tag: 228598
 - 17
 - Tool To Create Function Map Of C#.NET Project In Visual Studio 200 I've been assigned to an existing project to assist with some customization requirements, but most of the documententation is in Japanese and very lacking in useful pictures or diagrams. What I'd like to do is create a function map which includes a list of which assemblies/members contain a call to another assembly/member, or reference, or method, or whatever-they-are-called. That way, if I see something like SecurityManager.ChangeBilingalMode (sic), I have some clue as to where that call originated. Is there something included with VS2005 that does this, or maybe one of the Office 2007 products? Tag: Excel in Office 2007 Tag: 228593
 - 18
 - How microsoft supose that we build website with SilverLight? Microsoft say cross platforms... your website visitors can wait for Moonlight.. you remember the Mono? who is use with VS2005/2008 to create App for Mono?! continue believe to microsoft.. Tag: Excel in Office 2007 Tag: 228579
 - 19
 - How Do I INsert Numbers Into a Raffle Ticket Template I have downloaded a template to create raffle tickets and I want to avoid having to manually type in the ticket numbers. Can I input the numbers into an Excel spreadsheet and then merge with the Word document? Or can I actually input a formula in Word to assign ticket numbers? Tag: Excel in Office 2007 Tag: 228577
 - 20
 - xmirage caused invalid page fault everytime i open this certain program i get xmirage caused invalid page fault in module 32 dll atd67 bff88396. can someone please help with this Tag: Excel in Office 2007 Tag: 228575
 - 21
 - DLLs and Embedded Resources Hi, I was designing an application which is intended to run in the background, and I was wondering about how I should load my resources to reduce the memory footprint. I was thinking of keeping all the embedded resources in a DLL, so that they only get loaded when needed. So my question is this: if your application references a library, does the library get loaded into memory at startup, or only when its used? There really isn't much point in keeping the resources seperate otherwise, since it complicates the code slightly. Thanks for your help. Tag: Excel in Office 2007 Tag: 228569
 - 22
 - Low Refresh Rate I using a new laptop running Vista and have Nvidia GeForce 7600 graphics card. I'm trying to connect my TV to this computer using Svideo. It has worked in the past however I must have changed a setting somewhere? On my second computer with Xp it all connects right! So it's all connected but the display on the TV is just rolling lines as though it is scrambled. On the monitor setting, the refresh rate is stuck on 25Hertz Interlaced. Is there a way of forcing a higher refresh rate? or is there another setting I need to change? I have been seraching for months for an answer to this question. HELP PLEASE! Tag: Excel in Office 2007 Tag: 228567
 - 23
 - google adsense website for sale <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> Dear friends, Earn from google adsense. A complete ready made google adsense website package for sale @ Rs. 1000 only. 100 Content Rich Adsense Web Sites containing more than 16000 web pages for Rs. 1000/only. <A href="http://www.googlead.xtreemhost.com/">click here </A>for sample website </BODY> </HTML> Tag: Excel in Office 2007 Tag: 228564
 - 24
 - Typed datasets and table table adapters components not showing in Typed datasets and table table adapters components not showing in Toolbox Hi, I have a solution with several projects. One project contains datasets with table adapters. When I opened a usercontrol in design mode, it used to have all datasets and tableadapters in toolbox, under a tab name with the name of the datasets project However, I had to upgrate to a new hdd, and did a clean Windows install, with VS2005, etc Now, when I open te solution and open a usercontrol in designer, I see only the other user controls, but no datasets or table adapters as I used to have before. Sometimes I see a tab with the name of the datasets project, but on it there is a text telling "There are no usable controls in this group" What happend? I mention, on old HDD I had instaled VS2003 and VS2005, on new one I have only VS2005 and installed VS2008 express, but then I removed it (as I thought maybe it caused the issue). I even uninstalled and reinstalled VS 2005, with no luck. Can anyone helo me with this? Thank you Tag: Excel in Office 2007 Tag: 228563
 - 25
 - System.ServiceProcess This class is not showing up in C# Visual Studio Express Any ideas? Is this class antiquated? Tag: Excel in Office 2007 Tag: 228559

I have a problem with Excel in Office 2007. When I click on a .xls file,
Excel program opens but not the file required. I don't even get an Excel
page, simply the light blue screen of Excel. I have to manually open the
xls. files I need. Any ideas as to what could be causing this? I have tried
repairing Excel from the Control Panel and also checking Tools, Options,
other applications, etc. So far no results. Thank you.

Top

Re: Excel in Office 2007 by RobinS

RobinS
Fri Mar 14 02:09:06 CDT 2008

Try posting to a group with "Office" in the description. This is a .Net
Programming General Discussion newsgroup.

RobinS.
GoldMail.com

"Trizia" <Trizia@discussions.microsoft.com> wrote in message
news:EFD08538-1E29-4B36-A469-664634F96695@microsoft.com...
>I have a problem with Excel in Office 2007. When I click on a .xls file,
> Excel program opens but not the file required. I don't even get an Excel
> page, simply the light blue screen of Excel. I have to manually open the
> xls. files I need. Any ideas as to what could be causing this? I have
> tried
> repairing Excel from the Control Panel and also checking Tools, Options,
> other applications, etc. So far no results. Thank you.

Top