|
Hi
I need to save an Excel file as (Excel 97-2003)
For the code below, I have a reference to Microsoft Excel 12.0 Object Library, which I assume is for Excel 2007.
When I open a workbook saved as below, I get an error message saying the workbook is not in the expected format.
Previously I used a reference to Excel 10.0 which worked fine, but I cannot find that anymore when adding references.
I guess I have two choices:
a) How do I reference Excel 10.0 Object Library?
or
b) In the code below, what do I replace "FileFormat As Object" with to specify that the file must be saved as an older Version?
Private Sub ExportExcel()<br />
Dim xlApp As New Excel.Application<br />
Dim xlBook As Excel.Workbook<br />
xlBook = xlApp.Workbooks.Add<br />
<br />
'Write stuff to book here...<br />
<br />
xlBook.SaveAs("MyBook.xls", "FileFormat As Object")<br />
xlBook.Close()<br />
xlBook = Nothing<br />
xlApp.Quit()<br />
xlApp = Nothing<br />
GC.Collect()<br />
End Sub
|
|
|
|
|
Found my answer...
Use one of the Interop.Excel.XlFileFormat formats
Interop.Excel.XlFileFormat.xlExcel8 seems to work fine
|
|
|
|
|
Hi,
As the title says, How do I create, use and interact with windows services in VB.NET 2005?
Links, examples, tips , tutorials.. all welcome.
Thanks!
|
|
|
|
|
www.Google.com
This will realy Help
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi,
Let me explain step by step,
First: I have a file which gives details of a user as., FName, MName, LName, Address, TestDate, TestResult etc...
Second: I have to import this file and store it in Data Base. And assiagn a unique number to each user.
I am maintaining a Database where candidate details and test details are stored in separate tables using the unique id i created as the key.
Third: If this user to whom i had already assaigned a unique number, will take another test. And again the data is send in the same format (FName, MName, LName, Address, TestDate, TestResult etc...).
Forth: This file does not have any number or a unique field which can differentiate one user with other.
Fifth: In this case i have to only input the test details and not the candidate details as the user is already holding a unique id.
Question 1: How can i differentiate the users from one to another.
Question 2: How can i check wheather the user candidate data is already in the database or not. As generally different users do have same name and common addresses which are very irrelavent to check.
Jats
modified on Friday, January 18, 2008 6:50:00 AM
|
|
|
|
|
Jats_4ru wrote: As generally different users do have same name and common addresses which are very irrelavent to check.
If different users really have the same name and the same address, then you don't have enough information to determine if a user already exists in the database or not.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
i created a new class (called clabel), inherited from label and in this class i override the label's-textproperty :
shared MyText as string
public overrides property text() as string
get
mytext
end get
Set(ByVal Value As string)
mytext= value
end set
end property
in my form's load-event i dynamically added now a number of these new custom-labels, like this:
dim i as integer
for i = 0 to 10
mylabel = new clabel
with mylabel
'size, location...
.text = i
end with
me.controls.add(mylabel)
next i
now i would expect to show each label in its text-property a different number, from 0 to 10.
but they all show the same (highest) number, in this case "10".
why?
|
|
|
|
|
It is simply because you are using a shared (static) variable MyText to store and return value of Text property.
Please know that shared (static) variable is a variable which has just one instance which is shared by all instances of objects.
Therefore text property of your all clabel objects will always have same value because they all are pointing to the same MyText variable, and this value will be value last set for MyText, which in this case if 10.
Declare MyText as a Private string variable and your issue will be resolved.
I hope this help  .
-Dave.
Dave Traister,
ComponentOne LLC.
www.componentone.com
modified on Friday, January 18, 2008 7:50:10 AM
|
|
|
|
|
I have used a webbrowser control to navigate to a site. I have extracted the HTML source code of the site and filtered the links in it. I want to navigate to the links one by one. But it is using somekind of internal functions to link to everypage and every link has got the same link text.
can anybody tell how can i actually simulate like clicking on every link that is in the page through vb.net 2005 using webbrowser control.
thanks a lot in advance.
|
|
|
|
|
How can i convert an rgb image to an YCrCb image??? is there any builtin function for it in .net?? or any other easy way out?
(Jameel)
|
|
|
|
|
Where do you hope to use this image ? .NET ( and Windows in general ) can do nothing with it, so the framework isn't going to help you. You'd need to get a library for a format that uses YCrCb.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi,
there are some color model conversion articles on CP, here is one of the better ones[^] but I am not sure the one you need is in there.
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
Hello all,
I am writing a dll in VB6.0.
I have another dll in VC.NET.
I want the communication between these 2 dll.
I've used VB's dll in VC.NET successfully(Using Interfaces).
Now I want VB's dll to send messages to VC.NET dll using SendMessage API.
How can I do that?
Or is there any other way by which this task can be done?
Please advise.
Thanks in Advance.
ritz1234
|
|
|
|
|
hi guys
can any one suggest me any best microsoft's free application virtualization software like thinstall,
any weblink, ? hint?
thanks in advance
hello
|
|
|
|
|
What does this have to do with VB.NET?
|
|
|
|
|
Does your inquiry have anything to do with VB.NET or you just dumping a post in a random forum?
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
it is related to vb.net,
i want to by pass cas so i want a virtual software like thinstall to deploy my application .
or can you help me regarding group policy on enterprise level ?
hello
|
|
|
|
|
I tried to use the following code to pass 1-D array value to 2-D array. This code works, but I wonder if there is a more efficient way to implement this. Thanks.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim i As Integer = 0
Dim DeltaGamma As Double = 0.3
Dim DeltaTapPoint As Double = 3
Dim DACArray() As Double = New Double() {1, 3, 5, 7, 9}
Dim NewArray(5, 4) As Double
Do While DeltaGamma > 0.1 And DeltaTapPoint > 2.0
For j = 0 To 4
NewArray(i, j) = DACArray(j)
Next
ProcessArray(DACArray)
i += 1
If i > 5 Then
DeltaGamma = 0.1
DeltaTapPoint = 2
End If
Loop
End Sub
Public Sub ProcessArray(ByRef array() As Double)
Dim j As Integer
For j = 0 To 4
array(j) *= 2
Next
End Sub
|
|
|
|
|
Don't think you can get more efficient than that. Unless you do some loop unrolling...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi!
I am populating the treeview on fly from database. I am trying to maintain the selected state of a tree node (either parent or child). select node in parent works fine but when i try to find a child node i get null reference exception. can someone please tell me how i could select the child node.
thanks
|
|
|
|
|
uglyeyes wrote: select node in parent works fine but when i try to find a child node i get null reference exception. can someone please tell me how i could select the child node.
Have you set breakpoints in your code, and then looked at data in your objects? This will do wonders, it will let you see if the data in your objects/variables are what you were expecting. Without more detail, such as what you tried, detailed expection info, or some code, that's the best I can offer. I left my crystal ball at home.
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
yes i did set up breakpoint.
If Not Session("locationid") Is Nothing Then --> when they select a node i am storing the value of selected node in session
Debug.WriteLine(Session("locationid"))
'Debug.WriteLine(tvProperty.SelectedNode.Value)--> prints value of the node
tn = Me.tvProperty.FindNode(Session("locationid"))--> where i get null ref exception
tn.Selected = True
End If
please note it didnt throw exception when i navigate between parent nodes.
its only happening when i navigate between child nodes.
in findnode do i need to give ref of parent, path seperator etc?
|
|
|
|
|
can anyone please help me?
|
|
|
|
|
i posted too early without doing any research. i should have used valuepath in session instead of just value to get the selected child node selected.
|
|
|
|
|
My question is this...
I am trying to change a column of a datagrid to a drop down combo box. I set everything up but my problem is that I am displaying a list of text in my combobox ("Preparer", "Reviewer", "Approver") I need to set the values of these items to 1, 2, 3. I don't want the program to recognize the string representation of the items but their enumerated values. How do I achieve this?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
