« Not a 50/50 Split | Main | RatherGate: The End? »

Request For Technical Help

So here's something I thought would be relatively easy to program in Visual Basic, but is giving me a bit of a headache. If any of my readers have any idea how I might implement this, and might give me some advice in the comments or via email, I'd appreciate it.

I'm trying to design an application in an Excel spreadsheet to easily automate a specific task. The sheet should have columns roughly like this:

SectionOpen NoteClose Note
First Section110
Second Section1120

One fixed cell of the spreadsheet has a file location for a Microsoft Word document that has quite a few footnotes. The application basically consists of a button that one presses after entering data in to the table above.

Upon pressing the button, the application needs to scan the Word document once for each row in the table, and find the page on which Open Note and Close Note (the footnote with those numbers) appears. It must then print that range of pages in the Word doc, go to the next line in the table, and repeat.

I'm writing some VBA to cope with this process, but I'm stumped on a few points. Given the limited nature of my coding skill, I'm mostly stumped at the hard parts. So maybe some of my readers can answer:

  • What would be the best way for me to use VB code to scan the Word document to determine the page number on which Open Note and Close Note appear?
  • Is there any way to tell Excel to open a different file in a program such as Word and print a given range of pages?
  • Anyone know of a VBA app (or other) that already does this?

Thanks in advance for any help my more technically-minded readers have. Len, that means you. ;)


TrackBack URL for this entry:


Gawd, I hate to disappoint you, but I'm a DBA/webmaster/sysadmin/network admin type. I know enough programming to be dangeroust only if we restrict it to PHP, JavaScript, a little bit (not much) of bash scripting and DOS style batch file programming. I've not done any <laughingly>serious</laughingly> Visual Basic since about 1996 and VB 4.0. On an OT digression, I've lost your email address. If you're really interested in readding my RSS/RDF feed, you'll have to contact me, I'm afraid.
OK, it should be added now.... one hopes.

Post a comment

NOTICE TO SPAMMERS, COMMENT ROBOTS, TRACKBACK SPAMMERS AND OTHER NON-HUMAN VISITORS: No comment or trackback left via a robot is ever welcome at Three Years of Hell. Your interference imposes significant costs upon me and my legitimate users. The owner, user or affiliate who advertises using non-human visitors and leaves a comment or trackback on this site therefore agrees to the following: (a) they will pay fifty cents (US$0.50) to Anthony Rickey (hereinafter, the "Host") for every spam trackback or comment processed through any blogs hosted on threeyearsofhell.com, morgrave.com or housevirgo.com, irrespective of whether that comment or trackback is actually posted on the publicly-accessible site, such fees to cover Host's costs of hosting and bandwidth, time in tending to your comment or trackback and costs of enforcement; (b) if such comment or trackback is published on the publicly-accessible site, an additional fee of one dollar (US$1.00) per day per URL included in the comment or trackback for every day the comment or trackback remains publicly available, such fee to represent the value of publicity and search-engine placement advantages.

Giving The Devil His Due

Choose Stylesheet

What I'm Reading

D.C. Noir

My city. But darker.
A Clockwork Orange

About time I read this...


Projects I've Been Involved With

A Round-the-World Travel Blog: Devil May Care (A new round-the-world travel blog, co-written with my wife)
Parents for Inclusive Education (From my Clinic)

Syndicated from other sites

The Columbia Continuum
Other Blogs by CLS students

De Novo
Theory and Practice
Liberal Federalism?
Good News, No Foolin'

Nancy Pelosi covers her head and visits the head of John the Baptist.
Vlogging in from Austin.
Omikase/"American Idol"

Jeremy Blachman's Weblog: 2007
Happy Passover
Looking for Advice re: LA
Google Books

Stay of Execution
What I've Learned From This Blog, or My Yellow Underpants
The End
Mid Thirties

Legal Theory Blog
Program Announcement: Summer Programs on the Constitution at George Washington
Book Announement: Political Foundations of Judicial Supremacy by Whittington
Entry Level Hiring Report

The Volokh Conspiracy
Making the Daily Show:
Civil unions pass New Hampshire House:
Profile of Yale Law Dean Harold Koh:

Crescat Sententia
Hillary II
Politics and Principal/Agents

Law Dork
Election Approaches
Following Lewis
New Jersey High Court: 'Same Rights and Benefits'

Surveying the revival
Birds of paradise

Half the Sins of Mankind
Cheney Has Spoken Religious conservatives who may ...
Does Ahmadinejad Know Christianity Better Than MSN...
Borders as Genocide In discussions of climate chan...

For lovers of garden gnomes...and any China-freaks out there
We Interrupt Your Regularly Scheduled Programming

Does SOX explain the flight from NY?
More Litvak on SOX effect on cross-listed firms
What did the market learn from internal controls reporting?

The Yin Blog
Iowa City = Riyadh
Jeffrey Rosen's "The Supreme Court"
Geek alert -- who would win between Battlestar Galactica and the U.S.S. Enterprise?

Letters of Marque
And there we are

Signing Off

Dark Bilious Vapors
Jim (The Waco Kid): Where you headed, cowboy?
Bart: Nowhere special.
Jim: Nowhere special. I always wanted to go there.
Bart: Come on.
--"Blazing Saddles"

Technical Difficulties... please stand by....
The Onion should have gotten a patent first....

Legal Ethics Forum
Interesting new Expert DQ case
Decency, Due Care, and The Yoo-Delahunty Memorandum
Thinking About the Fired U.S. Attorneys

Ex Post
Student Symposium- Chicago!
More Hmong - Now at Law School
Good Samaritan Laws: Good For America?

Appellate Law & Practice
Those turned over documents
CA1: courts can’t help people acquitted of crimes purge the taint of acquitted conduct
CA1: restrictions on chain liquor stores in Rhode Island are STILL okay

the imbroglio
High schoolers turn in plagiarism screeners for copyright infringement
Paris to offer 20,600 bikes at 1,450 stations to rent by the end of the year

The Republic of T.
The Secret of the Snack Attack
links for 2007-04-04
Where You Link is What You Get

Distractions for stressed law students

The Other Side: Twisted AnimationsSomething Positive, a truly good webcomic

Syndicate This Site



Stop Spam Harvesters, Join Project Honey Pot