I have an application that uses Excel 2003. How can I know what is the version of Excel in the end user? Is there any way I can find it out when the program starts? Thank you in advance

Hi to everybody I use Visual Studio 2005. I have an MDI form and when I open child forms I want their instances to be entered in a ToolStripMenu named Windows. For example when I will open Childform1 and Childform2 I want the dropdownitems of Windows ToolStripMenu to be Childform 1 and Childform 2. When I click to Childform 1 I want to show the Childform1 and when I click to Childform 2 to show the Childform2 and to hide (the other one). I can create the Items (runtime) but I cannot handle the click event since the object has been created runtime. Do you have any idea how to do it, or how to handle events of objects that has been created runtime.

Hi there I am using VB .NET (2005) and I created a project that exports some data to Excel. I would like to assure that my project will be functioning for all the versions of Office (excel) of the end user. For example I use Office 2003. If I install my application to PC that uses an older version of Office, lets say Office 2000, will it work correct? If no, do you have any solution for that? Are there any libraries that will resolve the problem? Thank you in advance -- modified at 11:20 Monday 29th January, 2007

I created a DLL in VB .NET and I want to use it in an excel application, but I cannot create a reference to it. Is there any other way to use it in Excel Application? Thank you in advance

Hi everybody Does anyone know how can I design my report in landscape mode. I don't know how can I enlarge the margins of my Report. Thanks in Advance

Use the following code I hope it is helping Dim col As Integer = Me.datagrid1.CurrentCell.ColumnNumber MsgBox(Me.DataGridTableStyle1.GridColumnStyles.Item(col).HeaderText)

I want to prevet users from errors Should I use "On Error goto" statement or "Try catch end try" block. Although i dont want my program to rum slower due to error handling. Do you know which method is faster? Thanks in advance

I am using PrintDocument Class in order to print a txt file, but I am getting the following exception "RPC server is unavailable" Can anybody help me. Propose other methods to print the txt file, if you can. Thanks in advance

I want to dispaly my boolean variables in my crystal report in checkboxes checked or unchecked. Do you have an idea how i can accomplish it. Thank you in advance

Try the command Format Here dt is a datetimepicker control Format(Me.dt.Value, "d/MMM/yyyy")

I have CrystalReport TextObject and I want to assing in its text property a string variable. My string variable is created with the code: For i = 0 To n-1 str1 = str1 & i + 1 & ". " & vbnewline Next My problem is that I cannot display the string in the textobject as it is. Although I use the vbnewline (enter) the textobject is displaying the string in one row. Could you please help me. Thanks in advance

Use the following Code. Put an AsciiFile.txt with the data 2 4 3 40 42 56 in the applications path Imports System.IO Public Class Form1 Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents Button1 As System.Windows.Forms.Button Friend WithEvents ListView1 As System.Windows.Forms.ListView Friend WithEvents ColumnHeader1 As System.Windows.Forms.ColumnHeader Friend WithEvents ColumnHeader2 As System.Windows.Forms.ColumnHeader Private Sub InitializeComponent() Me.Button1 = New System.Windows.Forms.Button Me.ListView1 = New System.Windows.Forms.ListView Me.ColumnHeader1 = New System.Windows.Forms.ColumnHeader Me.ColumnHeader2 = New System.Windows.Forms.ColumnHeader Me.SuspendLayout() ' 'Button1 ' Me.Button1.Location = New System.Drawing.Point(200, 232) Me.Button1.Name = "Button1" Me.Button1.TabIndex = 0 Me.Button1.Text = "Button1" ' 'ListView1 ' Me.ListView1.Columns.AddRange(New System.Windows.Forms.ColumnHeader() {Me.ColumnHeader1, Me.ColumnHeader2}) Me.ListView1.Location = New System.Drawing.Point(8, 8) Me.ListView1.Name = "ListView1" Me.ListView1.Size = New System.Drawing.Size(264, 192) Me.ListView1.TabIndex = 1 Me.ListView1.View = System.Windows.Forms.View.Details ' 'ColumnHeader1 ' Me.ColumnHeader1.Width = 120 ' 'ColumnHeader2 ' Me.ColumnHeader2.Width = 135 ' 'Form1

In my VB .NET project I use Access 2003 method ImportXML and ExportXML. Is there any way that I could still use these methods without having Access 2003 installed? Could I install only some dlls in order to achieve this