+ Reply to Thread
Results 1 to 6 of 6

Issues with code sent from 2010 to 2016

  1. 06-10-2016, 01:31 PM #1
    dwr2
    dwr2 is offline
    Registered User
    Join Date
    05-28-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Issues with code sent from 2010 to 2016

    After sending a form to use on my new computer I keep getting error/debug messages. I changed all the needed information in the code as to where the new form is to be saved etc. however this one line keeps coming up as being something wrong. The code works just fine in my 2010 Excel version but not at all in the 2016 update. Anyone know what I'm missing?

    This is the highlighted area each time I try to save it:
    Please Login or Register  to view this content.
    Full Module code reads as follows:

    Please Login or Register  to view this content.
    Any help would be appreciated.
    Thanks,
    D
    Last edited by dwr2; 06-10-2016 at 03:23 PM. Reason: trying to comply with Rule 3 & 7
    Reply With QuoteRegister To Reply
  2. 06-10-2016, 02:05 PM #2
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: VBA Project

    Moderation removed.
    Last edited by Winon; 06-12-2016 at 07:29 AM. Reason: Code Tags were added
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  3. 06-10-2016, 02:48 PM #3
    dwr2
    dwr2 is offline
    Registered User
    Join Date
    05-28-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: VBA Project

    Thank you, I'm sorry really not sure yet as how to use this correctly. How do I respond to the requests by Administrators? Very confused.
    Reply With QuoteRegister To Reply
  4. 06-10-2016, 03:03 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VBA Project

    A few minutes spent reading the Forum Rules will tell you everything you need to know. In addition to CODE tags, please read the part about thread titles, and then amend yours accordingly.

    Thanks.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  5. 06-10-2016, 03:27 PM #5
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Issues with code sent from 2010 to 2016

    dwr2,

    Try replacing "xlOpenXMLWorkbook" with the number "51" instead? That is assuming windows... if you are on Mac it is "52" for the number equivalent of the constant xlOpenXMLWorkbook

    If you are on Mac then there seem to be a few issues with 2016 and I'd have to look into it more to be helpful, since I'm on a windows PC

    P.S. Welcome to the forum
    Last edited by Arkadi; 06-10-2016 at 03:38 PM.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  6. 06-10-2016, 03:57 PM #6
    dwr2
    dwr2 is offline
    Registered User
    Join Date
    05-28-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Issues with code sent from 2010 to 2016

    I was so hoping this would help but unfortunately when I save the form the same highlighted line area appears once again. I do thank you though, I've got to be typing something wrong. will try again.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Generating a List of Project Parts Based on Project Duration and Time Window
    By glennchung in forum Excel General
    Replies: 5
    Last Post: 08-06-2014, 01:10 PM
  2. spreading a project value over a number of months based on order month & project duration
    By Steve.Jarvis in forum Excel General
    Replies: 1
    Last Post: 05-02-2014, 03:05 PM
  3. [SOLVED] Match date to project in array and calculate days since last project of same name
    By peepingtom in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-22-2013, 12:37 AM
  4. [SOLVED] Function that concatenates multiple sub-project descriptions based on project code
    By markbpi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 06:49 PM
  5. [SOLVED] Insert Blank Rows between sorted projects, Subtotal project to the right of final project.
    By ZAC7 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-07-2012, 04:08 AM
  6. VBA Project and Modules Remain in Project Explorer after workbook closed
    By avr5iron in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 03-09-2012, 11:38 AM
  7. With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project.
    By Tony in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2005, 11:05 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1