| Author | Message | ||
     Raman Junior Artist Username: Raman Post Number: 153 Registered: 01-2009 Posted From: 159.182.1.4 Rating: N/A |
I used to cut paste word content into notepad and convert | ||
| Guttonkay Side Hero Username: Guttonkay Post Number: 2655 Registered: 05-2008 Posted From: 148.87.19.214 Rating: N/A |
Thanks guys. I am good for now. Saved the thread for future. Will save lot of time next time. | ||
| Der_schuler Side Hero Username: Der_schuler Post Number: 5124 Registered: 01-2009 Posted From: 148.159.160.51 Rating: N/A |
PS its not my code.....online dorikindhi...nenu konchem modify chesanu...but it will work...make sure that the p's in the code are replaced by i's..the iterator variable | ||
| Der_schuler Side Hero Username: Der_schuler Post Number: 5123 Registered: 01-2009 Posted From: 148.159.160.51 Rating: N/A |
Sub GetWord() Dim WordObject As Word.Application Dim Document1 As Word.Document Dim i As Integer Dim Rng1 As Word.Range Dim Strng As String Set WordObject = CreateObject("Word.Application") WordObject.Visible = True Set Document1 = wrdApp.Documents.Open("C:\Temp\GimmeABreak.doc") WordObject.Document1.Add 'Set the scope of the word file With Document1 For i = 1 To .Paragraphs.Count Set Rng1 = .Range(Start:=.Paragraphs(p).Range.Start, _ End:=.Paragraphs(p).Range.End) Strng = Rng1.Text Next i .Close End With WordObject.Quit Set WordObject = Nothing Set Document1 = Nothing End | ||
| Rowdy Comedian Username: Rowdy Post Number: 1548 Registered: 01-2010 Posted From: 12.196.87.201 Rating: N/A |
insert-->table-->Convert text to table idi option ... cheyyandi ... sample file chesi chusanu ... work aindi NHK pelli time ki act ledu, so he didnt do any crime. - N_U | ||
| Der_schuler Side Hero Username: Der_schuler Post Number: 5122 Registered: 01-2009 Posted From: 148.159.160.51 Rating: N/A |
So U can essentially do any thing in the WIth block...read paragraphs.... Write formulas in word and import then into cells.... read tables in to a cell array..... anything that can be done in a spreadsheet can be done... all u need is to write a small macro | ||
| Rowdy Comedian Username: Rowdy Post Number: 1546 Registered: 01-2010 Posted From: 12.196.87.201 Rating: N/A |
word laa ... table-->draw table ane option untundi ... adi teesukuni aa data chuttutaa oka table geeyandi ... ippudu aa table ni copy, paste cheyyandi excel lo ... aipovali naku telisi NHK pelli time ki act ledu, so he didnt do any crime. - N_U | ||
| Der_schuler Side Hero Username: Der_schuler Post Number: 5121 Registered: 01-2009 Posted From: 148.159.160.51 Rating: N/A |
Sub GetWord() Dim WordObject As Word.Application Dim Document1 As Word.Document Dim i As Integer Dim Rng1 As Word.Range Dim Strng As String Set WordObject = CreateObject("Word.Application") WordObject.Visible = True Set Document1 = WordObject.Documents.Add 'Set the scope of the word file With Document1 For i = 1 To .Paragraphs.Count Set Rng1 = .Range(Start:=.Paragraphs(p).Range.Start, _ End:=.Paragraphs(p).Range.End) Strng = Rng1.Text Next i .Close End With WordObject.Quit Set WordObject = Nothing Set Document1 = Nothing End | ||
| Woodpecker Side Hero Username: Woodpecker Post Number: 6165 Registered: 09-2008 Posted From: 161.165.196.84 Rating: N/A |
 | ||
| Guttonkay Side Hero Username: Guttonkay Post Number: 2653 Registered: 05-2008 Posted From: 148.87.19.214 Rating: N/A |
effing thing came in an email. I had to filter it all into word, remove the garbage lines and then convert it to excel. ilanti panulaki india lo ayite secreatary vuntadi  | ||
| Woodpecker Side Hero Username: Woodpecker Post Number: 6164 Registered: 09-2008 Posted From: 161.165.196.84 Rating: N/A |
Step 1Open Microsoft Word and Excel from the desktop menu. In Word, find the document containing the text to be converted. In Excel, open a blank worksheet. Step 2Return to the Word document and confirm that the text appears in true table format. If there are gridlines or a compass symbol enclosed in a box at the top left corner of the first column, the text is a true table. If not, the text appears in columned format only and must be converted to a true table. Step 3Convert columned text to a true table by inserting a tab, a comma or an asterisk in between each row of the columns. Highlight all the text. Click "Table" on the "File" menu and scroll down to "Convert." Step 4Choose the text appearing to the right, "Text to Table." A dialog box opens entitled, "Convert Text to Table." Enter the number of columns and rows. Go down to "Separate Text At" and type in the symbol used to divide the columns. Hit "OK." Step 5Click on the box containing the compass symbol in the top left corner to select the entire table for exporting to Excel. Under "Edit" on the "File" menu, choose "Copy." Switch back to the Excel program and click inside the cell where the table should be placed. Go to "Edit" and choose "Paste." Step 6Format the Excel worksheet to accommodate the table with a new look. Adjust the width of columns and the height of rows so that the text fits neatly. Step 7Keep the same appearance it had in the original Word document by locating the "Paste Options" icon in the lower right corner of the pasted text. Click on the drop-down arrow and choose "Keep Source Formatting." | ||
| Humpty_dumpty Side Hero Username: Humpty_dumpty Post Number: 6167 Registered: 02-2009 Posted From: 38.117.247.14 Rating: N/A |
@GK CSV, dimiliters unnaya | ||
| Guttonkay Side Hero Username: Guttonkay Post Number: 2652 Registered: 05-2008 Posted From: 148.87.19.214 Rating: N/A |
thanks woodpecker. that works. | ||
| Rasputin Moderator Username: Rasputin Post Number: 7480 Registered: 02-2008 Rating: N/A |
Data -> Import external Data -> Import Data GreatBong: The old Sachin radiated heat. The new Sachin gives light. But he still remains the sun | ||
| Idle_yzag Megastar Username: Idle_yzag Post Number: 21913 Registered: 02-2008 Posted From: 198.80.144.187 Rating: N/A |
copy paste chesai attha RahulGandhi/JP/Chiru | ||
| Raogaru Comedian Username: Raogaru Post Number: 1023 Registered: 01-2010 Posted From: 15.219.153.205 Rating: N/A |
tammud how r u నన్ను ఇన్వాల్వు చేయకండి సార్ | ||
| Guttonkay Side Hero Username: Guttonkay Post Number: 2651 Registered: 05-2008 Posted From: 148.87.19.214 Rating: N/A |
rasp, all rows and columns only. No graphs of gifs or links Der, no VB here. This is a simple file with a ton of data that I have to be able to read in excel format. | ||
| Woodpecker Side Hero Username: Woodpecker Post Number: 6163 Registered: 09-2008 Posted From: 161.165.196.84 Rating: N/A |
http://www.ehow.com/how_2096574_convert-microsoft-word-table -excel.html | ||
| Der_schuler Side Hero Username: Der_schuler Post Number: 5120 Registered: 01-2009 Posted From: 148.159.160.51 Rating: N/A |
Excel ki unna ekaika adv is its COM capability which liases word etc seamlessly | ||
| Raogaru Comedian Username: Raogaru Post Number: 1022 Registered: 01-2010 Posted From: 15.219.153.205 Rating: N/A |
word lo copy chesi...excel lo paste special ani option choodandi నన్ను ఇన్వాల్వు చేయకండి సార్ | ||
| Der_schuler Side Hero Username: Der_schuler Post Number: 5119 Registered: 01-2009 Posted From: 148.159.160.51 Rating: N/A |
VBA code rasthara meeru....vaste Application.Word object instantiate cheyyandi chaalu | ||
| Rasputin Moderator Username: Rasputin Post Number: 7478 Registered: 02-2008 Rating: N/A |
word lo content ela undi? rows and colums laaga untey very simple. bommal, paragraphs etc untey, emo mari GreatBong: The old Sachin radiated heat. The new Sachin gives light. But he still remains the sun | ||
| Guttonkay Side Hero Username: Guttonkay Post Number: 2649 Registered: 05-2008 Posted From: 148.87.19.214 Rating: N/A |
word file lo vunna content ni excel lo ki convert ela cheyyalo evarikanna telusa? TIA |
