Search:

Type: Posts; User: jweissmn1; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. [SOLVED] Right. I should have marked that the problem is...

    Right. I should have marked that the problem is solved. I figured out another approach.
  2. [SOLVED] Table name in a variable for an advanced filter copy in an Excel 2010 macro

    To avoid duplicating lines and hardcoding references, I need to do an advanced filter copy from a table with all the parameters in variables. Recording the action in the Macro recorder gave me this:...
  3. Replies
    3
    Views
    156

    Yes, that's the one that replaced the one that...

    Yes, that's the one that replaced the one that showed event order. It is illuminating about the whole topic, and I hope it helps others.

    And thanks for the DoEvents hint. That may be the key.
    ...
  4. Replies
    3
    Views
    156

    Order of events for opening a workbook

    Is there a reference that shows what happens in what order when opening an Excel workbook? Lots of Googleing and Binging leads only to a page from Pearson Consulting that has been replaced with a...
  5. Hmm. It seems that if you there is a named range...

    Hmm. It seems that if you there is a named range that is not a table (but used to be), the values in the first row are shown in the formula builder as though they are column names. But they are...
  6. Thanks - what I can't seem to do is use the...

    Thanks - what I can't seem to do is use the Table_Name[Column Name] format with anything else after the ] to specify which row I mean.

    Let's say I have a table on one sheet named...
  7. Reference to specific table cell from outside the table

    This seems like it should be obvious and easy, but I can't seem to get it to work. Excel 2010.

    I have a table that is, except for one column, a copy of another table on another sheet. I can't...
  8. Replies
    1
    Views
    167

    As so often happens I solved the problem myself. ...

    As so often happens I solved the problem myself. I didn't notice the Properties for data connections, which are conveniently NOT in the Connection box. One of the properties specifies what happens...
  9. Replies
    1
    Views
    167

    Problematic update of table from source

    I am new to Excel after many years of working with Word VBA and other fancy features. It's fascinating. This is in Excel 2010.

    We have a table that is based on a sheet that draws data from an...
  10. It is working as designed. Style changes and...

    It is working as designed. Style changes and additions in a template don't apply to existing documents, just to new documents. You must add the new style to each document individually by copying it...
  11. The shapes collection in a Word document applies...

    The shapes collection in a Word document applies to the entire story (i.e. the main body or the headers and footers), and is not divided by pages. Pages don't have a shapes collection. Shapes per...
  12. Word 2007: Different footnote separator style for first page of a section?

    Someone else is struggling with this, and I got curious.

    Is there any way to have a different format for the footnote separator in different sections or on the first page?

    I know the draft view...
  13. Replies
    7
    Views
    3,783

    You want to make a list style, I believe. Use...

    You want to make a list style, I believe. Use the multilevel list button. Good instructions here:

    http://www.shaunakelly.com/word/numbering/numbering20072010.html

    - Jessica
  14. Replies
    2
    Views
    604

    Do you have the styles pane set to display Styles...

    Do you have the styles pane set to display Styles in Use, or All Styles, or what? The behavior of the pane in Word 2010 is less predictable (the polite way of saying it) than in previous versions. ...
  15. Replies
    5
    Views
    693

    Cool! Rerquires eyeballing by a human, but it...

    Cool! Rerquires eyeballing by a human, but it does draw attention to the suspect paragraphs one by one. You could probably jigger a replacement for this line:

    For Each oPara In...
  16. Replies
    11
    Views
    3,324

    To update fields in the main body of the text,...

    To update fields in the main body of the text, select it all and press F9. If what you want is in a footer, the easiest way to do it is to select the field and press F9. I have a macro someplace...
  17. Replies
    5
    Views
    693

    This is a very hard problem, mostly because it is...

    This is a very hard problem, mostly because it is difficult to define a mismatch unambiguously. Is a mismatch two right parens without a left paren anywhere in the intervening text? If so, what do...
  18. Replies
    11
    Views
    3,324

    If I understand what you are doing, you're using...

    If I understand what you are doing, you're using a Styleref field to show the chapter number on each footer. You're drawing the chapter number from a Heading style, I'd assume.

    Things to check: ...
  19. Replies
    6
    Views
    1,051

    I knew it was here somewhere, but searches didn't...

    I knew it was here somewhere, but searches didn't turn it up and all the links elsewhere are to the old wopr location. Thanks for posting the direct link.

    For others following the link, the most...
  20. Replies
    6
    Views
    1,051

    Here is a reference that shows how to do similar...

    Here is a reference that shows how to do similar things using formula fields and VBA, with no need for Excel.

    http://www.addbalance.com/word/datefields2.htm

    Also check out Macropod's amazing...
  21. It looks to me as though the first instance has a...

    It looks to me as though the first instance has a space after GetDimensions and the second doesn't. If I am reading this correctly, that might be the difference.

    Also, is there some indexing...
  22. When you set up a multilevel list with the styles...

    When you set up a multilevel list with the styles linked to heading numbers, you can insert fixed text before the numbers. I do that regularly to have step numbers that start with the word Step.
    ...
  23. Replies
    5
    Views
    628

    Remember that for Word, a page is a fleeting and...

    Remember that for Word, a page is a fleeting and coincidental thing, dependent upon the printer selection and so on. If you look at the Word object model, page has essentially no place in it. PDFs...
  24. As far as I know there is no way to do that. ...

    As far as I know there is no way to do that. There may be sneaky ways to copy the dictionary files, but as for the others I think you're out of luck.
  25. Thanks, Andrew. I finally fixed it (yesterday) by...

    Thanks, Andrew. I finally fixed it (yesterday) by defining a multilevel list with my paragraph style attached to the first level of the list. There was some strange conflict between the paragraph...
Results 1 to 25 of 88
Page 1 of 4 1 2 3 4