|
Dont know if this will help any but I used to Hyperlink thousands of cells down column A with a loop.
Here is a piece.
ActiveSheet.Hyperlink.Add Anchor:=Sheet1.cells(a,1), _
Address:=Sheet1.cells(a,1).value, _
TextToDiaplay:=Sheet1.cells(a,1).value
Then it would loop to A2, A3 and so on down the line till it errored cause I did not know how to stop the loop. (a,1) is column A and row 1, I think, maybe first row and column 1. I think row is mentioned before column???
This stated whatever text was in cell A1, hyperlink it, yes in my case it was a web address, this was several years ago. Now I use a third party macro recorder, not VBA, and it double clicks on the cell as you mentioned and creates the hyperlink through its double click leftmouseclick code.
Hope the snippit above gives you an idea, check the help file if needed.
|
|
|
|
|
Hi I'm using the following code to create an outlook mail message, but need to bold and undeline certain lines in the message body. How can I do this?
<br />
Dim oOutlook As New Outlook.Application<br />
Dim oMailitem As Outlook.MailItem<br />
<br />
oMailitem = CType(oOutlook.CreateItem(Outlook.OlItemType.olMailItem), Outlook.MailItem)<br />
oMailitem.To = "<name@domain.com>"<br />
oMailitem.Subject = "Order Request"<br />
Dim MailBody As String = "Hi," _<br />
& ControlChars.NewLine _<br />
& "Please could you place orders as per the requirement below" _<br />
& ControlChars.NewLine _<br />
& "I WANT THIS LINE BOLD....." _<br />
& ControlChars.NewLine _<br />
& "Thanks!!"<br />
|
|
|
|
|
Hmmm I havent tried this yet but here are some suggestions:
If the users are recieving the mail as html you could use html tags in you msg.Body
Or since outlook uses word as its email editor - open up word (in code and see what functionality this offers you)
Hope these pointers help
If i get time to look into this i shall try them and let you know my results
Dan
|
|
|
|
|
How can i write a code to edit data from a textbox in a datagrid in vb.net
|
|
|
|
|
Explain more if you want to gat an answer
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles Button1.Click
End Sub
Explain meaning of this code line below on button click event-->>>
(ByVal sender As System.Object,ByVal e As System.EventArgs)
Nitin Jenwal
-- modified at 7:10 Monday 11th June, 2007
|
|
|
|
|
google broken where you live ?
The sender is the control that raised the event. EventArgs is useless by itself, but provides a base class for event args that actually contain information about an event, such as the key that was pressed, or the mouse location.
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 )
|
|
|
|
|
Thnx Great
But Are we writing it as Byval
Nitin Jenwal
|
|
|
|
|
Basically because you are not going to make any changes to the values passed.
Remember that ByVal is if you are going to view the data or move it to someplace to do some work on it. ByRef is when you want to make a change to the data in that variable.
Tom Wright
tawright915@gmail.com
|
|
|
|
|
I am adding an item to a listview from a textbox on a button click. when i add some number of items, i am not able to view the recently added item in the listview. Vertical scrollbar is present but it doesnt automatically scroll to display the recently added item. Does anyone have a solution for this?
|
|
|
|
|
|
Means items are added but you are not able to view them ???
-koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Thanks a lot for the help...i could finally see the recently added item using EnsureVisible property of the listview
|
|
|
|
|
Hi,
In my application I have:
1 MDI (MDIParent1)
2 Forms (frm1 and frm2)
1 Module (module1)
In MDIParent1 I have the foolowing code:
Sub New()
InitializeComponent()
Dim f1 As New frm1: f1.MdiParent = Me : f1.Close()
Dim f2 As New frm2: f2.MdiParent = Me : f2.Close()
end sub
I would like to init module1 too like I done for frm1 and frm2 because when
I am calling a function that is in the module I get an error:
"The type initializer for 'ApplicationName.Module1' threw an exception."
In addition (in the add watch during debug):
"reference to a non-shared member requires an object"
Please help
Eric H.
|
|
|
|
|
hi am new in Vb.Net, i need a Site where i can Download free VB.Net E-books,
Thannks
Vuyiswa
|
|
|
|
|
Hi
check this site www.4shared.com
Harini
|
|
|
|
|
Harini Thanks man , but the Site is not Accessable in my work place, can you provide another site, i will access this site when i get home and Download the Books
Vuyiswa
|
|
|
|
|
They are usually illegal. Just bite the bullet and buy a book.
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 )
|
|
|
|
|
i dont care how Illegal they are , i just want to learn
Vuyiswa
|
|
|
|
|
Then I hope you don't find the help you're lookng for. What you want to do is no different to shoplifting the book itself, or stealing a car. You're taking something that doesn't belong to you.
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 )
|
|
|
|
|
hey frnd,
tryout this
http://www.click-now.net/ebooks.htm
www.ebookshare.net
regards,
koolprasad2003
If the message is useful for U then please Rate This message...
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Thanks man am in, already Downloading
Thanks a Million
Vuyiswa
|
|
|
|
|
Hey Vuyiswamb you are in the Wrong Track.
For Knowing the Concepts better buy a book first and try to learn it and start practicing the Code.
Then only you can Learn.
Just downloading the Ebooks from the Internet will not help you while you were put in Application.
First of all learn all the concepts from the Book that will Help you in you Life and in your work also.
Regards,
Satips. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
I have a project created using MS Access Database and VB front end. I cannot add record thro' the front end though the underlying codes are absolutely fine. I have a save button whose action will lead to saving of the record but when i save my records,the codes get executed well without showing any problem but in the next part i find the save record is not found in the database. This is one of the strange thing i have ever experienced.
Please help me y the problem is so.
ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggdfsgdsfgfdsgfdsgfdsgfds d fgdsgfdgfds ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff
|
|
|
|
|
i had simmilar Problems too, but i had an Error. paste your code and let us see what you wrote in your save Button
Vuyiswa
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
