>I need to be able to generate multiple spreadsheets in a workbook via VBA from VFP 6.0. I would also like to name each spreadsheet.
>
>I assume that since I can do this from the Excel GUI that I can do it through VBA.
>
>Many thanks, Bob
Give this a try.
ox.Sheets("Sheet1").Select
ox.Sheets("Sheet1").Name = "Sheetnamegoeshere"
HTH
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com