Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thank you!

    Thank you!
  2. English is amazingly slippery, isn't it? Your...

    English is amazingly slippery, isn't it? Your code is a great direction-finder, Maud, and I can probably get from what you have to what I need. The relevant fields are text, and I need to pull the...
  3. [SOLVED] Also check out Paul Beverley's set of editing...

    Also check out Paul Beverley's set of editing macros: http://www.archivepub.co.uk/book.html

    He includes several to deal with acronyms.
  4. I'll have to sanitize it a bit, so will have it...

    I'll have to sanitize it a bit, so will have it for you on Friday.
  5. Thanks for the confirmation. I was hoping for...

    Thanks for the confirmation. I was hoping for some kind of copy/filter magic. We have no control over how the stuff gets imported, alas, because it is coming from a third-party tool.
  6. I'll take it that there's no better solution than...

    I'll take it that there's no better solution than manually iterating upward. Or is the question insufficiently clear?
  7. Finding rows with a blank first cell and concatenating other cells in the row with the cell above

    Excel semi-novice here, but lots of VBA for Word experience.

    I have a situation where an Excel data query from a data source results in some lines that start with a blank cell but contain...
  8. Thanks

    Thanks, Andrew! I

    bet it worked on the other machine because I had fewer documents open and they all had the same template. For production I am going to isolate this routine in its own template...
  9. The code resides in a template that remains open...

    The code resides in a template that remains open throughout execution. As soon as the second file opens, the macro stops executing. If the second file is already open, the macro works. Is there a...
  10. Word 2010 macro stops execution after opening a file

    I have a macro run from one file that opens a second file, checks it for a property, then activates the first file and does some stuff.

    It was working on one machine, but when transferred to...
  11. Have you tried using application.DisplayAlerts =...

    Have you tried using application.DisplayAlerts = False ?

    This shuts off all alerts. It's best to turn it back on at the end of the macro via

    Application.DisplayAlerts = True
  12. [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.
  13. [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:...
  14. Replies
    3
    Views
    403

    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.
    ...
  15. Replies
    3
    Views
    403

    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...
  16. 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...
  17. 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...
  18. 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...
  19. Replies
    1
    Views
    349

    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...
  20. Replies
    1
    Views
    349

    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...
  21. 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...
  22. 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...
  23. 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...
  24. Replies
    7
    Views
    7,576

    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
  25. Replies
    2
    Views
    785

    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. ...
Results 1 to 25 of 99
Page 1 of 4 1 2 3 4