Replies

I have tested the animations by clicking thru teh sliodes and no animation occurs. When I click everything on the slide appears at once with no entrance animations at all. Any ither ideas? Is there a way via VBA to set all slides equal to the master?

Caria,
Thank you for replying so quickly. I am not well versed in PP and so I don’t know the answer to your question. What I can tell you is that within the menus I goto View->Master->Slide Master and on the silde that appears I have setup some custom animations. When I hover the cursor over the smaller slide image on the left side of the screen the tooltip reads ‘Default Design Slide Master: Used by slide(s) 1-40’. I have checked these slides and they do not use the custom animation that I have set for the master. Does that help answer your question?

Thanks. That worked perfectly. It took a few tries to get the part about having to click and plcae the cursor in the ‘Find’ or ‘Replace’ bof to specify the Formating for that item. It’s not exactly intuitive when you don’t know it. Microsoft probably could have designed that interface a little better or allowed for it to work for morethen one way.

Ed

Thanks! That worked perfectly. I knew there had to be some easy way of doing this I just didn’t think to try the menus. I’ve become so use to having to go with functions for advanced stuff that I didn’t even consider that there might be a built-in menu driven feature to do this.

Legare,
First let me thank you for your contribution to this post. I appreciate your posting your code even after a working version was mentioned. Your code looks shorter and cleaner. Do you know if it performs better then the code from Microsoft’s KB Article? I also wanted to mention that when I try to copy the second instance of your code it copies as a single line where as the first has carriage returns and copies and pastes exactly as it looks. Are the differences simple enough for you to quickly pint out? I can reformat the second code instance if need be but I figured if the changes were small enough it would be easier if you could just point them out.

Lastly I wanted to know if it is OK to use your code? I have a client who uses an Excel Add-in my company produces and they are looking for a way to convert some of the cells values from numbers to their English Words. I figured it is OK to pass this code along to them since you posted it however I felt it was the proper thing to check with you first. I prefer explicit to implicit any day.

A big thanks to Steve and Kevin(KWeaver); Appreaciate you guys replies too.

Thanks Again!
Ed

Jan,
First let me say thansk for all yoru efforts. I appreciate you giving it as much as you have. Unfortunately I can’t use your suggestion. It’s not possible to know in adanace what the name of the ‘New’ workbook will be as the name changes and is based on the person who runs it combined with what criteria they use and what date and time they run it as of.

Thanks anyway.

Ed

I did some qucik testing and it appears that code behind the sheet will make it all the way thru. The problem now is what event to use for the code?

Jan,
The Workbook is allowed Macros but the problem there is when to trip the macro. In fact there is nothing preventing the inclusion of code modules of both regular and class modules. Again though the problem is how to call these macros or procedures when the report is being automatically processed? I can’t call them until the Add-In is done and when the report is automatically processed the end result is a new Workbook that is based on the orginal after it has been processed. This unfoortunately results in missing customo code. When the new workbook is generated the way this is done does not allow for the copyiong over to the new workbook of any custom code in the workbook. And so if my workbook has macros they are not a part of the final workbook that is generated when the Batch Reporting product is used. Now when the user runs the report to screen custom macros are an option. Unfortunately it’s not for me because whatever I do it must work under both scenarios.

Thanks
Ed

Thanks for the tips Jan but neither will work. Thsi is because the solution used must be automated so that no user input is required during the processing. This is because ther are times when the rpeort is processed and saved automatically by a batch reporting tool. The only time a solution that inivolves direct user input can be used is when that user input is during the design mode of the report and not run-time. Thanks again though. Your tips have given me some good ideas on how to deal with some other Excel related issues seperate form this one and the Excel Add-In I speak of.

Ed

I’m sorry Jan, but I don’t follow what your saying. I will tell you this and it may answer your question, I have no control over the process itself meaning I can’t control how the reprt is created in YSL. I can only change the ‘Template’ (T-Income) that the final worksheet (Income) is based on. In other words I can’t change how the Excel Add-In works.

Ed

Hans, If the formual runs for each record that is not a problem ebcause all the charges for a individual will be in a single record. The way the process works is it takes 0 to N number of charges and flattens them out so that there is a single record with many columns and each column contains info about one of the unpaid charges. Now we do have to setup a max number of items in teh rpeort so that now record will contain more then 10 charges and that’s OK. If a person has less then 10 charges then the extra columns for unused charge fields are blank or 0. Now that you know that all the hcarges are in a single record should I be able to perform the SUM operation you originally mentioned?

Thanks
Ed

Thanks for the info but unfortunately I have to use a method that does not require editing the document during or after the merge. My companies program calls the mail merge programmatically and saves the resulting merge doc to a network share so that the process is automated once the intial doc design is done. Do you know if the method you list will work if I place the formula in the last row of the table and can guarantee that the last row will not contain any merge data?

Thanks
Ed

Stuart,
Thanks for the leads but what I

That is the link to download the doc & slideshow of this product but it does not include teh actual Excel add-in or any details on how to use this product. I am assuming the product is something that is available to the general public. If M$ planned to keep it private for internal use I don’t think they would publish this document publically.

Thanks
Ed

Unfortunately no.