Search results for query: *

I need to read whats in all text boxe's on a spreadsheet. The Textboxes were created using excel not vba (insert/textbox). Im pretty sure its not an OLELbject. I tried using this code to find it and It did not see them. any help would be great Sub textboxes() Dim oleObj As OLEObject For Each...

I have added a buttom on my ribbon that should start a macro. but it does nothing. I'm not sure why I followed the directions it should execute my macro but its not evenb hitting it. Did I mess a step?

I am using some very simular code in outlook to change the subject line. When I try to use it in this instance I get an error on the object Outlook.Application.ActiveInspector.currentItem. I can use the object Outlook.Application but its not going to do what I need it to do. Any ideas...

I've go this code that I think will get me part way to what I am trying to do but I need to do more. I need to look for a field in a coulumn and it looks like this code will give me everything in the column. cam I correct? Sub GetDataFromSQLServer() Dim conn As Object...

I cant seem to populate my combobox. what do I need to set so I can additem. I think this is where I'm hung up.

Is there a way to referance a cell in a protected workbook with a macro or is it just not possible?

I'm starting to play around with VBA in Excel and of course the first macro I write is Range("B3").Select which should work no problem but I get Invalid outside procedure and it highlights the B3 What in the world could I be doing wrong? THis is about as simple a command as you can get.

How come when I add the code in this macro to my application I get errors? Sub CopyAttachments() Set objApp = CreateObject("Outlook.Application") Set objEXP = objApp.ActiveExplorer Set objSel = objEXP.Selection Set SRC1 = objSel.Item(1) Set fso =...

When I run this code I get the error that I do not have the apropriate permissions. I am the admin on my machine do I need to set something in outlook also? Sub CopyAttachments() ' this is how to save attachments in temprary folder ' objSourceItem = InputBox("SURCE", , , , 8) '...

I am running outlook 2010 This is the chunk of code that has the message box in it If I select no it ends the proram but the E-mail still goes out. I need to cancel the E-mail all together. Anyone have any Idea what I did wrong? If strSubject = "KECCERT" Then Prompt$ = "Do you...

I am very new to this so please excuse my ignorance. I am trying to implement this code Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) 'Declaration Dim strSubject As String Dim strPartN As String Dim strShipDT As String Dim strPO As String Dim strDesc As String Dim...