Hello again Paul,

I have been using you macro now for a month and it has been fantastic.

Two little things have come up in the last couple of days

One

Can I modify the statement below to point to any directory just by inserting the path into it? ie,

SendKeys "%n %n"
SendKeys ThisDocument.Path & "\REPORT.* ~"
SendKeys "~"

To

SendKeys "%n %n"
SendKeys c:\invoicedocs & "\REPORT.* ~"
SendKeys "~"


Two

I have saved the invoice with the data in it and I have to delete all the information in it before I run the macro on a new data file or else I get repeated data in it.

Looking at the macro I presume I need to reset the variables

I
j
k
x
y

I have tried this but I am getting nowhere with it. I now think I maybe on the wrong track here, and something else has to be done.

Could you point me in the right direction please?

Swerv