LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ambrosia
 
Posts: n/a
Default This is funny!!! Helpful Ms word vba


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking table in Excel to word travis Links and Linking in Excel 1 November 19th 05 02:30 PM
how do you get Word to open documents in it's own window(s)? othree7 Excel Discussion (Misc queries) 0 November 16th 05 04:21 PM
Print Excel charts in Word 2003 with fixed size Phil Charts and Charting in Excel 1 November 3rd 05 04:24 AM
How to embed Word document into Excel and retain sizing, formatti. Kent Excel Discussion (Misc queries) 0 February 2nd 05 07:37 PM
Embedded word doc changed to image-need to change back to word. cflores Excel Discussion (Misc queries) 0 January 23rd 05 06:45 AM


All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"