Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() I'm kinda new to vba. This took me lots of hours to make/I'm confused. I need clarification help. Goal: Find paragraph with specific level format (1/2 for example) and add space to beginning of each selection The functions I need are already created, except I have some problems: For my function to work throughout, I have to type something in a msgbox for my script to go forward for each manipulation. Is there anyway to make it run smoothly, and then to have a msgbox to tell me that my script was done working its function? Sub macccta() Dim sResponse As String Do sResponse = InputBox(Prompt:="Type no to exit,Baby", _ Title:="", Default:="") If sResponse = "no" Then Exit Sub Else 'this is convenient because I can just type "no" to exit a nasty loop; this keeps on looping... where should it place? If sResponse "" Then '<--what does this single statement means, especially the ? I think its always making me need to input anything to make the rest of the script work Selection.HomeKey Unit:=wdStory 'start in the beginning of doc Selection.Find.ClearFormatting With Selection.Find 'we are finding heading 2 .ParagraphFormat.OutlineLevel = wdOutlineLevel2 Do While .Execute Selection.InsertBefore " " 'election is converted as body text, because if not, the script keeps on looping because I dont know what I'm missing to make it stop Selection.ParagraphFormat.OutlineLevel = wdOutlineLevelBodyText Loop End With End If Loop While sResponse < "" MsgBox "done" End Sub This script would be very useful for people who wants to copy all the selection after and paste it into Freemind (a great mindmapping free software!), which recognizes 'spaces' as heading levels. Thx you!!!! Plz help! ![]() -- Ambrosia ------------------------------------------------------------------------ Ambrosia's Profile: http://www.excelforum.com/member.php...o&userid=28146 View this thread: http://www.excelforum.com/showthread...hreadid=524664 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking table in Excel to word | Links and Linking in Excel | |||
how do you get Word to open documents in it's own window(s)? | Excel Discussion (Misc queries) | |||
Print Excel charts in Word 2003 with fixed size | Charts and Charting in Excel | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) |