sbendbuckeye
Active Member
- Joined
- Nov 26, 2003
- Messages
- 440
Hello all,
In an Excel 2007 workbook, I have the following code:
Dim sheet As Worksheet
Set sheet = WorkBooks.Add
Reference is set to Office 12
This creates an Excel 2003 file with 65,000+ rows and 256 columns. I need it to create an Excel 2007 file because the data exceeds 70,000 rows. How do I make Excel create an Excel 2007 workbook? Thanks in advance for any ideas and/or suggestions!
In an Excel 2007 workbook, I have the following code:
Dim sheet As Worksheet
Set sheet = WorkBooks.Add
Reference is set to Office 12
This creates an Excel 2003 file with 65,000+ rows and 256 columns. I need it to create an Excel 2007 file because the data exceeds 70,000 rows. How do I make Excel create an Excel 2007 workbook? Thanks in advance for any ideas and/or suggestions!
Last edited: