Skipping Lines in Excel using OLE2

[krindler]

Hello...I was wondering if anyone new a way to skip a line between each entry, when importing data from Forms to Excel, using OLE2. I have a counter set up in my For Loop, but didn't know if there was a way that I could skip a line between each line....I have shown an example below:

What I Get:

Location Name
A Plant A
B Plant B
C Plant C

What I Want:

Location Name
A Plant A

B Plant B

C Plant C

Can anyone help me out with this?

Thanks in Advance!

 

[sfvb]

Can't you just increment the counter by 2 instead of 1, or am I missing the point?

 

[kriss]

Hi krindler and sfvb,

I had posted a question wondering how you import data from Forms to Excel. I see you have already done that and are now worried about how to space the imported data... How do you use the OLE2? Could you please post some sample code on this import

 

[kriss]

Hi krindler and sfvb,

I had posted a question wondering how you import data from Forms to Excel. I see you have already done that and are now worried about how to space the imported data... How do you use the OLE2? Could you please post some sample code on this import?

Rgds..
Thebull1(programmer)

 

[sfvb]

Here are some examples that should get you started:
thread259-285059
thread259-281806
thread259-307384