I think I can use this concept for a project I'm working on, but I have a couple of questions.
1. Can a Workbook be created "on the fly" from within the VB code and can the individual worksheets be renamed at that same time? Or, does the Workbook have to already exist in order to be referenced?
2. The data I need to insert into the worksheets will come from a series of cross tab queries where the number of columns can vary from month to month. Is it possible to capture the number of returned columns (similar to .RecordCount)?
3. Is there an alternative to this process? What I'm thinking of would be similar to pasting a Pivot Table into an existing worksheet where only the beginning cell reference (i.e., J21) needs to be supplied.
Thanks in advance.
Larry De Laruelle
larry1de@yahoo.com