Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

MS Excel 2003 - VB Macro for Reporting - RESOLVED

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
Hi all,

My first post on this forum, looking for some assistance. I've got a template for a report that I need to run aprox. 500 times each quarter. The template is completly automated, except input is needed for an ID Number, Start Date for the report and End Date for the report.

I'm trying to get a macro set up in a seperate workbook with a list of the ID Numbers, and a seperate field for Start Date and End Date. I need the macro to burn through that list, update the 3 fields in my template and Save As a different file name.

I hope I have explained what I'm trying to do but I'm stuck with this whole looping thing in VB which I'm sure I'll need.

I've attached a simple rendition of what I'm trying to accomplish, when running the macro in generator.xls it will open report.xls and update the three fields (Start Date / End Date / Name) and then 'save as the' 'Name' field (these will all be unique) in the same folder.

Can anyone offer any assistance?

Thanks in advance.

Got looping figured out!!!!! Thanks anyway.


Attached Files

Edited by tloftus, 29 July 2005 - 07:04 PM.

  • 0





  • Member
  • PipPip
  • 48 posts

I downloaded your zips and have seen a few names in generator.xls but there is only one date. Could you change the structure to
Name Start Date End Date
Joe 12/12/2004 1/1/2005
... .... ....
or any structure to let each name have start and end date?
  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP