Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not Any assistance appreciated. Writing Word Macros focuses on these essential objects, but includes a discussion of a great many more objects as well. I try to put down my adventures with Technology and other DIY stuff here. have a peek at this web-site
As a guest, you can read any forum posting. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... You may have to register before you can post: click the register link above to proceed. How does Energy Field interact with effects that say you lose life? http://windowssecrets.com/forums/showthread.php/161136-VBA-Word-Tables
By creating what is commonly called a "Word Macro" you...https://books.google.com/books/about/Writing_Word_Macros.html?id=C7oZZMt9sqkC&utm_source=gb-gplus-shareWriting Word MacrosMy libraryHelpAdvanced Book SearchGet print bookNo eBook availableO'ReillyAmazon.comBarnes&Noble.com - $20.75 and upBooks-A-MillionIndieBoundFind in a libraryAll sellers»Get Textbooks on Google PlayRent Helmut Weber 2008-11-25 17:16:06 UTC PermalinkRaw Message Hi Pam,Post by PamI have a table in Word 2007 in which I want the first column to be 1 inch andthe second column Does the reciprocal of a probability represent anything? Why is the FBI making such a big deal out Hillary Clinton's private email server?
You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Mar 19th, 2014,09:02 PM #10 Norie Board Regular Join Date Apr 2004 Location Stirling Posts 70,170 Re: Edit Word It's been set as : Code: Set objWord = CreateObject("Word.Application") Set objDoc = objWord.Documents.Open(path_template_report) Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Mar 19th, 2014,04:41 PM #6 microsoft.public.word.vba.general Discussion: Table Column Width (too old to reply) Pam 2008-11-25 16:22:06 UTC PermalinkRaw Message I have a table in Word 2007 in which I want the first column to be
Select last cell in 2nd column. Please try the request again. The macro is: Sub TimeRow() ' ' TimeRow Macro ' Written 1/1/2002 by John Wm Beckner ' ' Checks Last Row, 2nd column cell contents. http://www.vbaexpress.com/forum/showthread.php?53450-Run-time-error-5992-Cannot-access-individual-columns-in-this-collection-because The time now is 08:45 PM.
I tried recording the keystrokes, but Iget this error: Run-time error 5992: Cannot access individual columns inthis collection because the table has mixed cell widths. objWord.Selection.Paste Application.CutCopyMode = False 'CUSTOMIZE THE TABLE (the newest) With objDoc.Tables(objDoc.Tables.Count) .AutoFitBehavior wdAutoFitWindow 'fit to the page .Rows.SetHeight RowHeight:=objWord.CentimetersToPoints(0.5), HeightRule:=wdRowHeightExactly 'adjust row height End With 'Close Excel file Workbooks(SelectedModules).Close SaveChanges:=False Set Reply With Quote Mar 19th, 2014,06:05 PM #7 AlexDarsigny New Member Join Date Mar 2014 Posts 10 Re: Edit Word Table columns width from Excel vba macro Do you think that This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers.
Code: Dim tbl As Table Set tbl = Me.Tables(1) ' Me is the document the code is in tbl.Columns(1).Width = Application.CentimetersToPoints(3) tbl.Columns(2).Width = Application.CentimetersToPoints(6) Share Share this post on Digg Del.icio.us http://www.mrexcel.com/forum/excel-questions/765348-edit-word-table-columns-width-excel-visual-basic-applications-macro.html The time now is 08:45 PM. It takes just 2 minutes to sign up (and it's free!). I tried recording the keystrokes, but Iget this error: Run-time error 5992: Cannot access individual columns inthis collection because the table has mixed cell widths.
Share Share this post on Digg Del.icio.us Technorati Twitter If posting code please use code tags. Sign up now! Id be interested to know what typename(f.Parent) returns on your system. –user1379931 Sep 3 '14 at 17:33 add a comment| Your Answer draft saved draft discarded Sign up or log Source Similar Threads Run-time error '5992': Word was unable to open the data source mjokins, Nov 5, 2003, in forum: VBA Developer Replies: 0 Views: 440 mjokins Nov 5, 2003 VBA error
Join them; it only takes a minute: Sign up MS word Formula not running properly giving error Run-time error '5992' up vote 0 down vote favorite Sub DelXRows() Dim oTbl As Preview this book » What people are saying-Write a reviewWe haven't found any reviews in the usual places.Selected pagesTitle PageIndexContentsIntroduction1 Preliminaries6 Programming Style8 The VBA Environment15 Document Events TuQ VlSUCll BCISIC Another word for something which updates itself automatically A weird and spooky clock Why was Vader surprised that Obi-Wan's body disappeared?
It became clear that this is limitation of Word VBA interface and I need to look for work arounds. Thread Tools Display Modes
Stefan Blom 2013-07-15 19:34:19 UTC PermalinkRaw Message Since this newsgroup gets less attention these days, you may want to repostin the programming forum in the Microsoft Community:http://answers.microsoft.com/en-us/office/forum/customize?tab=all--Stefan BlomMicrosoft Word MVPPost by Where can I get a file/list of the common and scientific names of species? This tutorial is reinforced by interesting and useful examples that solve practical programming problems, like generating tables of a particular format, managing shortcut keys, creating fax cover sheets, and reformatting documents.Writing have a peek here No, create an account now.
BeyondCompare report uses tables and it had a few rows that spanned across multiple columns. I can't get thecolumns to be two separate widths. The code below worked fine yesterday and correctly formatted any > 6 column tables. His previous books with O'Reilly include "Access Database Design and Programming", "Writing Excel Macros with VBA", and "Win32 API Programming with Visual Basic".
Read, highlight, and take notes, across web, tablet, and phone.Go to Google Play Now »Writing Word MacrosSteven Roman"O'Reilly Media, Inc.", 1999 - Computers - 388 pages 0 Reviewshttps://books.google.com/books/about/Writing_Word_Macros.html?id=C7oZZMt9sqkCMany Microsoft Word users Code: With objDoc.Tables(objDoc.Tables.Count) .AutoFitBehavior wdAutoFitWindow 'fit to the page .Rows.SetHeight RowHeight:=objWord.CentimetersToPoints(0.5), HeightRule:=wdRowHeightExactly 'adjust row height .Columns.SetWidth ColumnWidth:=objWord.CentimetersToPoints(0.5), RulerStyle:=wdAdjustSameWidth End With Share Share this post on Digg Del.icio.us Technorati Twitter If posting Contact Us - Wrox - Privacy Statement - Top Powered by vBulletin Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. © 2013 John Wiley & Sons, Inc. Writing Word Macros (previously titled Learning Word Programming is the introduction to Word VBA that allows you to do these things and more, including: Create custom pop-up menus Automatically create tables
Code: Sub test() folder_Modules_xls = "C:\Modules" path_template_report = "C:\template_report.docx" 'Get all the selected modules and deduct Bookmarks by removing extension (*.xls or *.xlsx) SelectedModules = "test.xlsx" 'OPEN main Word File Set The system returned: (22) Invalid argument The remote host or network may be down.