+ Reply to Thread
Results 1 to 3 of 3

Macro for save as action on excel

  1. #1
    Registered User
    Join Date
    07-12-2014
    Location
    India , Coimbatore
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Macro for save as action on excel

    Hi , I have some excel files which should be saved in Excel 97-2003 Workbook format . I am trying to write vba code for that i am struggling at starting . problem is i have 6 excel files which should be saved as Excel 97-2003 Workbook format i don't know how i give 6 files path to code . I am very new to vba coding and i am learning vba any reference link is appreciated ..

    Thanks
    gobi

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,871

    Re: Macro for save as action on excel

    Since you are attempting a VBA solution, why not post your code and tell us what is not working and let us help to a solution.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    07-12-2014
    Location
    India , Coimbatore
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Re: Macro for save as action on excel

    Hi , This is my macro code for save as action .
    Please Login or Register  to view this content.
    Here i am giving the path url in workbook directly to Filename object instead i have to take it from a notepad file which has 6 files url and run the macro for 6 files , and i have to give notepad url in cell which has the macro . This code runs good , i want to take xlsx file url from notepad and notepad url from cell which has the macro . Please give me idea how i read file url from notepad .

    Thanks.

+ 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. macro required to filter data on several tabs and save to a file, then repeating action
    By Stevengreen22 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-04-2012, 10:26 AM
  2. Do action Before Save
    By titaniumjack in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2010, 03:55 PM
  3. not allow a save action if ANY data is missing
    By matt7102 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2008, 05:18 PM
  4. Undo a save action
    By John in forum Excel General
    Replies: 1
    Last Post: 01-26-2006, 02:30 PM
  5. Excel 2002 crashing during "Save As" action.
    By Andy T in forum Excel General
    Replies: 1
    Last Post: 01-04-2005, 08:06 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