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...
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...
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...
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.
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.
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.
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...
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...
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...
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
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).
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.
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.