Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Hoaokapohaku

    Excel macro to create Outlook message not returning focus to cell after completion

    PPettit...I don't have all the answers, but I think you are on the right track in your last post. I created a workbook and added the relevant sheets, named ranges, etc and ran your macro but could not duplicate your problem UNTIL I added an ActiveX Command Button to initiate the macro. When I...
  2. Hoaokapohaku

    In VLOOKUP is it possible to use cell values to make up a named range for the Table-array?

    Oooops!...The above will give you a text string with the right name, but Excel won't interpret the text string as a range reference so it won't work in VLOOKUP.
  3. Hoaokapohaku

    Spell Check Macro for Protected Workbook

    Shelby, Yes. While in the normal user interface, the sheets will be protected as always. Unlocked cells will be editable, lock cells will not. I'm not sure what's going on with your issue of unlocked cells becoming locked when you protect the workbook. How are you unlocking the cells and...
  4. Hoaokapohaku

    Spell Check Macro for Protected Workbook

    Shelby...I notice several posts where worksheet protection is an issue for your macros. If you put this event procedure in your "ThisWorkbook" object, your macros can run without constantly having to protect and unprotect sheets. It also ensures that if you unprotect a worksheet and then...
  5. Hoaokapohaku

    v-lookup

    Use VBA to "Find" the value in the range of the list, and then enter the data on the sheet you want. Put it within a Do...While loop with the condition that it continues to run continues to find instances of the desired value. The interface can be exactly as you want. When the "category" is...
  6. Hoaokapohaku

    Need a Custom Batch File

    Ooops...my post has part of an earlier version of my solution in it. Where it says, "CallCSVConversion," in the first paragraph, it should be "Workbook_Open event macro". This forum needs a feature for post editing!
  7. Hoaokapohaku

    Need a Custom Batch File

    upinflamezzz - If I understand correctly what you want, this should work as long as Excel is running and you have not closed the file where macro "CallCSVConversion" is located. If you have a "personal.xls(b)" file in your xlstart folder, use the VBA editor put the following code in the...
  8. Hoaokapohaku

    Compare 2 spreadsheets in XL2K3

    As Skip pointed out, the solution depends a lot on what kind of differences you are looking for. If all you need to do is compare values, I'd make a third sheet and put the formula "=Sheet2!A1=Sheet3!A1" (note relative references) in every cell 729 x 98 cells. This will return a "TRUE" value...
  9. Hoaokapohaku

    Recorded macro won't run in Word 2010

    Before reinstall, you might try closing Word, renaming your normal.dot file to something else, start Word again and see if you still have the problem. Word will create a new clean normal.dot file. If your macro is in the normal.dot file, you will have to put it in the new normal file before...
  10. Hoaokapohaku

    Recorded macro won't run in Word 2010

    You might have to tweak this a little, but I think it does something close to what you want: Sub Macro1() With Selection .InsertCaption Label:="Figure", TitleAutoText:="", Title:="", _ Position:=wdCaptionPositionBelow, ExcludeLabel:=0 .InsertCrossReference...
  11. Hoaokapohaku

    VBA/Lotus Notes Send to multiple recipients

    To answer my own question above, yes you can code an Outlook Contact List (distribution list) from within Excel VBA. Here is some code from MS to do it. I know this is not what the OP needs since he is using Lotus Notes, but it might be helpful for others using Outlook, or someone else...
  12. Hoaokapohaku

    VBA/Lotus Notes Send to multiple recipients

    Have any of the methods proposed here worked other than the one I mentioned? I'd like to know, because my conclusion that it can't be done with a single line of code was based on trying to solve the same problem trying the same ideas being suggested here until I wanted to pull out my hair...
  13. Hoaokapohaku

    Access: Object Variable or With Block variable

    The problem might not be at the code line where you are looking. "with" and no "end with", "if" with no "end if", other loops without "loop" or "next" can all cause the error you are getting. Without the proper closing statement for all such instances, VBA will give the error you are getting...
  14. Hoaokapohaku

    VBA/Lotus Notes Send to multiple recipients

    You could do about the same thing using an array instead of a collection.
  15. Hoaokapohaku

    VBA/Lotus Notes Send to multiple recipients

    If Lotus Notes can't do what I said above, or if for other reasons you want to handle everything within VBA, you could create a Collection for the email addresses, populate the collection with the intended email addresses, and then write code to loop through the collection and send individually...
  16. Hoaokapohaku

    VBA/Lotus Notes Send to multiple recipients

    It sucks, but when I dealt with this problem in the past I found only two ways around the problem. One is you must code to send an email separately for each recipient. There is no way to name multiple recipients with a single line of code. The other way is to create what Outlook calls a...
  17. Hoaokapohaku

    Excel 2007 Find & Replace VBA FALSE Result

    On second thought, I think your original concept using "replace" was best, and you should skip any kind of looping altogether. The following code works, but you must name the ranges for the entire columns where the text is that you want to concatenate. For illustration purposes, I just used...
  18. Hoaokapohaku

    Excel 2007 Find & Replace VBA FALSE Result

    This is a hybrid between your original code using find and replace, and Skip's solution that loops through the range. This one loops too, but loops only through the cells that meet the criteria. In other words, if you have only 4 instances of "TEMP", it will loop only 4 times rather than 500...
  19. Hoaokapohaku

    VBA/Excel: how to reference an "activecell" in an "inactive" sheet

    Trey, I'm glad it worked for you! And mahalo (thanks in Hawaiian) for letting me know. I enjoy playing with VBA, and it's gratifying to know I helped someone. You might get more efficient yet if you considered Skip's questions about what are you trying to accomplish. I addressed your...

Part and Inventory Search

Back
Top