Yet another Lotus macro question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Monty - 06 Feb 2007 23:37 GMT

I have for the most part converted to Excel but have a simple macro that on
the surface cannot be converted.
The Lotus macro used a database, template and list of branch names. The
macro itself started with the name of the first branch, copied it to the
template, sucked in the data for that branch and then printed the report.
Then it went down to next name on the list and repeated the process until it
reached the bottom of the list.
In Excel it seems to indicate I have to repeat the steps for each and every
branch on the list and not loop back through a 8 line macro that refers to
the range named list.
Help! - if there is any solution.

Reply to this Message

JMB - 07 Feb 2007 05:10 GMT

VBA has several loops to choose from (below are the ones that I can think of
at the moment). If you are looping through a named range, I would lean
towards the For Each..Next loop.

For Each...Next
For...Next
Do...Loop
While...Wend

> I have for the most part converted to Excel but have a simple macro that on
> the surface cannot be converted.
[quoted text clipped - 7 lines]
> the range named list.
> Help! - if there is any solution.

Reply to this Message

Don Guillett - 07 Feb 2007 13:44 GMT

something like
sub doeach()
for each myname in mylist
myname.copy sheets("Template").range("a1")
with sheets("Template")
.getdata for branch
.printout
end with
next myname
end sub

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I have for the most part converted to Excel but have a simple macro that on
> the surface cannot be converted.
[quoted text clipped - 9 lines]
> the range named list.
> Help! - if there is any solution.

Reply to this Message