+ Reply to Thread
Results 1 to 3 of 3

Paste value all files in a folder

  1. #1
    Registered User
    Join Date
    06-02-2016
    Location
    dubai
    MS-Off Ver
    2010
    Posts
    0

    Paste value all files in a folder

    Plz help.. I want to remove all the formulas in the excel file with in a folder. All are files having same formulas in same sheet name. More than 1000 workbooks are there.

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

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    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
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Paste value all files in a folder

    Hi mukesh2namitha
    Welcome to the Forum

    It is best to post questions in one of the main Forums, such as here:
    http://www.excelforum.com/excel-programming-vba-macros/
    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

+ 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: 1
    Last Post: 04-14-2016, 04:07 PM
  2. Creating a Designated Folder with Disabling cut Copy Paste and opening all files
    By Nimishk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2015, 09:58 AM
  3. Replies: 2
    Last Post: 11-15-2015, 01:33 AM
  4. [SOLVED] Copy/paste Range of worksheets of several files in a folder to a master file
    By mrjinx007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2013, 01:02 PM
  5. Copy a Template workbook ans paste in a multiple Files in a Folder
    By arvind1979_3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2013, 09:07 AM
  6. search list of files in a folder and paste a image from activesheet and paste to files
    By khan.washik in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-25-2012, 01:37 PM
  7. Copy a row from 3000 excel files stored in a folder and paste it in a new workbook
    By hubertus in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2009, 10:34 AM

Tags for this Thread

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