How do you use VBS to Insert data into excel?

[RonQA]

I can get the data into the sheet, but I need it to go to the last empty cell. It is really driving me crazy.

Does anyone have script to do something like this?

Thanks,

 

[tsuji]

>last empty cell
What last is last?

 

[markdmac]

You can use a do until statement to loop through cells until the length is = "".

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[tsuji]

...if you are interested.

http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb06/hey0215.mspx