Results 1 to 3 of 3
  1. #1
    asmores is offline Novice
    Windows 2K Access 2003
    Join Date
    Mar 2013
    Posts
    20

    Exporting to Excel, Procedure Too Large

    Hello All,
    I am currently working on a project that exports multiple queries directly to a new Excel workbook. Once the query results are in excel the project formats each sheet exactly how I need it. But with all the different formatting and all the different sheets I have exceeded the procedure limits. Ive tried to split the procedure into a couple of different subs, but I cant figure out how to get the second process to identify the new workbook created by the first process. Any help you can provide will be much appreciated.
    Thank you,

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Possibly declare the Excel object variables globally or pass the objects as arguments of procedure. Neither of which I've ever tried with Excel.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    asmores is offline Novice
    Windows 2K Access 2003
    Join Date
    Mar 2013
    Posts
    20
    I used global variables and it worked beautifully, thank you for your help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing large excel file into multiple access files
    By Ghost in forum Import/Export Data
    Replies: 10
    Last Post: 11-05-2013, 11:19 AM
  2. Need help exporting large Access file into Excel
    By phidelt in forum Import/Export Data
    Replies: 2
    Last Post: 02-27-2013, 06:14 PM
  3. Replies: 10
    Last Post: 12-28-2012, 02:06 PM
  4. Replies: 6
    Last Post: 12-03-2012, 08:08 AM
  5. Excel file that I export from Access is extremely large
    By Ronald Mcdonald in forum Access
    Replies: 1
    Last Post: 05-25-2012, 03:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums