text to tags
I want to know if it is possible to convert plain text to XML tags using MACROS. If so pls tell me how to go abt this process.
|
-1 |
|
Sahana
11/12/2009 5:06:55 AM
word.vba.general
1023 articles. 
1 followers.
6 Replies
1014 Views
What do you want to convert them to? -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Sahana" <shalmalibarki.admin@gmail.com> wrote in message news:be15bd60-dad2-4a71-b89b-f2ba90fe8bbe@u36g2000prn.googlegroups.com... >I want to know if it is possible to convert plain text to XML tags > using MACROS. If so pls tell me how to go abt this process.
|
|
0 |
|
Doug
11/12/2009 5:32:52 AM
On Nov 12, 10:32=A0am, "Doug Robbins - Word MVP" <d...@REMOVECAPSmvps.org> wrote: > What do you want to convert them to? > > -- > Hope this helps, > > Doug Robbins - Word MVP > > Please reply only to the newsgroups unless you wish to obtain my services= on > a paid professional basis."Sahana" <shalmalibarki.ad...@gmail.com> wrote = in message > > news:be15bd60-dad2-4a71-b89b-f2ba90fe8bbe@u36g2000prn.googlegroups.com... > > > > >I want to know if it is possible to convert plain text to XML tags > > using MACROS. If so pls tell me how to go abt this process.- Hide quote= d text - > > - Show quoted text - Hi If I got a text like this: Hi. Good Morning. where Good Morning is BOLDFACED. I want the text to be converted to XML TAGS. So the XML tag would look like: <?xml version=3D"1.0"?> <content> <page no=3D"001" audio=3D"1"><AudioText><![CDATA[<font size=3D"14"color=3D"#000000">Hi. <b>Good Morning</b>.</font>]]></ AudioText></page></content> is this possible using macro?
|
|
-1 |
|
Sahana
11/12/2009 6:32:03 AM
Sahana wrote:
> On Nov 12, 10:32 am, "Doug Robbins - Word MVP"
> <d...@REMOVECAPSmvps.org> wrote:
>> What do you want to convert them to?
>>
>> --
>> Hope this helps,
>>
>> Doug Robbins - Word MVP
>>
>> Please reply only to the newsgroups unless you wish to obtain my services on
>> a paid professional basis."Sahana" <shalmalibarki.ad...@gmail.com> wrote in message
>>
>> news:be15bd60-dad2-4a71-b89b-f2ba90fe8bbe@u36g2000prn.googlegroups.com...
>>
>>
>>
>>> I want to know if it is possible to convert plain text to XML tags
>>> using MACROS. If so pls tell me how to go abt this process.- Hide quoted text -
>> - Show quoted text -
>
> Hi
>
> If I got a text like this:
>
> Hi. Good Morning.
>
> where Good Morning is BOLDFACED.
>
> I want the text to be converted to XML TAGS. So the XML tag would look
> like:
>
> <?xml version="1.0"?>
>
> <content>
>
> <page no="001" audio="1"><AudioText><![CDATA[<font
> size="14"color="#000000">Hi. <b>Good Morning</b>.</font>]]></
> AudioText></page></content>
>
>
> is this possible using macro?
Running a macro containing the code:
Selection.HomeKey wdStory
Selection.Find.ClearFormatting
With Selection.Find.Font
.Bold = True
End With
With Selection.Find
Do While .Execute(FindText:="", Forward:=True, _
MatchWildcards:=False, Wrap:=wdFindStop, MatchCase:=False) = _ True
With Selection
If Left(.Paragraphs(1).Style, 4) <> "Head" Then
.Font.Bold = False
.InsertBefore "<b>"
.InsertAfter "</b>"
End If
.Collapse wdCollapseEnd
End With
Loop
End With
will convert
Hi. Good Morning.
where Good Morning is BOLDFACED.
Hi. <b>Good Morning</b>.
--
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my
services on a paid professional basis.
|
|
0 |
|
Doug
11/12/2009 9:25:30 AM
On Nov 12, 2:25=A0pm, Doug Robbins - Word MVP <d...@REMOVECAPSmvps.org> wrote: > Sahana wrote: > > On Nov 12, 10:32 am, "Doug Robbins - Word MVP" > > <d...@REMOVECAPSmvps.org> wrote: > >> What do you want to convert them to? > > >> -- > >> Hope this helps, > > >> Doug Robbins - Word MVP > > >> Please reply only to the newsgroups unless you wish to obtain my servi= ces on > >> a paid professional basis."Sahana" <shalmalibarki.ad...@gmail.com> wro= te in message > > >>news:be15bd60-dad2-4a71-b89b-f2ba90fe8bbe@u36g2000prn.googlegroups.com.= ... > > >>> I want to know if it is possible to convert plain text to XML tags > >>> using MACROS. If so pls tell me how to go abt this process.- Hide quo= ted text - > >> - Show quoted text - > > > Hi > > > If I got a text like this: > > > Hi. Good Morning. > > > where Good Morning is BOLDFACED. > > > I want the text to be converted to XML TAGS. So the XML tag would look > > like: > > > <?xml version=3D"1.0"?> > > > <content> > > > <page no=3D"001" audio=3D"1"><AudioText><![CDATA[<font > > size=3D"14"color=3D"#000000">Hi. <b>Good Morning</b>.</font>]]></ > > AudioText></page></content> > > > is this possible using macro? > > Running a macro containing the code: > > Selection.HomeKey wdStory > Selection.Find.ClearFormatting > With Selection.Find.Font > =A0 =A0 =A0.Bold =3D True > End With > With Selection.Find > =A0 =A0 =A0Do While .Execute(FindText:=3D"", Forward:=3DTrue, _ > =A0 =A0 =A0 =A0 =A0MatchWildcards:=3DFalse, Wrap:=3DwdFindStop, MatchCase= :=3DFalse) =3D _ True > =A0 =A0 =A0 =A0 =A0With Selection > =A0 =A0 =A0 =A0 =A0 =A0 =A0If Left(.Paragraphs(1).Style, 4) <> "Head" The= n > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0.Font.Bold =3D False > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0.InsertBefore "<b>" > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0.InsertAfter "</b>" > =A0 =A0 =A0 =A0 =A0 =A0 =A0End If > =A0 =A0 =A0 =A0 =A0 =A0 =A0.Collapse wdCollapseEnd > =A0 =A0 =A0 =A0 =A0End With > =A0 =A0 =A0Loop > End With > > will convert > > Hi. Good Morning. > > where Good Morning is BOLDFACED. > > Hi. <b>Good Morning</b>. > > -- > Hope this helps, > > Doug Robbins - Word MVP > > Please reply only to the newsgroups unless you wish to obtain my > services on a paid professional basis.- Hide quoted text - > > - Show quoted text - That worked for me is it possible to append the below. <?xml version=3D"1.0"?> <content> <page no=3D"001" audio=3D"1"><AudioText><![CDATA[<font size=3D"14"color=3D"#000000"></font>]]></AudioText></page> </content> so my output will look like something like <?xml version=3D"1.0"?> <content> page no=3D"001" audio=3D"1"><AudioText><![CDATA[<font size=3D"14"color=3D"#000000">Hi. <b>Good Morning</b>.</font>]]></ AudioText></page> </content> and if i were to add tags like <br>...</br> which breaks sentences can you suggest me where i must add that? thanks for teh help
|
|
0 |
|
Sahana
11/12/2009 10:51:32 AM
Try just saving the document as an .XML file. -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Sahana" <shalmalibarki.admin@gmail.com> wrote in message news:80ca1caa-cd09-4c69-93bb-0b7a1fe3d01f@a37g2000prf.googlegroups.com... On Nov 12, 2:25 pm, Doug Robbins - Word MVP <d...@REMOVECAPSmvps.org> wrote: > Sahana wrote: > > On Nov 12, 10:32 am, "Doug Robbins - Word MVP" > > <d...@REMOVECAPSmvps.org> wrote: > >> What do you want to convert them to? > > >> -- > >> Hope this helps, > > >> Doug Robbins - Word MVP > > >> Please reply only to the newsgroups unless you wish to obtain my > >> services on > >> a paid professional basis."Sahana" <shalmalibarki.ad...@gmail.com> > >> wrote in message > > >>news:be15bd60-dad2-4a71-b89b-f2ba90fe8bbe@u36g2000prn.googlegroups.com... > > >>> I want to know if it is possible to convert plain text to XML tags > >>> using MACROS. If so pls tell me how to go abt this process.- Hide > >>> quoted text - > >> - Show quoted text - > > > Hi > > > If I got a text like this: > > > Hi. Good Morning. > > > where Good Morning is BOLDFACED. > > > I want the text to be converted to XML TAGS. So the XML tag would look > > like: > > > <?xml version="1.0"?> > > > <content> > > > <page no="001" audio="1"><AudioText><![CDATA[<font > > size="14"color="#000000">Hi. <b>Good Morning</b>.</font>]]></ > > AudioText></page></content> > > > is this possible using macro? > > Running a macro containing the code: > > Selection.HomeKey wdStory > Selection.Find.ClearFormatting > With Selection.Find.Font > .Bold = True > End With > With Selection.Find > Do While .Execute(FindText:="", Forward:=True, _ > MatchWildcards:=False, Wrap:=wdFindStop, MatchCase:=False) = _ True > With Selection > If Left(.Paragraphs(1).Style, 4) <> "Head" Then > .Font.Bold = False > .InsertBefore "<b>" > .InsertAfter "</b>" > End If > .Collapse wdCollapseEnd > End With > Loop > End With > > will convert > > Hi. Good Morning. > > where Good Morning is BOLDFACED. > > Hi. <b>Good Morning</b>. > > -- > Hope this helps, > > Doug Robbins - Word MVP > > Please reply only to the newsgroups unless you wish to obtain my > services on a paid professional basis.- Hide quoted text - > > - Show quoted text - That worked for me is it possible to append the below. <?xml version="1.0"?> <content> <page no="001" audio="1"><AudioText><![CDATA[<font size="14"color="#000000"></font>]]></AudioText></page> </content> so my output will look like something like <?xml version="1.0"?> <content> page no="001" audio="1"><AudioText><![CDATA[<font size="14"color="#000000">Hi. <b>Good Morning</b>.</font>]]></ AudioText></page> </content> and if i were to add tags like <br>...</br> which breaks sentences can you suggest me where i must add that? thanks for teh help
|
|
0 |
|
Doug
11/12/2009 9:48:52 PM
On Nov 13, 2:48=A0am, "Doug Robbins - Word MVP" <d...@REMOVECAPSmvps.org> wrote: > Try just saving the document as an .XML file. > > -- > Hope this helps, > > Doug Robbins - Word MVP > > Please reply only to the newsgroups unless you wish to obtain my services= on > a paid professional basis."Sahana" <shalmalibarki.ad...@gmail.com> wrote = in message > > news:80ca1caa-cd09-4c69-93bb-0b7a1fe3d01f@a37g2000prf.googlegroups.com... > On Nov 12, 2:25 pm, Doug Robbins - Word MVP <d...@REMOVECAPSmvps.org> > wrote: > > > > > > > Sahana wrote: > > > On Nov 12, 10:32 am, "Doug Robbins - Word MVP" > > > <d...@REMOVECAPSmvps.org> wrote: > > >> What do you want to convert them to? > > > >> -- > > >> Hope this helps, > > > >> Doug Robbins - Word MVP > > > >> Please reply only to the newsgroups unless you wish to obtain my > > >> services on > > >> a paid professional basis."Sahana" <shalmalibarki.ad...@gmail.com> > > >> wrote in message > > > >>news:be15bd60-dad2-4a71-b89b-f2ba90fe8bbe@u36g2000prn.googlegroups.co= m... > > > >>> I want to know if it is possible to convert plain text to XML tags > > >>> using MACROS. If so pls tell me how to go abt this process.- Hide > > >>> quoted text - > > >> - Show quoted text - > > > > Hi > > > > If I got a text like this: > > > > Hi. Good Morning. > > > > where Good Morning is BOLDFACED. > > > > I want the text to be converted to XML TAGS. So the XML tag would loo= k > > > like: > > > > <?xml version=3D"1.0"?> > > > > <content> > > > > <page no=3D"001" audio=3D"1"><AudioText><![CDATA[<font > > > size=3D"14"color=3D"#000000">Hi. <b>Good Morning</b>.</font>]]></ > > > AudioText></page></content> > > > > is this possible using macro? > > > Running a macro containing the code: > > > Selection.HomeKey wdStory > > Selection.Find.ClearFormatting > > With Selection.Find.Font > > .Bold =3D True > > End With > > With Selection.Find > > Do While .Execute(FindText:=3D"", Forward:=3DTrue, _ > > MatchWildcards:=3DFalse, Wrap:=3DwdFindStop, MatchCase:=3DFalse) =3D _ = True > > With Selection > > If Left(.Paragraphs(1).Style, 4) <> "Head" Then > > .Font.Bold =3D False > > .InsertBefore "<b>" > > .InsertAfter "</b>" > > End If > > .Collapse wdCollapseEnd > > End With > > Loop > > End With > > > will convert > > > Hi. Good Morning. > > > where Good Morning is BOLDFACED. > > > Hi. <b>Good Morning</b>. > > > -- > > Hope this helps, > > > Doug Robbins - Word MVP > > > Please reply only to the newsgroups unless you wish to obtain my > > services on a paid professional basis.- Hide quoted text - > > > - Show quoted text - > > That worked for me is it possible to append the below. > > <?xml version=3D"1.0"?> > <content> > > <page no=3D"001" audio=3D"1"><AudioText><![CDATA[<font > size=3D"14"color=3D"#000000"></font>]]></AudioText></page> > > </content> > > so my output will look like something like > > <?xml version=3D"1.0"?> > <content> > page no=3D"001" audio=3D"1"><AudioText><![CDATA[<font > size=3D"14"color=3D"#000000">Hi. <b>Good Morning</b>.</font>]]></ > AudioText></page> > </content> > > and if i were to add tags like <br>...</br> which breaks sentences can > you suggest me where i must add that? > > thanks for teh help- Hide quoted text - > > - Show quoted text - hi i tried saving the file in the .XML format I didnt get the output as desired which is <?xml version=3D"1.0"?> <content> page no=3D"001" audio=3D"1"><AudioText><![CDATA[<font size=3D"14"color=3D"#000000">Hi. <b>Good Morning</b>.</font>]]></ AudioText></page> </content> In ur code I found "If Left(.Paragraphs(1).Style, 4) <> "Head" Then " can u explain the meaning of this?
|
|
0 |
|
Sahana
11/13/2009 4:30:44 AM
Similar Artilces:
LoadXml causing extra space in abbreviated end tag
Using .NET Framework 1.1 and Visual Studio .NET 2003. Language is VB.NET. When loading an XML String using XMLDocument.LoadXml we are getting an extra space inserted into abbreviated end tags: objXmlDoc.XmlResolver = Nothing objXmlDoc.LoadXml(XmlData) .... .... objXmlDoc.InnerXml (gets written to database) eg <blah/> becomes <blah /> (note extra space) Is there any way to prevent this from happening?? "Matt Bush" <MattBush@discussions.microsoft.com> wrote in message news:F9F90E12-F137-4F1E-8423-00F1E7E23A1E@microsoft.com... > objXmlDoc.InnerXml (gets writt...
why does some text disappear in Web publication from Publisher?
When I convert a Publisher document to Web then do a Web preview, some text is missing. ...
Dragging text from Notepad to a TextBox
I would like to drag a text from Notepad or any other program and drop it into a textbox. I have not yet been able to figure out how to do that. Can anybody help? "Boris Pauljev" <nordiccoder@hotmail.com> wrote in message news:ei$P%236myKHA.5132@TK2MSFTNGP05.phx.gbl... >I would like to drag a text from Notepad or any other program and drop it >into a textbox. I have not yet been able to figure out how to do that. Can >anybody help? This will not work in Notepad, but I am not sure later OS'es Notepad's support OLE drag drop(In XP it doesn't...
Formula to split Text from Numbers in cell
Hi everyone I have a column of data as follows Joe Bloggs 995.1 Fred 22.6 James Brian Jones 333.54 Ted Baker 3875.34 etc The name can be any number of words and the size of the number changes with each entry. Is there any way to split the text and numbers into two separate columns using a code? I tried using the search command with an isnumeric inside but to no avail...... I also thought of looking for a space from the right hand side but I don't know how to do it. Any suggestions? Thanks John Ortt =LEFT(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(...
Changing from Numeric to Text
Hi, I copy & paste a part number from notepad into a sheet, e.g 7000000002009 and appears as 7E+12.. 2 When I change the whole column to text, the 7E+12 remains and is not converted back to the full value, unless I actually click in the cell edit area at the top of the sheet (sorry don't know exactly what that is called!) How can I set these all to appear correctly? Thanks >-----Original Message----- >Hi, > >I copy & paste a part number from notepad into a sheet, e.g 7000000002009 >and appears as 7E+12.. 2 > >When I change the whole column to text, th...
Why is copy/paste not copying the correct text?
Microsoft Publisher 2003: Occasionally when I copy something from one document, something different appears in my publisher text box when I paste. It's usually something recently pasted. How do I fix this? ...
Long Text Entry
I have a long text entry for a cell and while it accepts it in the data entry area, it does not display all of it in the cell in the spreadsheet. Why is this? Hi the limit is 1024 characters. If you want to display more enter some manual linebreaks with aLT+ENTER -- Regards Frank Kabel Frankfurt, Germany "jaspikes" <jaspikes@discussions.microsoft.com> schrieb im Newsbeitrag news:EA4832DD-1620-48EE-A8A8-BB1618939928@microsoft.com... > I have a long text entry for a cell and while it accepts it in the data entry > area, it does not display all of it in the cell in the...
Center label text vertically?
Is there any way to automatically center the text of each label in Word vertically as opposed to horizontally? I am using the general Label option, not mail merge. In most versions of Word, labels are vertically centered by default. If yours are not centering, make sure you don't have extraneous empty paragraphs. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "AKMMS" <AKMMS@discussions.microsoft.com> wrote in message news:EF359D31-0EAB-416B-8691-FA141E317224@microsoft.com... > Is there any ...
Click a button and add info to where the cursor was on the last text box.
How do I find out where the cursor was last in a text box. For example I will use the | for the cursor in the following: Bob has purchase | from us last week. Now I want to have a list box with all our items in it so the user can click one of the items and it gets inserted right where the cursor was. So the text box should end up looking like: Bob has purchase shovels from us last week. Hi, something like this. Forget about trying to find where the cursor was last in the textbox. After the user has made their selection from the listbox set the value of the textbox. Me.txtbox = &...
XML , text, from xmlwriter.
Is there a simple way to get the text, xml, from an xmlwriter. I have a XML writer that writes to a file, and I want another function to return the text that the xml writer is produced. Any suggestions? MAF wrote: > Is there a simple way to get the text, xml, from an xmlwriter. > > I have a XML writer that writes to a file, and I want another function to > return the text that the xml writer is produced. Use an XmlWriter over a StringWriter e.g. StringWriter stringWriter = new StringWriter(); using (XmlWriter xmlWriter = XmlWriter.Create(stringWriter)) { xmlWrit...
Why do my text boxes disappear from my chart when I click out?
I have manually added text boxes in the chart to label my data points with words. When I click out of the chart, some of them appear on the worksheet behind the chart, and some stay in the chart. I can't figure out why some are there and some aren't. When I am in the chart, they all appear on the chart. I am in Microsoft Office 2000 using Excel and Word. Also, when I go to copy and paste the chart into word, the text doesn't go with it. Instead of inserting a text box, select the chart, and start typing. You'll see the text in the formula bar as you type. Press the...
White space around text in table cell
I want to fill cells in a table with color. Generally I can do this easily. However, I have a table that must have something defined that I can't detect. When I try to fill the cell with color, the cell only fills around the edges, leaving the center portion white. The part that is colored is not the cell borders. I can fix this by re-establishing the text as "normal" and then making it the font/size I want. However, I'm curious about how this anomaly happened so I don't accidentally create this problem again. Does anyone know why this happened? Your parag...
How to have text frame duplicate itself on every page of booklet?
How can I insert a text frame on the first page or pages of a booklet and have it automatically duplicate itself exactly throughout the publication when I insert a long text file? I am using Microsoft Publisher 2000 SR - 1 Not sure what you mean. Page setup, booklet, when Publisher queries about 4 pages, click no. Do your text box, click the insert menu, insert page, tick "Duplicate all objects on page..." If the text file is too long for one page, you will have to copy, paste and link your boxes. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ new...
Funny Characters in Rich Text / HTML Formatted Emails
We run Exchange 2003. One of our users has noticed that when he sends Rich Text or HTML formatted emails to his wife's Hotmail account, some funny characters seem to be interspersed within the body of the message. It seems that when a sentence is split by two spaces, a capital A with a hat on appears. Does anyone know if this is a problem with Exchange or Hotmail? I setup a test email that I know will highlight the issue and got my friends to send it to my Hotmail account from their corporate systems. Their emails display fine! ...
WRAP TEXT #3
I HAVE TRIED TO DO FORMAT, CELLS, ALIGNMENT & WRAP TEXT...IT DOES NOT WORK. I'M TRYING TO DO THIS IN A CELL THAT HAS BEEN MERGED WITH THREE OTHER CELLS TO THE RIGHT. I AM SETTING UP A WORKSHEET TO BE USED AS A LAW FIRM'S INVOICE AND NEED THE CELL WHERE THE NARRATIVE OF SERVICES GOES TO WRAP THE TEXT Lynn First, please turn off CAPS LOCK. Most find it hard to read and is considered "shouting". Second....... Merged cells will allow "wrap text" from Format>Cells>Alignment but.......... Excel has a problem auto-fitting merged cells. You can resize...
Duplicating Text To Another Spreadsheet
I created a form in Word, cut and pasted it into Excel on three different spreadsheets. How can I format the spreadsheet to copy text to the other two spreadsheets without having to enter text three different times? Please advise and thank you in advance Check out Excel help on "select multiple sheets" Gord Dibben MS Excel MVP On Tue, 26 Sep 2006 19:14:17 -0700, "The Inquirer" <sonymw@msn.com> wrote: >I created a form in Word, cut and pasted it into Excel on three different >spreadsheets. >How can I format the spreadsheet to copy text to the oth...
How can I generate a Tag Cloud of words in Excel?
Does anyone know of a plug-in or method to use Excel to generate a 'Tag Cloud' chart / graphic in Excel? I export database records to Excel for detailed analysis using pivot tables, and I'd love to have a way to turn entries in a 'Keyword' field into a tag cloud. Basically this: - Read the contents of a column (field) marked Keyword, in a spreadsheet, where each cell can contain more than one keyword - generate a list of all unique key words (strings) that appear in the cells - count how many times each unique keyword appears in the field - create a graphic ...
Including citation in a text displays title
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel When I try to include a citation from my list of citations into the text that I am editing (APA style), the text included has the following content "(Author, Title-blable-title, year)". <br><br>I need it, of course, to include "(Author, year)" only. <br><br>Please help. Thanks! It probably does so because you have multiple works from the same author in the same year. What you could do is suppress the title by hand. Click within the citation. From...
Random text #2
I have a list of manufacturers and part numbers. I would like to choose 5 random part numbers for each manufacturer. Is there a way to do this in excel? Hi one way: - in a helper column enter =RAND() and copy this down for all rows - now sort with this helper column - use the first 5 entries -- Regards Frank Kabel Frankfurt, Germany Juliejg1 wrote: > I have a list of manufacturers and part numbers. I would like to > choose 5 random part numbers for each manufacturer. Is there a way > to do this in excel? Hi, Frank: If he wants part numbers for just one manufacturer, he sho...
one more text box to a userform
XL2000 I am adding one more text box to a userform to put information in column "BT" ROW "2" in "sheet1" the below code works perfectly so I figured if I installed a new text box and named it "Textwrknmbr" then all I would have to do is add a few lines in the code. i tried and failed please guide me from here down works perfectly Private Sub cmdAdd_Click() Dim r As Long Dim ws As Worksheet Set ws = Worksheets("Parts") With ws If .AutoFilterMode Then If .FilterMode Then .ShowAllData End If End If End With If Applic...
MS Word Header/letterhead margins with Text?
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am working in MSWord 2008 on the Mac. <br> Creating an electronic letterhead. <br><br>I would like to place a narrow listing of names in the right or left margin of a MS word template. This would be a fixed element on the first page of the template. However, if I make this listing a part of the header, it pushes the start of the letter content down too far. <br><br>Is it possible to add this listing to a side margin and make it not interfere with the body of the letter? <br>&l...
OWA appears in a TEXT almost an FTP looking.
G'day all, I have got Win2k3 plus Ex2k3 with SP1 installed. Email internally is fine but the OWA looks terrible, it appears in a text format rather than the funky looking OWA. I dont know what I am doing wrong , I really need some guidance here. I've tried almost all hotfixes, should i do the compression ? Regards eyetea On Sun, 23 Jan 2005 15:57:01 -0800, eyetea <eyetea@discussions.microsoft.com> wrote: >G'day all, > >I have got Win2k3 plus Ex2k3 with SP1 installed. >Email internally is fine but the OWA looks terrible, it appears in a text >format rath...
Outlook 2002 unable to display text/plain INLINE attachments
Anyone else encountered this problem? Any fixes? I'm a email developer and we're firing different combos of MIME headers at a 2002 Outlook client to try and find a combo that it CAN handle. Content-Type: TEXT/PLAIN Content-Disposition: INLINE on a multipart MIME message is still parsed as an "attachment" - and it bungles up an ATTxxxx attachment name for them as well. Outlook Express, Netscape, and other clients correctly display the attachments inline with the message body. direct responses appreciated - rcb at 3k dot com ...
Can't change View Text Size on some messages
On some messages (including some I send as a test to myself) when I view the message in a new window, changing the setting of Text Size under View doesn't do anything. Sometimes it is dimmed out so I can't choose to go from Medium to Large. Is it formatting that makes the difference? I send everything HTML format. I'm sure it's just one setting somewhere. It always is! -- Neil Sorry I meant to say that this was for Outlook 2003. "News Starstream" <ubetcha916@ssctv.net> wrote in message news:T92dnY-Ea_185kPZnZ2dnUVZ_oWdnZ2d@starstream.net... >...
I need to cut, strip out and rearrange a text string into 2 fields
How can I cut text fields in a query like the example below, -0.132861,51.591273,0 where the first part up to the first comma becomes one field, and the second part, excluding the last comma and trailing zero becomes two (new) seperate fields Lon: -0.132861 Lat: 51.591273 a sample list of typcial data that I have to change. coordinates -0.132861,51.591273,0 -0.116207,51.59672,0 -0.101489,51.599326,0 -0.112013,51.5948,0 -0.09749200000000001,51.593865,0 -0.09479799999999999,51.593184,0 -0.111989,51.603028,0 -0.120467,51.598811,0 Take a look at Access HELP on the Left(), Mid(), and InS...
Using .NET Framework 1.1 and Visual Studio .NET 2003. Language is VB.NET. When loading an XML String using XMLDocument.LoadXml we are getting an extra space inserted into abbreviated end tags: objXmlDoc.XmlResolver = Nothing objXmlDoc.LoadXml(XmlData) .... .... objXmlDoc.InnerXml (gets written to database) eg <blah/> becomes <blah /> (note extra space) Is there any way to prevent this from happening?? "Matt Bush" <MattBush@discussions.microsoft.com> wrote in message news:F9F90E12-F137-4F1E-8423-00F1E7E23A1E@microsoft.com... > objXmlDoc.InnerXml (gets writt...
why does some text disappear in Web publication from Publisher?
When I convert a Publisher document to Web then do a Web preview, some text is missing. ...
Dragging text from Notepad to a TextBox
I would like to drag a text from Notepad or any other program and drop it into a textbox. I have not yet been able to figure out how to do that. Can anybody help? "Boris Pauljev" <nordiccoder@hotmail.com> wrote in message news:ei$P%236myKHA.5132@TK2MSFTNGP05.phx.gbl... >I would like to drag a text from Notepad or any other program and drop it >into a textbox. I have not yet been able to figure out how to do that. Can >anybody help? This will not work in Notepad, but I am not sure later OS'es Notepad's support OLE drag drop(In XP it doesn't...
Formula to split Text from Numbers in cell
Hi everyone I have a column of data as follows Joe Bloggs 995.1 Fred 22.6 James Brian Jones 333.54 Ted Baker 3875.34 etc The name can be any number of words and the size of the number changes with each entry. Is there any way to split the text and numbers into two separate columns using a code? I tried using the search command with an isnumeric inside but to no avail...... I also thought of looking for a space from the right hand side but I don't know how to do it. Any suggestions? Thanks John Ortt =LEFT(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(...
Changing from Numeric to Text
Hi, I copy & paste a part number from notepad into a sheet, e.g 7000000002009 and appears as 7E+12.. 2 When I change the whole column to text, the 7E+12 remains and is not converted back to the full value, unless I actually click in the cell edit area at the top of the sheet (sorry don't know exactly what that is called!) How can I set these all to appear correctly? Thanks >-----Original Message----- >Hi, > >I copy & paste a part number from notepad into a sheet, e.g 7000000002009 >and appears as 7E+12.. 2 > >When I change the whole column to text, th...
Why is copy/paste not copying the correct text?
Microsoft Publisher 2003: Occasionally when I copy something from one document, something different appears in my publisher text box when I paste. It's usually something recently pasted. How do I fix this? ...
Long Text Entry
I have a long text entry for a cell and while it accepts it in the data entry area, it does not display all of it in the cell in the spreadsheet. Why is this? Hi the limit is 1024 characters. If you want to display more enter some manual linebreaks with aLT+ENTER -- Regards Frank Kabel Frankfurt, Germany "jaspikes" <jaspikes@discussions.microsoft.com> schrieb im Newsbeitrag news:EA4832DD-1620-48EE-A8A8-BB1618939928@microsoft.com... > I have a long text entry for a cell and while it accepts it in the data entry > area, it does not display all of it in the cell in the...
Center label text vertically?
Is there any way to automatically center the text of each label in Word vertically as opposed to horizontally? I am using the general Label option, not mail merge. In most versions of Word, labels are vertically centered by default. If yours are not centering, make sure you don't have extraneous empty paragraphs. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "AKMMS" <AKMMS@discussions.microsoft.com> wrote in message news:EF359D31-0EAB-416B-8691-FA141E317224@microsoft.com... > Is there any ...
Click a button and add info to where the cursor was on the last text box.
How do I find out where the cursor was last in a text box. For example I will use the | for the cursor in the following: Bob has purchase | from us last week. Now I want to have a list box with all our items in it so the user can click one of the items and it gets inserted right where the cursor was. So the text box should end up looking like: Bob has purchase shovels from us last week. Hi, something like this. Forget about trying to find where the cursor was last in the textbox. After the user has made their selection from the listbox set the value of the textbox. Me.txtbox = &...
XML , text, from xmlwriter.
Is there a simple way to get the text, xml, from an xmlwriter. I have a XML writer that writes to a file, and I want another function to return the text that the xml writer is produced. Any suggestions? MAF wrote: > Is there a simple way to get the text, xml, from an xmlwriter. > > I have a XML writer that writes to a file, and I want another function to > return the text that the xml writer is produced. Use an XmlWriter over a StringWriter e.g. StringWriter stringWriter = new StringWriter(); using (XmlWriter xmlWriter = XmlWriter.Create(stringWriter)) { xmlWrit...
Why do my text boxes disappear from my chart when I click out?
I have manually added text boxes in the chart to label my data points with words. When I click out of the chart, some of them appear on the worksheet behind the chart, and some stay in the chart. I can't figure out why some are there and some aren't. When I am in the chart, they all appear on the chart. I am in Microsoft Office 2000 using Excel and Word. Also, when I go to copy and paste the chart into word, the text doesn't go with it. Instead of inserting a text box, select the chart, and start typing. You'll see the text in the formula bar as you type. Press the...
White space around text in table cell
I want to fill cells in a table with color. Generally I can do this easily. However, I have a table that must have something defined that I can't detect. When I try to fill the cell with color, the cell only fills around the edges, leaving the center portion white. The part that is colored is not the cell borders. I can fix this by re-establishing the text as "normal" and then making it the font/size I want. However, I'm curious about how this anomaly happened so I don't accidentally create this problem again. Does anyone know why this happened? Your parag...
How to have text frame duplicate itself on every page of booklet?
How can I insert a text frame on the first page or pages of a booklet and have it automatically duplicate itself exactly throughout the publication when I insert a long text file? I am using Microsoft Publisher 2000 SR - 1 Not sure what you mean. Page setup, booklet, when Publisher queries about 4 pages, click no. Do your text box, click the insert menu, insert page, tick "Duplicate all objects on page..." If the text file is too long for one page, you will have to copy, paste and link your boxes. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ new...
Funny Characters in Rich Text / HTML Formatted Emails
We run Exchange 2003. One of our users has noticed that when he sends Rich Text or HTML formatted emails to his wife's Hotmail account, some funny characters seem to be interspersed within the body of the message. It seems that when a sentence is split by two spaces, a capital A with a hat on appears. Does anyone know if this is a problem with Exchange or Hotmail? I setup a test email that I know will highlight the issue and got my friends to send it to my Hotmail account from their corporate systems. Their emails display fine! ...
WRAP TEXT #3
I HAVE TRIED TO DO FORMAT, CELLS, ALIGNMENT & WRAP TEXT...IT DOES NOT WORK. I'M TRYING TO DO THIS IN A CELL THAT HAS BEEN MERGED WITH THREE OTHER CELLS TO THE RIGHT. I AM SETTING UP A WORKSHEET TO BE USED AS A LAW FIRM'S INVOICE AND NEED THE CELL WHERE THE NARRATIVE OF SERVICES GOES TO WRAP THE TEXT Lynn First, please turn off CAPS LOCK. Most find it hard to read and is considered "shouting". Second....... Merged cells will allow "wrap text" from Format>Cells>Alignment but.......... Excel has a problem auto-fitting merged cells. You can resize...
Duplicating Text To Another Spreadsheet
I created a form in Word, cut and pasted it into Excel on three different spreadsheets. How can I format the spreadsheet to copy text to the other two spreadsheets without having to enter text three different times? Please advise and thank you in advance Check out Excel help on "select multiple sheets" Gord Dibben MS Excel MVP On Tue, 26 Sep 2006 19:14:17 -0700, "The Inquirer" <sonymw@msn.com> wrote: >I created a form in Word, cut and pasted it into Excel on three different >spreadsheets. >How can I format the spreadsheet to copy text to the oth...
How can I generate a Tag Cloud of words in Excel?
Does anyone know of a plug-in or method to use Excel to generate a 'Tag Cloud' chart / graphic in Excel? I export database records to Excel for detailed analysis using pivot tables, and I'd love to have a way to turn entries in a 'Keyword' field into a tag cloud. Basically this: - Read the contents of a column (field) marked Keyword, in a spreadsheet, where each cell can contain more than one keyword - generate a list of all unique key words (strings) that appear in the cells - count how many times each unique keyword appears in the field - create a graphic ...
Including citation in a text displays title
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel When I try to include a citation from my list of citations into the text that I am editing (APA style), the text included has the following content "(Author, Title-blable-title, year)". <br><br>I need it, of course, to include "(Author, year)" only. <br><br>Please help. Thanks! It probably does so because you have multiple works from the same author in the same year. What you could do is suppress the title by hand. Click within the citation. From...
Random text #2
I have a list of manufacturers and part numbers. I would like to choose 5 random part numbers for each manufacturer. Is there a way to do this in excel? Hi one way: - in a helper column enter =RAND() and copy this down for all rows - now sort with this helper column - use the first 5 entries -- Regards Frank Kabel Frankfurt, Germany Juliejg1 wrote: > I have a list of manufacturers and part numbers. I would like to > choose 5 random part numbers for each manufacturer. Is there a way > to do this in excel? Hi, Frank: If he wants part numbers for just one manufacturer, he sho...
one more text box to a userform
XL2000 I am adding one more text box to a userform to put information in column "BT" ROW "2" in "sheet1" the below code works perfectly so I figured if I installed a new text box and named it "Textwrknmbr" then all I would have to do is add a few lines in the code. i tried and failed please guide me from here down works perfectly Private Sub cmdAdd_Click() Dim r As Long Dim ws As Worksheet Set ws = Worksheets("Parts") With ws If .AutoFilterMode Then If .FilterMode Then .ShowAllData End If End If End With If Applic...
MS Word Header/letterhead margins with Text?
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am working in MSWord 2008 on the Mac. <br> Creating an electronic letterhead. <br><br>I would like to place a narrow listing of names in the right or left margin of a MS word template. This would be a fixed element on the first page of the template. However, if I make this listing a part of the header, it pushes the start of the letter content down too far. <br><br>Is it possible to add this listing to a side margin and make it not interfere with the body of the letter? <br>&l...
OWA appears in a TEXT almost an FTP looking.
G'day all, I have got Win2k3 plus Ex2k3 with SP1 installed. Email internally is fine but the OWA looks terrible, it appears in a text format rather than the funky looking OWA. I dont know what I am doing wrong , I really need some guidance here. I've tried almost all hotfixes, should i do the compression ? Regards eyetea On Sun, 23 Jan 2005 15:57:01 -0800, eyetea <eyetea@discussions.microsoft.com> wrote: >G'day all, > >I have got Win2k3 plus Ex2k3 with SP1 installed. >Email internally is fine but the OWA looks terrible, it appears in a text >format rath...
Outlook 2002 unable to display text/plain INLINE attachments
Anyone else encountered this problem? Any fixes? I'm a email developer and we're firing different combos of MIME headers at a 2002 Outlook client to try and find a combo that it CAN handle. Content-Type: TEXT/PLAIN Content-Disposition: INLINE on a multipart MIME message is still parsed as an "attachment" - and it bungles up an ATTxxxx attachment name for them as well. Outlook Express, Netscape, and other clients correctly display the attachments inline with the message body. direct responses appreciated - rcb at 3k dot com ...
Can't change View Text Size on some messages
On some messages (including some I send as a test to myself) when I view the message in a new window, changing the setting of Text Size under View doesn't do anything. Sometimes it is dimmed out so I can't choose to go from Medium to Large. Is it formatting that makes the difference? I send everything HTML format. I'm sure it's just one setting somewhere. It always is! -- Neil Sorry I meant to say that this was for Outlook 2003. "News Starstream" <ubetcha916@ssctv.net> wrote in message news:T92dnY-Ea_185kPZnZ2dnUVZ_oWdnZ2d@starstream.net... >...
I need to cut, strip out and rearrange a text string into 2 fields
How can I cut text fields in a query like the example below, -0.132861,51.591273,0 where the first part up to the first comma becomes one field, and the second part, excluding the last comma and trailing zero becomes two (new) seperate fields Lon: -0.132861 Lat: 51.591273 a sample list of typcial data that I have to change. coordinates -0.132861,51.591273,0 -0.116207,51.59672,0 -0.101489,51.599326,0 -0.112013,51.5948,0 -0.09749200000000001,51.593865,0 -0.09479799999999999,51.593184,0 -0.111989,51.603028,0 -0.120467,51.598811,0 Take a look at Access HELP on the Left(), Mid(), and InS...