Hi,
How can I add a button to a specific cell of the excel using VBA.
The below line adds the button at any place.
Worksheets(1).O LEObjects.Add "Forms.CommandB utton.1"
But I want to add a button in 3rd row, 4th column, i.e. cell(3,4)
How can I do that??
tweety123
Last Activity: Jun 20 '07, 08:03 AM
Joined: Apr 24 '07
Location:
-
Adding Button in a cell of an excel
-
VBA books
Please suggest the good books easily available in market for VBA, considering that I have not much exposure to the language.
Also please provide the PDFs/online links if available with anyone for the same. -
I am working on a automation testing tool TEST PARTNER which uses VBA. Here there's a module called 'class module' where you can define a class along with its methods and properties. There's no option of Insert.
Need a sample code to create a new class. -
creating a new class
How do we create a class module in VBA.
Please provide a sample code. -
I have a code which returns whether the two documents are same or not:
...Code:Function fnCompWordDocs(strPathA, strPathB) Set objWord = CreateObject("Word.Application") Set A = objWord.Documents.Open(strPathA) Set B = objWord.Documents.Open(strPathB) MsgBox A.Content.Text MsgBox B.Content.Text If A.Content.Text = B.Content.Text Then fnCompWordDocs = "Documents areLast edited by Killer42; Apr 25 '07, 06:51 AM. Reason: Please use [CODE]...[/CODE] tags around your code.Leave a comment:
-
tweety123 started a topic To compare two word docs and make changes in one to make it same as first one?in Visual BasicTo compare two word docs and make changes in one to make it same as first one?
I want to write a generic function to compare two word documents and make changes in one so as to make it same as the another one.
Also, I want to do the same with two text files. -
I have written a simple code to search fro a particular word/words in a word doc:
...Code:Function fnSearchWordDoc(strPath, strSrTxt) Set objWord = CreateObject("Word.Application") Set A = objWord.Documents.Open(strPath) 'MsgBox A.Content.Text Doctext = A.Content.Text If InStr(Doctext, strSrTxt) <> 0 Then fnSearchWordDoc = "Text found in the document"Leave a comment:
-
Thankyou! this should help.Leave a comment:
-
Thankyou for the reply!Leave a comment:
-
Hi,
I have a function that we use to send email via Microsoft email outlook..might help you.
Function fnSendMail(strA ttachmentFile, strToAddress, strSubject, strBody)
Set objOutlook = CreateObject("O utlook.Applicat ion")
Set objItem = objOutlook.Crea teItem(0)
objItem.Attachm ents.Add strAttachmentFi le
arrAddressArray = Split(strToAddr ess, ";")
strAddress = ""...Leave a comment:
-
tweety123 started a topic Searching for a particualr word in a text file,using VBA??in Visual BasicSearching for a particualr word in a text file,using VBA??
Hi,
Please help me create a function that would return if a particular word exists in the given text file or not? I am working in automation testing too TestPartner which uses VBA scripting language
No activity results to display
Leave a comment: