Replies

OK I just read it again and very slow this time and no where in the original post did I say I installed Office 2007 and then installed Office 2003. I think I know why you think I did and it;s because you’re changing the tense of a word in my last sentence.

the last sentence I said it happened before I installed Office 2007 and after installing Office 2003.

Ed C

Steve,
The use of len substitue does help locate many examples of this however you have to know part of the solution to know to use these keywords. I added the post with the specific wording I did so as to make it easier for others to find this same answer. It seems like too often the right keywords aren’t located with a piece of info unless it is in response to a question from another as is the case with these forums.

Thanks
Ed

Jezaa,

ARRRRGGGHHHH( done in the sound of the typical South Atlantic Pirate-nese) you be right about that blatsed paren. I guess it walked it the plank

Ed

UPDATE:

I had some time and was going to revisit this issue so I loaded up the Google Maps URL so as to get the err msg I nromally do when I realized the thing had gone away. I no longer have the problem I originally reported. I’ve made no changes to Offcie that I know of nor have I installed/uninstalled and office related technologies other then installing whatever Service Packs/Hot Fixes related to office that the WIndows Update would automatically download.

I’m not companing this has happened, just suprised.

FYI…. For the post regaring installing office versions out of order, Thansk for the Google link however I did install Office in the correct order adn was unable to find anything about this issue in the Google search. I have re-read my orginal post serval times and have no idea how you got from it that I had installed Office versions out of order.

Anyone know why they would remove the ‘Combine’ & ‘Subscribe’ actions? This would seem like the products being downgraded and not upgraded to me.

Any thoughts?

Ed C

PC@SR,

You can use OneNote 2003 SP1+ to do exactly what you are trying to. The key is that the original version of OneNote 2003 will not work, you have to be on SP1. I say SP1 however it’s been a few years since I discovered this feature and so it may be as of SP2 for OneNote that the collaboration feature was enabled but it’s definitely there.

What you do is create a Shared Notebook somewhere on the LAN where all persons who will work on the item can access it either via mapped drive or a UNC (i.e. COMPUTERSHARE_NAME).

The Shared Notebook feature is really slick and does allow multiple users to access and edit in real-time. Updates made by one are pushed back to all who are accessing the Notebook. Now I’ve never tried using it with many users, all of my experience has been with just a few users at a time.

I realize that OneNote doesn’t offer the same Rich environment for document work that Word does however if you already have OneNote then it’s a solution you can use at no extra cost. OneNote has a ‘Send To Word’ feature so once you’re ready to generate an actual document file you can do so without a lot of extra work.

If you decide to give OneNote a try, please post back to this board and let us know how it went, what your experience was with using this collaboration feature for many users.

Hope that Helps!

Ed Carden
Software Consultant
Yardi Solutions Limited
YSLGuru@Mebtel.Net
AOL IM ID: YSLGuru

OL2007 is a component of Office 2007 but in your prior post you referred to Office 2007 (the suite) and not Outlook (A compnent of the suite) and so I wanted to reiterate that the performance issues are only with OL and no other part of Office 2007.

The performance issue in OL2007 is common enough that Microsoft posted an update/fix for it; see Microsoft KB933493.

Unloading every Addin in OL and removing SBCM (Small Business Contact Manager) seems to have made a huge diffeence however OL still has intermitent lockups and slow response times. It also appears to have effected other components of the Office 2003 suite. When upgrading to Office 2007 I choose to keep Word & Excel 2003 (for work related purposes) and not install Excel or Word 2007; leaving only the 2003 versions for Word & Excel on my system. When I go to open Excel or Word, they now often hang for several minutes. In the case of Excel, when I double-click on an XLS file, Excel launches and finally opens after 1 – 2 minutes but it usually does not load/open the XLS file ) double-clicked on. This started happening after I installed Office 2007.

Thanks
Ed

Not Office 2007, just Outlook 2007. Do a search on Google using OL 2007 & Slow and you’ll see a lot of examples of user horror sstories. If you have a new or realtively small pst file you may not be experiencing perofrmance issues with OL.

Bill,

I don;t know if this is applicable to your situation or not but it can’t hurt…

See M$ Knowledge Base item 933493 ‘Overview – This update fixes a problem in which a calendar item that is marked as private is opened if it is found by using the Search Desktop feature. The update also fixes performance issues that occur when you work with items in a large .pst file or .ost file.’ .

Ed

Thanks to both of you forprovindg this simple example. I knew it was doable and not hard. What I don;t get is why the code I was using wouldn’t work. I had the code set like this:

Dim rPins As Range
Set rPins = Range(Selection, Selection.End(xlToRight)).Select

If I break out the select and range asigment as separte actions then they work:

Dim rPins As Range
Range(Selection, Selection.End(xlToRight)).Select
Set rPins = Selection

Why does my first code example fail?

Now that I’ve got help with this I;d like to ask one more question. Once I have the range assigned what is the best way to iterate through the range and take the value of each cell in the range and so something with? For example if I wanted to take the values (all text) in each cell within the range and concatenate them what would be an example of how to do that.

Thansk again guys!

First let me apolagize for taking so long to reply to everyone’s replies to my query. I have been on the road, traveling for business, for many weeks and I am just now getting to where I can follow up with this post.

Second I’d like to thank everyone for their input; it’s clear that everyone that has posted has taken time to give this some thought and provide some great suggestions. I will try to address everyone’s questions as well as provide comments on the comments so as to clarify some questions about this issue:

1) The Excel Addin was created by my company and while our development dept can change it I am not suppose to. I haven’t approached our dev people about making a special build for this because they frown on that and are highly unlikley to do it anyway because they are all so busy with normal day to day tasks.

2) Asking the client to step thru the code or perform any other development like task is not a good idea in this case due to the lack of technical know how on the clients part. Whatever I have the client do must stay within the bounds of working in a spreadsheet.

3) The error is reproduceable only when Excel is loaded and used on the clients Citrix server. This happens with any XLS file that the client uses for my companies product and that is done on the Citrix server.

4) The workbook contains no charts or graphs or any other type of object like a pivot table. There are only worksheets that contain either literal values, cell refs or formulas. No other custom code is used or are there any external cell refs or refs to other code or objects.

5) The code module that contains the line: WorkSheets(TargetSheet).Calculate is within a regular code modul and not a class module.

I hope that’s enough to answer evryone’s questions who has been kind enough to offer up some suggestions. I look forward to your responses.

Thanks Again to everyone!
Ed

Dean,
I have not tried steping thru the code because I don’t have access to the clients Citrix server. I also can’t change the code because it would be in violation of our company’s policy towards editing code used by clients. I could modify the code on my own machine for testing purposes but I’m noy suppose to place any altered code on a clients system. Any other thoughts?

Thanks
Ed

I’d like to thank everyone for their responses. What I need is a template that is for creating new Guides or publications like a Technical Users Guide. I was hoping for a template so that all the headings and structure would be established and I could simply fill in the information within the appropriate location. This needs to easily distributable whcih is why I started out trying to use Word. As great as One NOte is, what I am looking for needs more structure. I’m not ken on any program outside of Office that is not commonly found on systems or that requires the program itself to view the file. For example a PDF file would be fine because anyone can get the Adobe Reader for free.

I’m happy to say that as I was composing this reply to my own post I stumbled across what I was looking for. Word comes with a set of Templates and within these is a tab labeled ‘Publications’ that contains a template named ‘Manual’ that appears to be exactly what I was looking for. I’m suprised that no one suggested this template.

A big thanks again to everyone that responded. Just as always, Woody’s Lounge proves again why it is #1 in my book of user groups.

Take Care Everyone and as my friends and I said back in the day (that would be the 80’s) WORD!

Do You Remember the 80’s?

That was the first place I checked and I was very suprised to not find anything along the limes of what I am looking for.

Caria,
hanks for the rpely but I don’t understand how to do what you are saying. I have the view set to normal and I have multi-selected several of the thumbnail slides on the left side of the screen but then what do I do next? The Custom Animation section on the right side has no buttons enabled so how do I apply an animation to a group of slides?

Again thanks very much for replying so quickly.

Ed