+ Reply to Thread
Results 1 to 6 of 6

macro - Save in .xls format/to specific location/name from entered data/show message

  1. #1
    Registered User
    Join Date
    01-16-2012
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    7

    Unhappy macro - Save in .xls format/to specific location/name from entered data/show message

    This is an input form using Template Wizard to store the data in the database sheet.
    Half of the users of this form use Excel 2010 and half use 2003.

    What I'm trying to do is:
    (1) name the file from the data entered (E17 & B19) to make the file name consistent;
    (2) save (SaveAs) all the files to a specific location (\\usershare\2012 XLS\);
    (3) save (SaveAs) in ".xls" format for both 2010/2003 users should be able to view/edit
    (4) disable compatibility check message
    (5) show message ("xxxxx.xls has been saved in 2012 XLS folder") after saving


    With the code below, the file is saved fine but the message won't show after saving:

    Please Login or Register  to view this content.
    I don't know what the problem is. Could you please help?
    Last edited by mimichan; 01-19-2012 at 10:10 AM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: macro - Save in .xls format/to specific location/name from entered data/show mess

    It will be good if you attach the sample workbook that you use along with this code so we can troubleshoot faster.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    01-16-2012
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: macro - Save in .xls format/to specific location/name from entered data/show mess

    Well I tried to upload the file but I got an error (IO Error...Error #2038)...

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: macro - Save in .xls format/to specific location/name from entered data/show mess

    Is your file not in .xls format? Try zipping and then upload.

  5. #5
    Registered User
    Join Date
    01-16-2012
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: macro - Save in .xls format/to specific location/name from entered data/show mess

    OK I tried to upload the zipped one but the same error.

  6. #6
    Registered User
    Join Date
    01-16-2012
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: macro - Save in .xls format/to specific location/name from entered data/show mess

    Can anybody help with this problem please?

+ 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