Search results

Cross-posted at: I want generate All Employee payslip in PDF on 1 Button=VBA codes gives error PLS HELP (excelforum.com) where you have already been given very clear advice on what is wrong with your VBA code, but which you're unwilling to invest even the tiniest effort correcting. Kindly read...

You could automate a mailmerge from Excel to do that. For the required macro code, see Run a Mailmerge from Excel, Sending the Output to Individual Files in the Mailmerge Tips and Tricks page at: https://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html For the mailmerge...

Also cross-posted at: vba - How to copy the bold value and paste in next column continuously until the next bold value find? - Stack Overflow

Cross-posted at: Topic: How to copy the bold value and paste in next column continuously until the next @ AskWoody Please read Chandoo's policy on Cross-Posting in the forum rules: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

Also cross-posted at: https://stackoverflow.com/questions/74624241/solving-this-interesting-simulation-question-related-to-probability-distribution Reddit

Also cross-posted at: How can we use VBA/Macros Excel for solving this interesting simulation question? | Excelguru Forums How can we use VBA/Macros Excel for solving this interesting simulation question? (vbaexpress.com) Kindly read Chandoo's policy on Cross-Posting in the forum rules you...

For example: =(LEN(sourceText)-LEN(SUBSTITUTE(LOWER(sourceText),LOWER(B6),"")))/LEN(B6)

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at...

@33sameer33:For some code to get you started, see: mail merge in excel? (excelforum.com), especially post #16 in that thread.

@chssundeep: Maybe you missed the part about "using only microsoft excel"...

shah0101: Please read Chandoo's policy on Cross-Posting in the forum rules : https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

Cross-posted at: Dashboard required for assets condition (msofficeforums.com) Please read Chandoo's policy on Cross-Posting in the forum rules: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

Sorry, but I have no way of validating that. In any event. if I were to post a solution here, there's no telling where its abuse would end...

Yes, I can, but no, I won't. If it's locked, it's most likely someone else's intellectual property.

Cross-posted at: http://www.vbaexpress.com/forum/showthread.php?68250-Ribbon-run-time-error-5825 Please read Chandoo's policy on Cross-Posting in the forum rules: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

Already answered @ Mr Excel.

Cross-posted at: https://www.excelguru.ca/forums/showthread.php?10614-How-to-run-a-macro-to-split-20k-files-into-files-of-100-rows-leading-zero-issue-too Please read Chandoo's policy on Cross-Posting in the forum rules: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

The fact you apparently marked the thread as 'solved' at MSOfficeForums probably explains why you didn't get a reply there...

Cross-posted at: https://www.mrexcel.com/board/threads/un-hide-rows-base-on-cell-change-for-two-different-cells-un-hiding-different-parts-of-the-sheet-independently.1130372/...

You still haven't provided any code, though. Most unhelpful. One wonders if you're only interested in increasing your post count...

It now turns out the OP has been trying to run the code on a Mac and the actual source files are .txt files, not .docx files...

With the correct workbook setup, it could all be done via mailmerge.

See my reply @ MrExcel. It is best if you keep discussions about replies on another forum to that forum; otherwise you risk people on different forums clouding the issue.

Marc L: I don't see you offering a solution; merely telling the OP he/she should do something different. The problem has already been solved...

Without wanting to place too fine a point on it, I am not the one who cross-posted. Kindly get off your high horse. As a moderator of multiple forums, I am well aware of what the rules say and mean.