+ Reply to Thread
Results 1 to 2 of 2

Is this code VBA?

  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    York
    MS-Off Ver
    Excel 2010
    Posts
    22

    Is this code VBA?

    Buongiorno from 21 degrees C wetherby UK :-)

    Is anyone bale to tell me if this code illustrated here is VBA?
    http://i216.photobucket.com/albums/c...ps161d5c21.jpg

    This line of code i need to fully understand:

    SaveInWorksheet,current,data-union_data,Overwrite,invisible,1,1,unformatted,-1,-1

    Grazie tanto,
    David

  2. #2
    Forum Contributor
    Join Date
    12-26-2008
    Location
    India
    MS-Off Ver
    2007
    Posts
    122

    Re: Is this code VBA?

    This is the basic of what this referred line does: (SaveInWorksheet,current,data-union_data,Overwrite,invisible,1,1,unformatted,-1,-1)

    Save In Worksheet: This transfers data from the most recent page to the worksheet.
    Current: This refers to a page
    data-union_data: will be the name of the worksheet, this will be created if it doesn't exist.
    Overwrite: Is to erase
    Invisible: This will leave page caption as invisible
    1: row index
    1: column index.
    unformatted: keep the cell unformatted
    -1: row where u would like to overwrite
    -1: column where u would like to overwrite

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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