Results 1 to 6 of 6

Issues with code sent from 2010 to 2016

Threaded View

  1. #1
    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:
    [ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook]
    Full Module code reads as follows:

    [Sub SaveInvoiceWithNewName()
        Dim NewFN As Variant
        ' copy invoice to a new workbook
        ActiveSheet.Copy
        NewFN = "C:\Users\Candice\Documents\WRI\Billings\" & Range("J12").Value & ".xlsx"
        ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook
        ActiveWorkbook.Close
        NextInvoice
        ActiveSheet.Shapes("Textbox 8").TextFrame.Characters.Text = ""
    End Sub]
    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

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 08-06-2014, 01:10 PM
  2. 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1