+ Reply to Thread
Results 1 to 1 of 1

Forcing XLSM as a file type, but do not need to save

  1. #1
    Registered User
    Join Date
    05-15-2012
    Location
    Tokyo
    MS-Off Ver
    Excel 2007
    Posts
    1

    Forcing XLSM as a file type, but do not need to save

    Hiya,
    i got this code from various places. It works, but it creates the file for me on Sharepoint (it's an excel template in Sharepoint), and then shows the filename that i want to save it in. The code below is in the BeforeSave event.
    There's no Onsave event, so i don't know where else to put it. What i want to have happen is it to only show me the filename, with XLSM as the type, and not save it. i will let the user do that.
    What am i doing wrong with the below?
    Thanks from Tokyo

    Please Login or Register  to view this content.
    Last edited by Noppojp; 08-22-2013 at 09:10 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 05-21-2013, 08:22 AM
  2. Save file xls file as xlsm - macro won't run in xlsm workbook
    By captbluefin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-07-2012, 11:39 AM
  3. [SOLVED] Save xlsm file as xlsx file
    By ccpsc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2012, 01:12 AM
  4. Save File as .XLSM
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2011, 12:57 PM

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