VB Macro Question/Changing Pages

[Outsider418]

Good Morning.

I am very new to VB so please bear with me.

On my job, I can make/record simple macros to use on our scratchpads. I found that I can modify these macros after I record them. The only problem that I have is that if I have a macro that records three lines of text and I only have space for two, the third line starts again at the top. What command do I use to make the macro change pages once I run out of space on the page that I'm on?

Thanks for your help!

 

[Sthrncali]

I am not following..

Can you paste your recorded macro here and explain what you are trying to accomplish with it?

 

[Outsider418]

Sorry about that...I should have posted an example.

I made a quick macro...I tested it and it works on my system at work.

Sub ZMain()
Dim Text, ret
SendHostKeys ("A409This is the first line of the macro<tab>R<Tab>")
SendHostKeys ("This is the second line of the macro<Tab>R<Tab>")
SendHostKeys ("This is the third line of the macro")
End Sub

This macro is 3 lines long. If I'm on the scratchpad and there are only two lines left, the third line will end up at the top of the page I am on instead of switching to the next page. Is there a command that I can put in that tells the macro to change pages if it runs out of space?

Thanks for your help.