Stumbleupon Facebook Twitter Digg Google Delicious Linkedin
TechNews

Office News Buzz

Feed

using an external storage device for data in microsoft works word

Office

Question:can you help me to access data held on a compound word work-format external storage device - get the error messages for a particular when file all the other filescan be opened without problems. It only happened very recently - all ideasAnswer:Opening of documents directly from external media is a rich source of corruption of the document and should be avoided. Always work from the hard disk...Read More

Posted: 13 May 2012

Tags: using an external storage device for data in microsoft works word using external storage device for data microsoft works word


code VBA to move data from the cell to the left (step to the right)

code VBA to move data from the cell to the left (step to the right)

Office

Question:I have vba code provided for me several months ago by a member of the Star community on this forum. I now need to adjust the code slightly, and I do not know how to edit properly. I am not quite familiar with macros. Previous code has moved to the right data. I need now for new data to be moved to the left. The vba code I have is:Option explicitSub ShiftFilteredRows()Dim rg As Range, rw As...Read More

Posted: 12 May 2012

Tags: code VBA to move data from the cell to the left step to the right code VBA move data from the cell left step right


Please help me to adapt this macro to define WrapFormat to all images in a document

Please help me to adapt this macro to define WrapFormat to all images in a document

Office

Question:I found a macro posted to Microsoft by Jay Freedman responses on 13 January 2012 - converts an InlineShape shaped and then sets the WrapBehind WrapFormat. This macro code is as follows:X() {sub}Dim SLI as InlineShapeDim shp as shapeSet ActiveDocument.InlineShapes = SLI (1)Set shp = SLI.ConvertToShape methodWith shp.WrapFormat.Type = wdWrapBehind.RelativeVerticalPosition = wdRelativeVerticalPositionMargin...Read More

Posted: 10 May 2012

Tags: Please help me to adapt this macro to define WrapFormat to all images in a document Please help adapt this macro define WrapFormat all images document


How to use vba to move a shape from one position to another?

How to use vba to move a shape from one position to another?

Office

Question:I would like to move a shape on a slide PowerPoint 2007 from one position to another then existing only in the presentation mode. I want to click on a different (existing) form to launch the movement. My knowledge of vba is minimal. Attempts by msoAnimEffectFly work only once. Attempts to use of msoAnimTypeMotion did not work at all. Some examples of code would help.Answer:I would never use...Read More

Posted: 10 May 2012

Tags: How to use vba to move a shape from one position to another How use vba move shape from one position another


I created a model for a magazine editorial calendar

I created a model for a magazine editorial calendar

Office

Question:As the row object, I created a model for a magazine editorial calendar. After search the model database and does not find one, I made a me and was hoping to share with the Gallery, as well as others could use it as their base model. I have the shared with a number of my colleagues editors and all loved him so much...Answer:HI NancySee the link with the same question.http://answers.Microsoft...Read More

Posted: 09 May 2012

Tags: I created a model for a magazine editorial calendar created model for magazine editorial calendar