|
What are you using to open the files?
Use Process.Start to make the system choose the registered program for each file type to open it.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hello everyone. I am new to VB and its a little different to embedded C that I am used to. I am trying to write some macros in Excel to automate some of my business practice. Here is a piece of code that is giving me grief at the moment.
For i = 1 To 500
If Worksheets("Prices").Cells(i, 7) = 2 Then
Sheets(5).Cells(1, i) = Sheets(1).Cells(i, 1)
End If
Next i
Trying to get that code to copy one cell to another if the statement above is true. The i is defined as an integer (global).
The compiler spits it at this line. All the code before this runs fine...
Sheets(5).Cells(1, i) = Sheets(1).Cells(i, 1)
Can anyone tell me what the problem is? I would assume its very easy to solve, just cant see what im doing wrong and I cant find info on the net.
Thanks in advance.
~Todd
|
|
|
|
|
Try appending .Value to eaceh cell object:
Sheets(5).Cells(1,i).Value = Sheets(1).Cells(i,1).Value
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I had one file template type "file_1.xls".
I need open file this and insert data in sheet of file. But at present because of me haven't been processed.
Can you help me and give a examples to me ?
|
|
|
|
|
You can use ODBC connection for that. By using Transact SQL command like UPDATE or INSERT you will be able to print in Excel file. You can search web for an appropriate ODBC connection to a file code.
B.B.
|
|
|
|
|
|
I had one file template type "file_1.xls".
I need open file this and insert data in sheet of file. But at present because of me haven't been processed.
Can you hepl me and give a examples to me ?
|
|
|
|
|
Hi,
Is it possible to programmatically add menu items and sub menus at run time?
I want to read in the contents of a database when my form is loaded, and add two of the database columns to my menu strip.
At design time, I've added a "View" menu. One of the options beneath it is, "Filter 1", and another is "Filter 2".
I want the column 0 contents of my database to populate a sub menu off the "Filter 1" option, and my column 1 contents to populate a sub menu off "Filter 2".
I'm using VB.NET 2005 Express.
|
|
|
|
|
Yes,
You have to define a new MenuItem object and then add it to another MenuItems items collection. You then also have to enable the required event handlers.
|
|
|
|
|
I have this
Dim img As Image = Image.FromFile("c:\Pics\Frame.gif")
Now how do I place it on the form?
|
|
|
|
|
You would have to use a picture box, like so:
<br />
Dim PicBox As New PictureBox<br />
PicBox.ImageLocation = "c:\Pics\Frame.gif"<br />
Me.Controls.Add(PicBox)<br />
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
A picture box is second easiest, easiest is to set the background image property of the form to the image, but that is harder to control if you don't want it over the entire form. You get the most control by drawing it yourself in a paint message handler.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thanks for that,
You get the most control by drawing it yourself in a paint message handler.
Just need to go and find out how.
|
|
|
|
|
I am trying to get the DataGridView to show a Column Selected. I want the user to be able to select a column and capture the index to that column??
|
|
|
|
|
You have to deal with DataGridTableStyle and DataGridColumnStyle. Useful hints here [^]
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
i have two forms say form1 and form2...
on clicking button1 on form1 , form2 gets open...
form2 has 2 two buttons back and close
i have dne coding in this way:
form1 :
button1_click event
dim a as new form2
a.show()
me.hide()
form2:
for close button
me.close()
my problem is on clicking close buttton of form2, form2 gets close
but form1 which is already hidden doesnt close...
i want that wen i click close buttton all the hidden and active forms should close...
and debugging should stop..
thanks for any kind of help.
|
|
|
|
|
Change the Shutdown Mode in your project properties.
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
sorry i am not able to see any option in project property window...
can u explain a little bit more.....
|
|
|
|
|
manni_n wrote: sorry i am not able to see any option in project property window...
Are you using Visual Studio 2.0? If not, then just add Form1.close() to your close button on form2.
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
i am using VS 2003.
and about form1.close()
i have already used this one, its not working telling that refernce to non shares members need object refernce...
i am ussing me.close, but if i apply it on form2 then this works for form2 2 only , form1 still remains hidden..
|
|
|
|
|
manni_n wrote: i have already used this one, its not working telling that refernce to non shares members need object refernce...
It works fine for me. Could you post your full code for the Form2 close button?
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
there is no such great code involved in close button...
i have jst used like...
button2_click()
me.close()
end sub
thats it...
and if i also write form1.close
then its shows the error i told u in previous post....
you do one thing just tell me your way, i'll implement that method...
i just want to close all forms whenevr close button is clicked..
whether its on form2 or any other form say next form form3 or form4.
|
|
|
|
|
Alright, just to make sure, goto your project properties (Project Name Properties). Click Application, from there, you should have an option that says Shutdown Mode (or something similar). If there's no such option, then try the following:
<br />
Dim x As Integer<br />
For x = 0 To (Me.OwnedForms.Length) - 1<br />
Me.OwnedForms(x).Close()<br />
Next x<br />
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
Give this a try. What I've done is added a handler for the child forms formclosed event. This way we know when the child is closed and can close too.
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim a As New Form1
'Register our method (ChildClosed) with the new forms FormClosed event
AddHandler a.FormClosed, AddressOf ChildClosed
a.Show()
End Sub
'When the child closes this method will run which will close the current form
Private Sub ChildClosed(ByVal sender As System.Object, ByVal e As System.Windows.Forms.FormClosedEventArgs)
Me.Close()
End Sub
End Class
***EDIT***
Also what are you doing to go back?
**EDIT2***
Oh, ya. You can also just use 'End' or 'Application.exit' to shutdown everything. I forgot about the easy answer 
|
|
|
|
|
yeah this End and application.exit are working...
well to go back i am coding like this..
suppose i am on form 2 and button "back"
in back_click
dim a as new form1
me.close() ' to close the existing form
a.show()
here thing is a new form1 gets open by this method...
what if i want same form1 which is hidden...??
any idea.?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
