Replies

Huh… how ’bout that! I recreated it and NOW it’s listed. (The only thing I did differently was that I accepted the default name… but I can’t believe THAT actually had anything to do with it.)

Do you happen to know where this “import spec” resides? Is it a file, or is it an object in Access? I can’t see it anywhere…

Thanks much for the help!

Yes, I tried that. There is nothing in the list at all, even though I have one saved (which I’ve used without any problems.) I simply want to automate a larger process for others in my area.

Thank you so much for that insight! I feel ashamed that I didn’t pour over the actual SQL in detail; I assumed (hah!) that things would work exactly as described in the MS reference.

OK… after a day of trying various ways of humoring Word so that it would let me delete a range of text, I came up with a kludgy workaround which I’ll share here in case anyone else is faced with the same problem.

But first, to recap: I needed to have my code delete the paragraph in a document that contained a particular bookmark. The code would always work when I stepped through it and when I ran it in real time, but would almost inevitably throw a bogus VB error (“Can’t edit range”) for our users. Oddly, clicking on Debug and then simply resuming the code served as a sort of “jiggle the handle” solution.

The only significant difference in environments is that most users have “locked down” machines, while I and another tester (for whom it worked fine) have admin privileges. I can’t believe that could be the reason, though! I even added an “Autonew” routine that would temporarily turn off the “Show all windows in taskbar” option, since past code I have written showed that Word would sometimes get confused about just what was the “active document.” But that didn’t help in this instance.

So, in the end, I found that the only thing that worked was to use the Selection object (which I’ve always tried to avoid.) Thus, replacing the line
[indent]docCoverLetter.Bookmarks(“bmkeCTDText”).Range.Paragraphs(1).Range.Delete
[/indent]with
[indent] Set rngKillText = docCoverLetter.Bookmarks(“bmkeCTDText”).Range.Paragraphs(1).Range
rngKillText.Select
Selection.Delete
[/indent]was the only thing that actually worked.

Go figure…

Brilliant! Thanks for the help; it’s exactly what I wanted.

The adapter in my 6930p is the ATI Mobility Radeon HD 3400 series… I couldn’t find anything on their site. (Then again, I had the nVidia setup in my Lenovo but couldn’t find the utility online, either.) I don’t even know what to search on, since my searches this far have turned up results that only deal with problems using extended desktops.

Hmm… it doesn’t look like the exact same software I had before, but it looks exactly like what I’m searching for (i.e. “generic” version of that utility.)

Thank you very much!!

Here is a “re-draft” of the document; I copied the contents into a new, blank document to make sure I knew exactly what page formatting had taken place. (Nothing but adding a landscape section to the end.) I tried, too, to scrub it to make sure there weren’t problems with the usual suspects (styles, numbering, etc.) and I randomized the text (for business reasons, obviously.)

Sure enough, it still demonstrates the same problem. I copied all the text into the new file with the notes formatted as footnotes, and then converted them to endnotes, and lo and behold… they just spill over into what looks like the footer and the landscape section.

Any ideas??

I agree. There are so many variables that can throw off your results with that approach… I just did a similar project, and the IncludeText field seems way more predictable.

Excellent help from you all, thank you. My final solution was a hybrid of what I learned from all of you. (Because I didn’t want banded columns, the solution that seemed to work was to simply apply the borders (and simultaneously re-apply the same shading) to Odd- and Even-Banded Rows.

I’ve had to fumble through Word’s logic (to use the term loosely) many times before; but you guys probably saved me days of stress!

Terry, thanks fo rthe reply… but the problem is that doing the action you described has no effect whatsoever on the table style… or at least, not on the particular table style I chose to customize.

Do you have that style available? Does it add the vertical lines to the style or table when you do it?

Ahh… I used to have a utility (VBCodeCleaner or something like that) which would do exactly that.

Does anyone know if it’s supported under Word 2007? (I’ll do it manually for now, but it was a nice utility. Reduced file size by a LOT, too!)

Added: I think i found it here – VBA Code Cleaner (I’m sorry if i’m violating any advertising rules.) Although iti hasn’t been upgraded per se, I tested it and it worked just fine under Word 2007 (except that you need to access it from the Add Ins tab and not some cool ribbon button.)

Unfortunately, no. I’m a bit surprised by that, but I guess it’s because it’s a custom “scheme”, albeit a broken one.

(What is the proper term, anyway? A collection? A List Style? I recall VBA in Word 2003 having a specific term for each “style”…)

I think that’s it exactly. I have been testing this out on a document that did have “DifferentFIrstPage” turned on, and the header contents were thus on that page.

The reason that these changes are being ensured, if not made, is so that future manipulation (combing files, copying and pasting) is more predictable, especially when it’s being done by the auithors themselves. I’m aware it’s no panacea, but the fewer deskside visits I have to make, the better for my other tasks.

I don’t understand the logic, though, that would explain why the setting a range would have the effect of emptying it, since it wasn’t set to anything before. And I can’t explain why setting the “LinkToPrevious” property on the first section doesn’t throw an error; I’m not even trapping errors per se in this utility.

Still, at least I remembered the other method, which seems to work just fine. But I WILL also be testing it on a document that isn’t like the one I’m using now. So thanks for the help!

Dang, that was fast! Thanks so much!