+ Reply to Thread
Results 1 to 6 of 6

VBA Help needed for saving workbook specific folder and file extension ".xlsm"

  1. 03-12-2012, 01:03 PM #1
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    VBA Help needed for saving workbook specific folder and file extension ".xlsm"

    Folks,

    The below code does advanced filter automatically and save the filtered data as new workbooks individually based on the criteria with file extension ".xlsx" in the "Master" workbook path. What I am looking for I have to save all new workbooks in another path (Master file path & \ backup folder) and the file extension should be ".xlsm". Can you please help me to fix this issue?

    Please Login or Register  to view this content.

    Thanks in advance.

    Joshi
    Last edited by krjoshi; 03-13-2012 at 08:06 AM. Reason: The issue is fixed
    Reply With QuoteRegister To Reply
  2. 03-12-2012, 01:18 PM #2
    Kelshaer
    Kelshaer is offline
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: VBA Help needed for saving workbook specific folder and file extension ".xlsm"

    Here you Go

    Please Login or Register  to view this content.
    Regards,
    Khaled Elshaer
    www.BIMcentre.com

    Remember To Do the Following....
    1. Thank those who have helped you by clicking the Star below their post.
    2. Mark your post SOLVED if it has been answered satisfactorily:
    • Select Thread Tools (on top of your 1st post)
    • Select Mark this thread as Solved
    Reply With QuoteRegister To Reply
  3. 03-12-2012, 02:03 PM #3
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Help needed for saving workbook specific folder and file extension ".xlsm"

    Hi Khaled Elshaer,

    Thanks for your prompt action and reply, one more issue I want to delete all sheets except “Master” from the “Master” workbook before execute the advanced filter. And, is there any way to share the newly created workbooks thru VBA?

    Thanks in advance.

    Joshi
    Reply With QuoteRegister To Reply
  4. 03-12-2012, 02:20 PM #4
    Kelshaer
    Kelshaer is offline
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: VBA Help needed for saving workbook specific folder and file extension ".xlsm"

    Try this, it will delete all other sheets
    I dont know about the sharing option

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 03-12-2012, 02:41 PM #5
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Help needed for saving workbook specific folder and file extension ".xlsm"

    Hi Kelshaer,

    Thanks a lot, its working great. For your information, the sharing option can be done thru below code.

    HTML Code: 
    Thanks & regards,

    Joshi
    Reply With QuoteRegister To Reply
  6. 03-13-2012, 07:50 AM #6
    Kelshaer
    Kelshaer is offline
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: VBA Help needed for saving workbook specific folder and file extension ".xlsm"

    Thank you for the Sharing thing.
    Please mark the thread as SOLVED
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1