Search:

Type: Posts; User: Macropod; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.19 seconds.

  1. Replies
    1
    Views
    296

    Re: Mail Merge - Blank Spaces

    How is the output supposed to change when 'Life Insurance', for example, is empty, compared to when the same field contains data? Your post so far doesn't give any indication of this. Note also that...
  2. Re: How to convert formatted text to html in Excel

    Simply open the VBA Editor (e.g. Alt-F11), then copy the code from here and paste it into the VBA Editor and make the code edits that have been suggested in post 6. You can then close the VBA Editor...
  3. Replies
    1
    Views
    708

    Re: MS Word Bar Codes

    If you're seeing something like:
    {DisplayBarcode “490123456789” EAN13 \t}
    all that means is that you have the field code display toggles on. Pressing Alt-F9 toggles the field code display on/off.
  4. Re: How long does it take a moderator to approve a post

    Depends on whether & when there are any moderators on-line.
  5. Re: Macro to use mail merge with word and then save each printout as a pdf

    See Send Mailmerge Output to Individual Files and Run a Mailmerge from Excel, Sending the Output to Individual Files in the Mailmerge Tips and Tricks thread at:...
  6. Replies
    10
    Views
    322

    Re: Luhn check digit formula

    I have to wonder what parameters you used to search here for previous threads on this. A simple search for Luhn returns 24 threads. See, for example:...
  7. Replies
    4
    Views
    383

    Re: Importing Excel Range data to Word doc

    Provided the first argument is kept 'False' , either of the second two of the .PasteExcelTable arguments will allow you to edit the content in Word - as will .PasteSpecial DataType:=wdPasteOLEObject.
  8. Re: VBA - Delete row based on cell above (date) and cells left (number)

    This thread is a duplicate of: https://www.mrexcel.com/forum/excel-questions/1101762-vba-delete-row-based-cell-above-date-cells-left-number.html
    Kindly read Mr Excel's policy in Rule 12 against...
  9. Thread: PDF To Excel

    by Macropod
    Replies
    1
    Views
    214

    Re: PDF To Excel

    As per Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html, kindly provide a link to your cross-post at Excel Forum. And, as per...
  10. Replies
    3
    Views
    216

    Re: Mail Merge/ VBA

    How it's done with a mailmerge depends entirely on how your workbook is configured. Numerous approaches are possible.

    For example, you can use Word's Catalogue/Directory Mailmerge facility (the...
  11. Re: Passing variables from Child (Word) to Parent (Excel)

    Which is what the code in post # 13 should do. To make it stand out more though, the username & time are not output - but it's easy to add that back in if you want.
  12. Re: Chart or Pivot Table to be included in the body of email VBA

    This thread is a duplicate of: https://www.mrexcel.com/forum/general-excel-discussion-other-questions/1101484-how-include-pivot-table-chart-body-email.html
    Kindly read Mr Excel's policy in Rule 12...
  13. Replies
    4
    Views
    383

    Re: Importing Excel Range data to Word doc

    You might try varying your PasteExcelTable arguments. Otherwise, you might try:
    myDoc.Range.PasteSpecial DataType:=wdPasteOLEObject
    to insert the actual worksheet, or:
    myDoc.Range.PasteAndFormat...
  14. Replies
    1
    Views
    164

    Re: Excel to Word Document

    Open the worksheet and document. In the worksheet, copy your limited number of rows for the first page. Switch to Word and use Paste Special with the 'paste link' option and your preferred paste...
  15. Re: Passing variables from Child (Word) to Parent (Excel)

    It's pretty much just a case of moving your existing Word code into Excel. For example:

    Option Explicit

    Sub CreateSelfFundedContract()
    Dim wdApp As New Word.Application, wdDoc As Word.Document...
  16. Re: Passing variables from Child (Word) to Parent (Excel)

    The 'If Dir(MMOut) <> "" Then' test should find the file if it exists and display the message box. Maybe the message box is being hidden behind the Excel window?

    Where in Excel would the answer go?
  17. Re: Passing variables from Child (Word) to Parent (Excel)

    Code corrected - see final few lines
  18. Re: Passing variables from Child (Word) to Parent (Excel)

    You don't need your FileExists variable. Try the following. Note that I've deleted numerous unused/redundant variables:

    Option Explicit

    Sub CreateSelfFundedContract()
    Dim wdApp As New...
  19. Replies
    32
    Views
    1,045

    Re: VBA Editor not autocompleting

    No, I meant TypeName(Selection). After all, I did say:
  20. Replies
    32
    Views
    1,045

    Re: VBA Editor not autocompleting

    Just to be on the safe side, then, you might test what's selected, via:
    TypeName(Selection)
  21. Replies
    32
    Views
    1,045

    Re: VBA Editor not autocompleting

    Excel's Intellisense seems lame by comparison with Word in this area, where Intellisense works quite happily even for Selection.
  22. Re: List(Sort by) Birthday Anniversaries in .txt file

    Cross-posted at: http://www.vbaexpress.com/forum/showthread.php?65328-List-(Sort-by)-Birthday-Anniversaries-in-txt-file
    Please read Mr Excel's policy on Cross-Posting in rule 13:...
  23. Replies
    3
    Views
    310

    Re: Date Formatter Macro

    Here's a different approach that won't mess with the formatting of any surrounding text. As coded, it processes every date in the selected range.

    Sub LongDates()
    Application.ScreenUpdating =...
  24. Replies
    9
    Views
    383

    Re: Gross salary from Net Salary

    Cross-posted at: www.msofficeforums.com/excel/42721-gross-salary-net-salary.html
    Please read Mr Excel's policy on Cross-Posting in rule 13:...
  25. Re: How to set up an effective formula for testing a betting system.......

    This thread is a duplicate of: https://www.mrexcel.com/forum/excel-questions/1100633-how-set-up-effective-formula-testing-betting-system.html
    Kindly read Mr Excel's policy in Rule 12 against asking...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4