Three Years of Hell to Become the Devil: 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:

Section	Open Note	Close Note
First Section	1	10
Second Section	11	20
...

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

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Name:

Email Address:

URL:

Remember personal info?

Comments:

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

Request For Technical Help

Comments

Post a comment

Giving The Devil His Due

Search

Choose Stylesheet

What I'm Reading

Shopping

Projects I've Been Involved With

Syndicated from other sites