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...

Ok I was mistaken its only my macros that wont work and macros are enabled. it's almost like the botton and the macro arnt linked.

ekr, Have you ever thought about putting it in a SQL database. In the long run it will be easer for you.

yep I put a save button in the new group and that wont work either.

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?

Ok I have it working now. Things to keep in mind. Set Item = Application.ActiveInspector.currentItem you cannot have outlook.application when you set it I dont know why but if you take out outlook it works and also if you are doing an inspect remember to have an E-mail open otherwise it will...

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...

Yes I had success with that also.

OK so I think I have this figured out Here is a sample of my code for other with this issue Private Sub ComboBox1_DropButtonClick() ComboBox1.AddItem "red" ComboBox1.AddItem "red" ComboBox1.AddItem "red" ComboBox1.AddItem "red" ComboBox1.AddItem "red" ComboBox1.AddItem "red" The most...

got it thank you very much

Yes and the book I have on outlook. Just tells you about it and how useful it can be but not how to code it. It's like they didnt know so they skimmed over that part. Thanks for the help I will give it a try and let you know what happens.

yep thats the problem i'm running into. I dont know how to populate it in outlook. In excel I would just referance the cell. but in outlook I'm not quite sure how to do it. Thanks for the link.

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.

I can open it up as read only I just didnt know if I could just referance a cell not make a change to it just referance it without a password. When i try I get an error so Im guessing you are correct I need a password to do it. Thanks for your help.

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

Nevermind it looks like there was something going on with my spreadsheet I closed Excel and opened a new workbook and all was fine. Go figure

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.

Why does it work as a macro?

I get Compile error: Variable not found on Set objApp = CreateObject("Outlook.Application") it runds fine as a macro but when I attempt to put it in my application it has an issue. I'm sure its something simple that I am unaware of. Any help would be apreeciated. Option Explicit Private Sub...