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

    How to insert 2 independent TOCs...

    You were on your way to the solution when you asked "Do I need to apply different Header styles to the 2 languages?" Yes, you do. But note that the styles do not need to be Heading styles because you can build a TOC using any style in your document. You would include a \t switch in your TOC...
  2. BenRowe

    Highlight Printing

    When you send to print, under Comments and Forms, make sure Document and Markups is selected. You'll see the highlighting in the preview window.
  3. BenRowe

    Redacting in acrobat 6 pro

    First of all, Acrobat 8 has a redaction tool. So if this is something you do all the time, you should consider upgrading. Since you say the PDF was scanned, I'm assuming it's an image PDF. Do you have a way to OCR it? I'm not sure if Acrobat 6 can do it. I know that version 7 on can. You...
  4. BenRowe

    Can Microsoft Word Table display the number of rows in the table

    The number of rows is also in Table - Table Properties - Row. Though, sometimes it is necessary to click on the Table tab once inside Table Properties first and then click on the Row tab before it appears. It is below Size, next to Row. So if you click on the last row in the table you will...
  5. BenRowe

    word to pdf email address hyperlink with symbol problem

    I used pdfmaker to create a pdf with email addresses as you described and it worked fine. However, if I printed it to pdf using the Adobe PDF print driver it worked the way you describe. If you have Acrobat installed on your system, you should have pdfmaker. In word, there is a toolbar for it.
  6. BenRowe

    jpg to xls

    Is it possible they could email that spreadsheet to you rather than faxing? If not, if you have Acrobat you can open the jpg in Acrobat, which converts it to a pdf and then you can OCR the pdf. My office uses OmniPage, which does a great job of recognizing text from a pdf.
  7. BenRowe

    Can I sort Fields in Word Table?

    This will not work if you need the field codes to remain as field codes: select the field codes, present Alt + Shift + F9 to convert them to text and then you could sort.
  8. BenRowe

    Excel: Tab Key

    Make sure Tools - Options - Transition - Transition navigation keys is not checked.
  9. BenRowe

    Office XP key

    I found the following in help on the start button (searched to product key): How to obtain a new product key for Office program setup View products that this article applies to. Article ID : 823570 Last Review : August 24, 2004 Revision : 3.0 On This Page SUMMARY MORE INFORMATION...
  10. BenRowe

    lotus wk4 file will only open if excel is opened first

    Are you sure about the file type being associated with excel? Is there an excel-like icon displaying next to the file name? If not, right click on file name, click open, select program from a list, select excel, and make sure box to always use the selected program to open files of this kind is...
  11. BenRowe

    MS Word Macro to GoTo/Copy Highlighted Text

    I noticed your posting in the Microsoft Office forum. There is a way of doing this in word without needing a macro. I know this works in word 2003 and perhaps in prior versions too. 1. Ctrl + F -- brings us Find dialog 2. Click in Find What 3. Click on down arrow next to Format (near bottom...
  12. BenRowe

    Importing into excel

    I got it to work with comma-delimited. First line of csv is header line for field names and any fields that may contain line breaks would need to be enclosed in double quotes. E.g., Field 1, Field 2, "Comments
  13. BenRowe

    Importing into excel

    On second look this didn't work so well. What about replacing returns with a symbol and then replacing them back in excel. If you do it in macro in excel you would replace whatever symbol you use with chr(10).
  14. BenRowe

    Importing into excel

    I had better luck with comma delimited file. Is this a possibility for you?
  15. BenRowe

    Pop-up Window

    Following code produces message box with your suggested words: msgbox("Test pop-up code") What are you trying to do with this pop-up window?
  16. BenRowe

    Pop-up Window

    You could add your code for the popup menu to the Workbook Open event. You need to minimize the workbook, right click on the title bar, click on View Code. Select Workbook Open event.
  17. BenRowe

    Cell Colours - Can this be done

    Sorry, but in order to reference D1 that first line of code should have been: If Target.Column = 4 And Target.Row = 1 Then
  18. BenRowe

    Cell Colours - Can this be done

    What you could do is create a Name for all of the cells involved. You would select the cells, go to Insert, Name, Define, code below assumes name is CellsToMatchD1. For non-contiguous selecting you hold down Ctrl before clicking on the cell. The disadvantage of doing it this way is you will...
  19. BenRowe

    returning multiple records from an excel range

    For each of your Databases, your need to create a name. Select the cells involved (make sure first row has field name labels), Click Insert, Name, Define, type in name, which will be your table name in SQL. Now, click Data, Import External Data, New Database Query, click New Data Source, using...
  20. BenRowe

    Cell Colours - Can this be done

    Right click on worksheet tab. Click view code. Add the following to the Worksheet SelectionChange event: If Target.Column = 2 Then Target.Cells(1, 3).Interior.ColorIndex = Target.Cells.Interior.ColorIndex End If Now when you click on a cell in Column B the background color...

Part and Inventory Search

Back
Top