Results 1 to 27 of 27

VB application stops generating spreadsheet at row 65536

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2012
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    13

    VB application stops generating spreadsheet at row 65536

    Hello
    I have a VB application that's been running for the last couple of years on a machine that has Office 2010 installed. Now that the number of rows generated in the spreadsheet is > 65536, the application stops at this point.

    I can't work out why this is happening, the reference used is Microsoft Excel 14.0 Object library.

    Here's a snippet of the code, if any more is required, please let me know:

    Dim oXL As Excel.Application
    Dim oWB As Excel.Workbook
    Dim oSheet As Excel.Worksheet
    
        Set oXL = CreateObject("Excel.Application")
        oXL.Application.Visible = True
          
    ' Get a new workbook and sheet
        Set oWB = oXL.Workbooks.Add
        Set oSheet = oWB.ActiveSheet
    Does anyone know why this is happening? Any help would be greatly appreciated.

    Thank you.
    Last edited by alansidman; 11-04-2015 at 08:50 PM. Reason: added code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Generating Reports from Spreadsheet
    By sadele89 in forum Excel General
    Replies: 6
    Last Post: 10-24-2015, 03:37 PM
  2. Generating a csv in the same folder as spreadsheet using VBA
    By babytigress in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2014, 08:19 PM
  3. help generating a new spreadsheet from an existing spreadsheet
    By dan_fash in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-01-2014, 10:06 PM
  4. Replies: 0
    Last Post: 07-29-2011, 06:25 PM
  5. Replies: 0
    Last Post: 03-01-2011, 11:55 AM
  6. [SOLVED]check row 65536 in spreadsheet
    By burugudug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2010, 12:49 PM
  7. [SOLVED] Generating Simple Reports From A Master Spreadsheet
    By Scott1888 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-21-2006, 05:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1