Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Excel ask every time for outlook profile

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Excel ask every time for outlook profile
Every time i start this code, Outlook is asking for a profile. what do i wrong? if i start outlook first, then there are no questions, but a'm not be able to start everytime outlook first, so this code has to find the profile by itself.. Code: Application.ScreenUpdating = True Dim OutApp As...

Excel Help Forum - Excel General: I can't run macro when I protect the worksheet

Feed2Mail notification - new post on Excel Help Forum - Excel General
I can't run macro when I protect the worksheet
I am sorry if my English is poor. I unlocked cells in the area that macro will use for calculation. When I protect the worksheet the macro could not run. But when I unprotect the worksheet the macro can run again. I want to know how to protect some cells in the worksheet and also enable the...

Excel Help Forum - Excel General: Summing and Averageing, based on criteria.

Feed2Mail notification - new post on Excel Help Forum - Excel General
Summing and Averageing, based on criteria.
Hi All, I currently have an excel table with staff members names (which wont change) and I'm seeking a way to work out the average time it takes them to complete a project. Attachment 188957 (http://www.excelforum.com/attachment.php?attachmentid=188957) In this example John and Mike both...

Excel Help Forum - Excel Programming / VBA / Macros: Web Query Help? - Query Picture Title or Alt Text on a webpage?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Web Query Help? - Query Picture Title or Alt Text on a webpage?
Hey, I am querying a few things from a webpage with getElementsByClassName right now and it is working well. However I want to be able to get the picture title or alt text from html? It may just be changing the options with getElementsByClassName, but I am not sure how. Here is an example...

Excel Help Forum - Excel General: Sort on cells with all caps

Feed2Mail notification - new post on Excel Help Forum - Excel General
Sort on cells with all caps
There is a solution here, which prioritizes capitals http://www.excelforum.com/excel-general/699248-case-sensitive-sorting-all-caps-first-then-all-lowercase.html But what I want is to have first cells where all letters are capitals, and then cells with lowercase or mixed case in a way that it...

Microsoft Word - Publish to Blog with Endnotes

Microsoft Word - Publish to Blog with Endnotes


Publish to Blog with Endnotes

Posted: 22 Oct 2012 10:06 AM PDT

I cannot publish to blog with endnotes.  The endnotes are not included in the blog post and the superscript numbers in the blog post are missing.  Is there a way to fix this?  I could use endnotes if there is a way to get that working but that does not seem to work either.

 

I have Office 2007 Professional but I am willing to upgrade to later if necessary to fix the problem.

Mail Merge Word 2007 files using parameter based Access query

Posted: 21 Oct 2012 10:25 PM PDT

Hi,


We recently upgraded our users from 2003 to 2007 Office (Standard), meaning they do not have Microsoft Access

installed on their machines as it is not part of the license.

 

We have some vital documentation with headers containing mail merge info.

This mail merge information is stored in an Access query with a parameter (so the users can run the documentation for a specific result from the database)

 

After the upgrade, the Word 2007 file looks for Microsoft Access and if it isn't installed, it causes an error.

 

Is there a way around having to install Microsoft Access for every users who needs to run a mail merge for these documents?

 

Thanks


 

 

How to add definition dictionary to Research pane in Word 2002?

Posted: 21 Oct 2012 02:27 PM PDT

How can I create the dictionary "Look-up" command in the right-click research task pane for Microsoft Office XP Professional 2002? When I right click over text, I don't have the Look-up command, only the thesaurus. When I edit my text in Word, I want to define certain words. I've used this utility before, but I've seemed to have lost it when I had to reinstall my OS.

[Original title: chrisdodt]

how can I stop Office from saving FAPxxx.tmp files to my desktop

Posted: 19 Oct 2012 04:28 PM PDT

each time I open Word, create a document, nd not even necessarily save it, but perhaps print it--I then find a whole bunch of FAPxxx.tmp icons saved to my desktop--maybe 10 or more. How can I prevent this from happening?  This is a relatively new happening, even though I have been using Word for  3 years years with this computer.. 

Find alphabetic directory for clip art

Posted: 19 Oct 2012 10:12 AM PDT

Last week in doing a 2007 Word document I found an alphabetic directory with red print for special clip art and pulled up a numbered site for recyclable symbols from #1 to #7. Now I can't find the alphabetic directory.. 

Protecting template styles in Word 2003

Posted: 19 Oct 2012 07:21 AM PDT

I am using Word 2003 on XP. I have set up a template but when I copy and paste a document into the template, it brings in the document styles. I can delete the ones that have different names but it changes the existing ones, like Heading 1, etc. How do I protect template styles in Word 2003?

Thanks!

Word 2010 Hyperlinks Don't Work In Emailed Document

Posted: 18 Oct 2012 02:04 PM PDT

Hyperlinks work fine until I send the document via email.  Do I need to add share permissions to allow others to open the hyperlinks?

List numbering problems in Word 2010!

Posted: 17 Oct 2012 01:40 PM PDT

Why doesn't the List Number in a table enable me to restart the list at 1? The function works when the list is not within a table, but the function is not even AVAILABLE within the table list (see diagram that follows). This is extremely annoying, especially when I need to pass the document to a person who does not know all the poorly thought out and senseless problems of formatting and styles in Microsoft Word. To me, this is incompetent programming and a time waster.


 

cell alignment option

Posted: 17 Oct 2012 12:54 PM PDT

How come sometimes in MS Word when I right click in a label cell I get the cell alignment option and sometimes I don't?

Excel Help Forum - Excel Programming / VBA / Macros: Printing current time and date.

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Printing current time and date.
Hello, I would like to create a button that on double click prints the current date and time in their respected cells then clears itself on another double click. Currently I have coded a button to show a completed and not yet completed state (see attached) but am not sure how to incorporate...