need page break by asking the input file for page break to be done

Originally Posted by royUK

Try the code that I posted

where is the code ? i think you don't understand th problem.

Your code for page break work fine. what i required is that ? I receive the file which want to be page break with out adding the macro to it.

so that what i plan to do is that, i will paste your existing page break code which you provided before in the file name "master". Current code will do a page break for "master" file, instead it need to ask the input file "transaction" file, the "transaction" file which need to page break. so that i can send the transaction file to client with page break on client id with out macro code in it.

2 Files need to be used, first one is "master" file which will contain your macro with reqired code change. Second, file is that "transaction" file from client as source file which really need to have a page break depending on client ids.

I feel you might have understand the problem.

Thanks.