Search results for query: *

yes it is . But it doesn't work - exception: Old format or invalid type library

The problem is that I use Microsoft Excel 11.0 Object Library. And I use Office 2003

My bad the I placed from identical code which i wrote in C# my code in vb.net looks like this Dim xlApp As Excel.ApplicationClass Dim xlWb As Excel.WorkbookClass Dim xlSh As Excel.WorksheetClass xlApp = CreateObject("Excel.Application") xlApp.Visible =...

Hi! I have a problem. Probebly it is environment problem. I need to generate Excel report from my VB.net application. So, I connected the Excel refernce. On the line: [code] _Workbook workbook = workbooks.Add (XlWBATemplate.xlWBATWorksheet); [\code] program terminates and i have: Old format or...

In my case i thing the problem in the refernce I connect. I tried your code RonRepp but it doesn't solve the problem Actually I'm doing almost the same that you suggest(I also tried your code) but i still have the same: "Old format or invalid type library" exception at runtime Something...

I'm writing Dim xlApp As Excel.Application Dim xlWb As Excel.Workbook Dim xlSh As Excel.Worksheet xlApp = CreateObject("Excel.Application") xlWb = xlApp.Workbooks.Add() xlSh = xlWb.Item(1) xlSh.Name = "My Sheet"...

Sorry for stupid question. But How can I import Microsoft.Office.Interop,I don't know which file contains that component Please help

I'm doing something like this Dim xlApp as Excel.Application Dim xlWb as Excel.Workbook Dim xlS as Excel.Worksheet Set xlApp = CreateObject("Excel.Applicatio") xlApp.SheetsInNewWorkbook= 1 Set xlWB = xlApp.Worbook.Add Set xlS.name=rstTask!FullName ............................... Something...

Hi! I have a need to output my report data into MS Excel file. (Which should be generated at runtime.) I know how to do it in VBA 6.0. But I spent 3 hours and havent't done anything. Please help. I don't really care if it would be VB.net or C#.net Thank you in Advance

Hi! I need to form query which should search for the customers thu the base. The customer table contains many fields such as company name, contact person, location and others. All i need it to find if it is possible to have one parametrized query and use as if i had several queries. Example...

Hi! I have start up form in C#.net appl. and I need to store somewhere the parameters gathered in it. Global variables are for that but don't know how to set them and where to place code. Thank you fot your future tip. LB

Hi As I understand from your statement Your are modifying the string with the SQL query. I won't work that way. You should make parametrized query and set the parameter something like that: sql text: <code> SELECT * FROM Report WHERE ShiftID = ? </code> The code should be like this <code> Dim...

Thank you! My bad -- I used "PROCEDURE" but it should be "PROC". in MS Access queries. Probably it's a differnce of Truncated and ANSI SQL Thank You it was really helpful

I got a problem. I have MS Access DB. I'd like to use (access) MS Access DB queries in VBA.net (not rewrite them in my code). I scaned whole ado.net but all i found was info about implementing sql procedures from MS SQL, Oracle and others. MS Access can't work with sql procedures. Have any...

By the way I scaned MSDN and haven't anything in ADO.net about my problem. Maybe that is the problem in me. Help please Thank YOu Lyubomyr

Hi guys! I got some kind of problem. I have MS Access Database which hase tables and SQL queries. I have all types of queries: select, insert, delete. They also have parameters. I used to programme in VB6.0. It was simple to use the database and its queries in my VB6.0 applicatoin. But I...

In MS Access have databse where I formed a query. But I can't use it in my VB.NET application without writing the qurey in the code of this application. In VB6 in RecordSet was method Open where I could write the name of my query and connection. In VB.NET I can't find such method. Guys help it...

Thank You guys it helped!

I have form in MS Access 2003 also i have query which has parameter. So i need to pass values gathered from the form fields to the parmeter of the query. I have situation when it doesn't want to take values from form but call standart MsgBox with proposotions to input parameter Thank you in...

I found solution to that problem the line cout<<"Hello World"; should be replaced to std::cout<<"Hello World" This is new in VC++.net. In VC++6.0 it's simple 'course you just writing #inlcude <iostream.h> in stdafx.h and using cout<<"Hello World";