mso

[mso] Re: Filters in Office 2007 (Kathleen Scherer)

I don't know why - but I tried again and it works. I wonder if it is because I am opening up an old 2003 file? Random -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [] On Behalf Of Kathleen Scherer Sent: Friday, November 20, 2009 11:08 AM ...

[mso] Filters in Office 2007 (Kathleen Scherer)

I just got office 2007 on my computer. When I filter s set of data. In the past I could copy/paste to another document. The data that would paste was only the data that I had filtered down to. Today I did this. When I selected paste special values in my second document.......it pasted all the data in there not just the data I had filtered down to. ...

[mso] Re: strange paragraph symbol and dots between each word (David Smart)

Dave R Note that this display mode doesn't actually change how the document is stored or how it is printed, so having it on doesn't cause problems. It's simply a more detailed display to allow you to be more precise with how your lay out your document. For instance, groups of lines might end with other than paragraph breaks - this display shows what has caused the line break. Also the dots are where your explicit spaces are - thus allowing you to see where Word has adjusted the alignment, or where you've inserted an ...

[mso] Re: strange paragraph symbol and dots between each word (dave ricketts)

David Grugeon, you sir are a saint! Thank you very much, man. My headache is gone. all the best, Dave Ricketts --- On Wed, 11/18/09, David Grugeon david@xxxxxxxxxxxxxx wrote: From: David Grugeon david@xxxxxxxxxxxxxx ...

[mso] Re: strange paragraph symbol and dots between each word (David Grugeon)

Click the symbol like a reverse P on the toolbar. Best Regards David Grugeon -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [] On Behalf Of dave ricketts Sent: Thursday, 19 November 2009 10:44 AM To: mso@xxxxxxxxxxxxx ...

[mso] strange paragraph symbol and dots between each word (dave ricketts)

How do I remove the paragraph symbol and the dots between each word? I don't know what I did, but it may have happened when I used the right-click button. The crazy part, to me at least, is that it has affected each document I have. lost, Dave ...

[mso] Re: Excel VBA Code (Herbert Chitate)

Thanks for the code Hutch, I will let you know how I get on . Much appreciated Herbert -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [] On Behalf Of Thomas Hutchins Sent: 12 November 2009 23:42 To: mso@xxxxxxxxxxxxx ...

[mso] Re: Combine Multiple Word Files? (Alan Bell)

The files are in order. I don't know VBA. But I didn't know I could insert one text file into another. That helped. Thanks. -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [] On Behalf Of Green Sent: Friday, November 13, 2009 9:47 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Combine Multiple Word Files? ...

[mso] Re: Combine Multiple Word Files? (Green)

Hi Alan, You can use Insert... either from the menus or as a VBA command. If you use VBA then you can use the FileSystemObject to create a list of files. Are the files sorted in order? HTH Lisa ...

[mso] Combine Multiple Word Files? (Alan Bell)

I have 30 chapters of a book in separate Word files that I want to combine into one Word file. In the past I have opened each one and cut and pasted to a new combined file. Is there an easier way? ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx ...

[mso] Re: Win XP Slows to a crawl after Office 2007 Install (Jonathan Drawer)

The MS Office installation likes to install a portion that starts on bootup that runs in the background and is supposed to make Office load faster when you open it. On my systems it has also installed a program that automatically scans and indexes the files on the hard drive. I always remove those two functions and anything else that runs when I am not using Office. Look in the Start -- Programs -- Startup folder to see if there is something being started from there. Move it out if you don't need it. Use CTRL+ALT+Delete to look at what programs are running when Office is not running and see if any might be related to Office. ...

[mso] Re: Excel VBA Code (Thomas Hutchins)

Hi Herbert, Try this macro. Select the cell in column A of the first row of data before running it. Sub MakeIndexPage() Dim x As Integer, CurrItem As String Dim StartRow As Long, CurrRow As Long, FinalRow As Long '!!! active cell must be in column A in first row of data !!! StartRow = ActiveCell.Row ...

[mso] Re: Win XP Slows to a crawl after Office 2007 Install (David Grugeon)

What applications are open? How many processes are running and what are the key ones using most CPU and memory? For example, when it is slow are Outlook and OFFLB.exe running? If so how much memory do they take up? What proportion of CPU cycles? Best Regards David Grugeon -----Original Message----- ...

[mso] Re: Win XP Slows to a crawl after Office 2007 Install (David Smart)

You'll need to be more specific in your description ... ... with plenty of HD and memory. How much memory? How much FREE HDD space? ... it got slower ... What is it? Is the whole computer now slower in all operations (booting, Windows explorer, text editors, etc), or is it just that Office 2007 is ...

[mso] Win XP Slows to a crawl after Office 2007 Install (larryspcremedies)

Hi guys, Win XP Pro installed on a Dell laptop with plenty of HD and memory. While it hasn't been really speedy for a while, after I installed Office 2007 ... man oh man ... it got slower than the Slowski's (of DSL fame), can handle. Does anyone have any thoughts? Point me somewhere that can help? Tks Larry ...

[mso] Outllook 2002 in Windows 7 problem (Paul)

I have never used Outlook to any extent so I can't really say for sure whether this a Windows 7 problem or not. I started using Outlook when I upgraded to 7 but it does not save my passwords when I close it. Each time I start Outlook I have to enter the passwords for all of my email accounts. I tick the box that says save passwords every time. It saves the passwords as long as the program is running but they disappear when it is shut down. Is there a setting somewhere that I can change to fix this? Paul in Pa ...

[mso] Re: Word 2007 crashing (Tim Schoon)

Geoff, That worked perfectly! I'm going to bookmark that link in case it happens again! Took a minute or so to fully open up, but the document I tested it on was opened when I double clicked on it. Thanks so much! ----- Tim ...

[mso] Re: Word 2007 crashing (Geoff Culbertson)

Tim, I had a similar problem to you, with documents opening and being unable to move the cursor except with the arrow keys. I contacted Microsoft at the time and they just told me my login had become corrupted and to create a new login. However some months later I came across a Microsoft KB article which obviously showed lots of people had had the same problem. The KB article took you through how to get rid of the problem and it worked. Go to ...

[mso] Re: Access 2003 SaveAs (Green)

Okay... I've built a procedure that seems to work okay and copies the current DB to a new file. It depends on the fact that the FileSystemObject will copy a database even if it's open. What isn't mentioned anywhere I could find, is that it copies the last saved state. So as this is mostly to save VBA versions rather than anything else I hit the save button in the IDE then run the procedure. ...

[mso] Re: Word 2007 crashing (Tim Schoon)

Linda, Sadly, that didn't work. After deleting normal.dot I pulled up the paper I was writing for class, and not only did Word open without a blank document or my paper (as would be expected), it just opened without a document (I had double-clicked on the .docx file). I discovered as I began making suggested edits that I could not click to move the cursor within Word - I had to use the arrow keys on the keyboard. I couldn't highlight anything either. I was able to save my changes, but right after I clicked the X to close word, it said Microsoft Office was checking for a solution to this problem, then came ...

[mso] Re: Access 2003 SaveAs (Green)

Yeah... I think you may be right... Googled quite a bit but no luck really. Thought of replication but that won't work either I think. What I've settled for at the moment is a desktop shortcut to a bat file that does the copying and then opens the file. But it's not pretty. Lisa ...

[mso] Re: Access 2003 SaveAs (David Smart)

I have a feeling that you won't be able to do it from VBA. Notice that when you do it through the menus, it closes out the main database window before doing the backup. This is similar to tools such as the compact/repair and means that Access is actually closing the database before doing the activity. This would close out any VBA that was running, too. You could possibly do it with a VB program, running externally to Access. Alternatively, have a look at a Google search of the subject. There are many ways that people have fudged backups. ...

[mso] Re: Access 2003 SaveAs (Green)

No worries Doug, And thanks for the info. Yes I saw the backup option but I'd really like to be able to do it from VBA... Any ideas? Is the date enough for you? When I'm doing that I normally inlude the time as well. Incrementing a number obviates that though because the highest number is always the last updated and there's always the possibility of sorting the folder on date/time. ...

[mso] Re: Access 2003 SaveAs (Doug Gay)

Lisa: Sorry. I mostly use 2007 which lets one save the entire DB. In 2003 use the Back Up Database and name the saved file as you like. I do a similar thing but append the date I am making a version. Tx, Doug ----- Original Message ----- From: Green 1z@xxxxxxxxxxxxxx To: mso@xxxxxxxxxxxxx Sent: Friday, November 06, 2009 2:40 PM Subject: [mso] Re: Access 2003 SaveAs ...

[mso] Re: Access 2003 SaveAs (Green)

Hi Doug, Can you give me the menu commands for that please? I can Save and SaveAs for one of the objects in the database... but the whole databese has Save and SaveAs greyed out for me. Lisa Why not use Access's save as command. First Save which will save ABFE ...

[mso] Re: Access 2003 SaveAs (Doug Gay)

Why not use Access's save as command. First Save which will save ABFE as ABFE then save as and when prompted for a file name ABFE will default so just add the version you want to the end (for example 8) and save it as ABFE8. Regards, Doug ----- Original Message ----- From: Green 1z@xxxxxxxxxxxxxx To: mso@xxxxxxxxxxxxx ...

[mso] Access 2003 SaveAs (Green)

Hi, I'm pretty sure this may be an old question because I can't imagine it hasn't been addressed before... so apologies in advance and thankyous for bearing with me. I have a set of MDB files with filenames like ABFE 6.MDB , ABFE 7.MDB , ABFE 8.MDB. This is an ultra simple version control :-) Work is actually done on the base file ABFE.MDB. This is because I shortcut ...

[mso] Re: Word 2007 crashing (Linda F. Johnson)

If you got the message about normal.dot being changed, then that could be what's causing the problem ... try deleting or renaming normal.dot and see if that fixes the problem. Linda ********************************* Linda F. Johnson Linda's Computer Stop ...

[mso] Word 2007 crashing (Tim Schoon)

Hi all, Whenever I load up Word 2007, it either opens without opening an existing document or a new one; or it'll outright crash and close. Any idea what might be causing this? I have already attempted a full uninstall and reinstall of Office, and re-updated it with the latest updates and yet it's still crashing or opening up without a document. There was recently a prompt about changes to Normal.dot saved, and I haven't made changes. I have run a full virus scan, and have 2 real-time checkers running (Malwarebytes and Norton 360). Yet this persists. Any idea on what's wrong or how to fix it? ...

[mso] Excel VBA Code (Herbert Chitate)

Hi All, I have a magazine indexing spreadsheet that I am trying to sort and was wondering if one of you good folks could help me with the code to part automate this process. To visualise this, think about the index page at the back of a book or magazine. In Column A, I have the description of the item. ...

[mso] Re: Excel Google Docs (R. Kowaney)

Google Docs is an office suite similar to Microsoft Office but it is fully online and the files are stored online in Google's servers. You can use it to prepare documents, spreadsheets, presentations, forms and folders. You can go to for their tutorials. This forum deals with Microsoft Office suite products only so this is not the appropriate forum to discuss this. Ruby -----Original Message----- From: Herbert Chitate herbertc@xxxxxxxxx ...

[mso] Excel Google Docs (Herbert Chitate)

Hi Folks, I was just wondering, has anybody here used google docs, if so, could someone explain to me how it works? I need some help on a spreadsheet. Many thanks Herbert ______________________________________________________________________ ...

[mso] Re: mso Digest V8 #197 (mccarthyhelper)

From: Linda F. Johnson linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx Subject: [mso] Re: Lost Outlook Settings Date: Fri, 30 Oct 2009 09:58:13 -0400 I believe, in the more recent versions of Windows and Office, pst files are now considered system or hidden files? Be sure you include system and hidden files in your search. ...

[mso] Re: Edit the Grammar checker (Jonathan Drawer)

I use Word 2000. The Grammar checker can be edited and customized. The easiest way to find it is to open Help in Word. Select the Index tab. Enter grammar (without the quotes). Click on Search to find something like grammar_checker as a keyword. Double click on the keyword to get a list of topics. In the results look for something like Set rules for writing and grammar style. Then just follow the links. That way you will find information about how to establish grammar rules as well as being able to do so. Jonathan --- On Sat, 10/31/09, David Grugeon david@xxxxxxxxxxxxxx wrote: ...

[mso] Re: comprimised (Linda F. Johnson)

To get to past messages for this group, click the link in the footer that takes you to the group's homepage ... on that page you will see a link to the archives Or go directly to the archives here: Linda ********************************* ...

[mso] Re: comprimised (James S. Huggins \(mso\))

Alas, I don't think I have anything to add to help, but I would like some clarification. The post stated: I have reason to beleive that someone has used my account without my knowledge or permission. Can someone remind me how I get to the past messages on these groups. Does this mean someone used your computer? ...

[mso] Re: comprimised (Mike Clare)

Bill, This is only tangentially related to the MSO group so my apologies to the group... My sympathies. My wife's Yahoo account was hacked last weekend too. Someone cracked her password and sent a email with a malware link to everybody in her contact list. The header on the messages shows they did use the yahoo servers but they left no evidence in the sent or trash folders. It was a mess. ...

[mso] Re: comprimised (bill goddard)

The folders are empty. I do know that someone used it. Thank You W J Goddard Burlington, ON. --- On Sun, 11/1/09, Abed azantout2001@xxxxxxxxx wrote: From: Abed azantout2001@xxxxxxxxx Subject: [mso] Re: comprimised ...

[mso] Re: Edit the Grammar checker (James S. Huggins \(mso\))

=============================== I accept that there are different views on what is right. The question is, can I edit the rules used? =============================== I am unaware of any way to do that. James S. Huggins ...

[mso] Re: comprimised (Abed)

Hi Bill, If someone has used your account to send messages, you may be able to see what they sent by clicking on the SENT folder to the left of your screen. You can also see if they deleted any messages by clicking on the TRASH folder. Hope this helps. Best Regards, Abed --- On Sun, 11/1/09, bill goddard uujayg@xxxxxxxx wrote: ...

[mso] comprimised (bill goddard)

I have reason to beleive that someone has used my account without my knowledge or permission. Can someone remind me how I get to the past messages on these groups. Thank You W J Goddard Burlington, ON. ...

[mso] Re: Edit the Grammar checker (David Grugeon)

Thanks James and David. I accept that there are different views on what is right. The question is, can I edit the rules used? Best Regards David Grugeon ...

[mso] Re: Edit the Grammar checker (James S. Huggins \(mso\))

============================ Hi all Does anyone know how to edit the rules in the grammar checker in word? Mine insists that training organisation staff contact employers regularly should be training organisation staff contacts employers regularly In Australian English the word staff means The people who work for an ...

[mso] Re: Edit the Grammar checker (David Smart)

In Australian English the word staff means The people who work for an organisation. And it is quite acceptable - even normal - to treat it as a plural, like the word people Not the English that I was taught (in Canberra, in the '50s). :-) To me ... staff contact ... would imply the people acting as individuals - i.e. lots of contacts. ... staff contacts ... would imply one contact from a member of the staff (acting as a group, with any of the staff able to make the contact, but only one member per contact time). ...

[mso] Edit the Grammar checker (David Grugeon)

Hi all Does anyone know how to edit the rules in the grammar checker in word? Mine insists that ...

[mso] Re: Contacts and Address Book (Green)

Hi Alan, They are different. The address book is a container for lists of addresses and so can contain contact folders. Theres quite a bit about it on the web. The definitive diva IMHO for all things outlook is Sue Mosher. You could do worse than have a peek at her siter. Don't have a link but she's well known ...

[mso] Re: mso Digest V8 #196 (David Grugeon)

You can't just copy program files from one computer to another. They need to be installed on the new computer so as to set the registry entries, put the dll files in the windows directory, etc.. If you get your original office install disks and reinstall the files, then run the updates (Microsoft update) then copy the .pst file and open that with Outlook, you should be more or less there. You might find it helpful to use the Office files and settings transfer wizard AFTER you have installed the programs. Best Regards ...

[mso] Re: mso Digest V8 #196 (James S. Huggins \(mso\))

====================================== Okay, I found them. Now my outlook won't work though. I had transferrred outlook from my old computer (with Windows XP) to my new one (with vista) with a laplink product that basically creates a copy of my old computer on the new one. I'm wondering if there's a problem with that now and how to get Outlook to start properly again. ====================================== did the machine/outlook work before you did the transfer? ...

[mso] Re: mso Digest V8 #196 (mccarthyhelper)

Okay, I found them. Now my outlook won't work though. I had transferrred outlook from my old computer (with Windows XP) to my new one (with vista) with a laplink product that basically creates a copy of my old computer on the new one. I'm wondering if there's a problem with that now and how to get Outlook to start properly again. --Original Message----- From: mso@xxxxxxxxxxxxx To: mso digest users ecartis@xxxxxxxxxxxxx Sent: Thu, Oct 29, 2009 10:05 pm Subject: mso Digest V8 #196 ...

[mso] Contacts and Address Book (Alan Bell)

In Outlook, is the contact list and the address book the same thing, and if not, how are they different in purpose and functionality? ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx ...