Can anybody provide me with a procedure to generate
correlated random variates?

How many sets? If only two, then you can use this formula:

CRV2 = corr * RV1+ RV2 * (1 - corr ^ 2) ^ 0.5

If you want more than 2, it gets progressively more complicated.
I'd suggest an Internet search or try www.riskchat.com, where
somebody offered a VBA routine.

HTH,
Merjet