Results 1 to 4 of 4
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Export to excel with macro or vba get this error...


    It's on one particular pc... not the one I am working on - which works fine.

    Click image for larger version. 

Name:	SnipImage.jpg 
Views:	9 
Size:	9.9 KB 
ID:	14348

    I go to export to pdf using command button on a form and it comes up with error.

    VBA is
    Code:
    Private Sub Command2_Click()
    DoCmd.OutputTo acOutputReport, "rptGeneralAccount", acFormatXLS
    End Sub
    note running full access 2010 on both pc

  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,913
    Same operating system?

    Could a whole host of causes.

    I Binged the error and got suggestions for data corruption and missing support files, etc.

    http://stackoverflow.com/questions/7...tput-operation
    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
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Quote Originally Posted by June7 View Post
    Same operating system?

    Could a whole host of causes.

    I Binged the error and got suggestions for data corruption and missing support files, etc.

    http://stackoverflow.com/questions/7...tput-operation
    yeah, wiping the pc and starting with a fresh install.

  4. #4
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Fixed sorted etc...

    thanks June

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

Similar Threads

  1. EXPORT to Excel via Macro
    By ruggierm1 in forum Import/Export Data
    Replies: 15
    Last Post: 09-25-2012, 09:33 AM
  2. Replies: 1
    Last Post: 04-30-2012, 05:10 PM
  3. Annoying error on macro export to excel - missing rows
    By Blueweasel in forum Import/Export Data
    Replies: 0
    Last Post: 12-15-2011, 04:41 AM
  4. Macro export to excel error
    By Andy_d in forum Import/Export Data
    Replies: 7
    Last Post: 04-15-2011, 09:54 AM
  5. Macro to export to excel
    By jlclark4 in forum Import/Export Data
    Replies: 5
    Last Post: 04-15-2011, 08:36 AM

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