Pages

Search

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...

Excel Help Forum - Excel General: Is there a way to apply conditional format if duplicate BUT only for a certai...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Is there a way to apply conditional format if duplicate BUT only for a certain value?
I have a userform that's outputting data to a worksheet (schedules) and it's okay to have a duplicate schedule for someone unless it's a late shift (10:00pm, value is outputting as 10:00) in which case, I'd like conditional formatting to highlight the cells. I've messed with it but I can only do...

Excel Help Forum - Excel Charting & Pivots: X and Y avlue on scatter plot

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
X and Y avlue on scatter plot
hi, let me know how to calculate the extrapolite the value on linear graph? i m able to calculate the x and y at 0, but i wanted to know if the value at 20.9.Attachment 188931 (http://www.excelforum.com/attachment.php?attachmentid=188931)

Excel Help Forum - Excel Programming / VBA / Macros: Creating a list of single values from a list with multiples of that value

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Creating a list of single values from a list with multiples of that value
Hello, I am not entirely sure that my problem falls under VBA/macros, but I am writing a macro, so here is the problem: I have a workbook which has lists of data for several buildings. The data spans several weeks and is labelled by the day and time that it was recorded. So there are about 100...