Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-17-2020, 09:37 PM
Guessed's Avatar
Guessed Guessed is offline Would these macros be possible to make? Windows 10 Would these macros be possible to make? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,177
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

OK, the coding of a macro to do what you ask is possible but unlikely to actually satisfy you. All macros must be based on assumptions and it appears that the assumptions we would need to make are likely to be incorrect enough times that the result would be pointless.

If you had a VERY regular delimiting factor that lets us say this is the end of the project chunk then we could use that but you must never vary from that 'separator' or inadvertently include that separator in the middle of a project.

Based on your input information so far, I'm going to assume that your 'project' groups are delimited by empty paragraphs. If that is the case, I would start by moving each of these projects into table cells which would create a regular structure where the macro could now look at your content delimited by something more tangible and controllable. It would then be a far simpler task to add a column with a character count and sort the table based on that column.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #2  
Old 08-18-2020, 05:25 AM
grumblid grumblid is offline Would these macros be possible to make? Windows 7 64bit Would these macros be possible to make? Office 2003
Novice
Would these macros be possible to make?
 
Join Date: Jul 2016
Posts: 25
grumblid is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
OK, the coding of a macro to do what you ask is possible but unlikely to actually satisfy you. All macros must be based on assumptions and it appears that the assumptions we would need to make are likely to be incorrect enough times that the result would be pointless.

If you had a VERY regular delimiting factor that lets us say this is the end of the project chunk then we could use that but you must never vary from that 'separator' or inadvertently include that separator in the middle of a project.

Based on your input information so far, I'm going to assume that your 'project' groups are delimited by empty paragraphs. If that is the case, I would start by moving each of these projects into table cells which would create a regular structure where the macro could now look at your content delimited by something more tangible and controllable. It would then be a far simpler task to add a column with a character count and sort the table based on that column.
I mean if it works, I'm pretty easy to satisfy :]

Thanks for the suggestion, but personally table cells would be a nightmare for what I have. Though 'character count' does kind of sound like the general term I'm thinking of. Like if a macro or online tool could look at a document like 'okay this body of text has 200 characters and this one has 300, so the one with 300 goes above that one.' But of course do that for the entire document all at once.

Outside of MS Word Macros, does anyone have any suggestions for an online tool that might be able to do that? I've used sites that alphabetize words, add up multiple numbers that you copy/paste onto it, and stuff like that. But not one like this yet :{o
Reply With Quote
Reply

Tags
help me, macros, ms word



Similar Threads
Thread Thread Starter Forum Replies Last Post
Would these macros be possible to make? How to automatically enable the macros upon opening a file with macros? laurieli Office 7 01-17-2016 08:56 AM
Can you make templates dynamically update macros/etc. from Normal.DOT? New Daddy Word 2 11-18-2013 09:07 AM
Would these macros be possible to make? VBA macros tays01s Word VBA 6 08-03-2011 09:42 PM
Macros nore Outlook 0 06-01-2011 04:39 PM
Would these macros be possible to make? Macros Desertwrangler Word VBA 6 06-25-2010 07:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft