Selection.PasteAndFormat method In Word 2007, when I record a macro that does a regular Paste from the clipboard, it records it as Selection.PasteAndFormat(wdPasteDefault) It also seems to use the same 'wdPasteDefault' type even if I choose either-- Paste Special | Unformatted Text; or Paste Special | Unformatted Unicode Text I'm not s... 12 Feb 2010 14:37
Converting text and listnum fields to multi-level lists I have many documents with numbered paragraphs. They use a mixture of text, listnum fields and multi-level lists to achieve the numbering. How can I convert them all to multi-level lists using VBA? ... 11 Feb 2010 11:42
Copying autonumbered paragraphs and retaining original numbers I need to copy numbered paragraphs from multiple documents. The paragraphs are inconsistent and may be numbered using text, MS Word multi-level list styles or listnum fields. I can search the documents, find the needed paragraphs and copy them to a new document, but when I do, the numbering resets according to ... 16 Feb 2010 12:58
Excel date column for working out time differences I use Excel 2002 and I am trying to use an expression to calculate any entries older than 14 days and then send an email as a reminder. Date is in column1. I have the following code For j = 1 To lastcell If Cells(j, 13) <> "" And Cells(j, 14) = "" And Cells(j, 1).Value > (Now - 14) And Cells(j, 15) = "" Then ... 11 Feb 2010 05:02
Create a new Excel spreadsheet from Word VBA Hello, I received some help a while back but cannot locate my post. I am trying to put my Excel templates on a menu in Word along with my Word templates, hoping that I can create a new spreadsheet based on my Excel template. I have these two macros which I have tried with no luck: Sub Tryit() Dim xlApp... 18 Feb 2010 11:43
Why is my Template 'Dirty'? I've run into this problem a few times now, and I can't figure out what's going on. When I open one particular template to edit it, it's immediately 'dirty' - that is, its .Saved property is "False". It doesn't contain any fields or links in the body of the template (apart from page numbering fields in the f... 10 Feb 2010 19:07
blinked letters I would like to know how to chage blinked letters im my word 2007 ... 11 Feb 2010 02:51
how do i set up payslip on word? i am trying to prepare a format for my carers payslip. how can i get a format? ... 10 Feb 2010 13:26
Autonew creates a new document from template and a new blank docum I have a couple of users who are getting a new document based on a template, but it's also creating a new blank document. This is not happening for other users running the same autonew macro. Can anyone tell me if they've seen this happen before and what the solution is? Thank you! ... 10 Feb 2010 06:42
How do I import web address from Excel and turn them into hyperlin I have an online business that sells on Amazon.com and want to send an e-mail to all my customers to leave feedback. Each customer has a specific link for their order #. But when I try to import those links into the document from excel they are the full 50+ character link, I want to format them to say "this li... 10 Feb 2010 07:48 |