On Wed, 17 Jun 2009 22:48:02 -0700, fmamstr <fmamstr@discussions.microsoft.com Currently I met a problem for Office Development. The problem is below: we are developing Office add-ins, one feature is trying to insert some images into a PowerPoint "slide", at the first beginning in a typical first slide, there is a "Title" and "SubTitle" text box, then we insert 2 pictures which got from another Excel process, we use "ClipBoard" and Slide.Shapes.PasteSpecial(), and the 2 pictures are na...

On Thu, 4 Jun 2009 21:39:01 -0700, dgold82 <dgold82@discussions.microsoft.com I have a worksheet that only contains 5 columns. The rest are hidden. Is there a way to center the displayed columns in the middle of my screen when excel is maximized. Think about if you go to weather.com--my 17 inch laptop screen can probably display almost 2 explorer screens side by side but if you maximize the screen the webpage is centered. I would like to do this in my excel worksheet page when maximiz...

On Fri, 29 May 2009 02:49:01 -0700, Bartosz <bartborySP@Mo2.pl Hello, I made macro wich repace texts in other one in many Excel files (using replace method). I think about making report after to know how many changes was made in each files: text to replace new text aaaa bbbbb cc XXXXX ..... Files: 1.xls, 2.xls Repor: File sheet text to replace new text count 1.xls Sheet1 aaaa bbbbb 3...

On Sun, 10 May 2009 22:40:01 -0700, Poppe <Poppe@discussions.microsoft.com Hello It seems my fridays reply did not post here at all. Anyways, i tried your code and we are close to the answer. This code basically removes commas. I was thinking about the situation, and concluded that what we need to accomplish is to convert all commas into dots, and all dots into commas. This would result in perfectly working code, and it wouldn't matter where the commas/dots are, as it changes every o...