Results 1 to 4 of 4

vba to open closed files remove filter and unhide all hiden colum of opencallsht in folder

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    vba to open closed files remove filter and unhide all hiden colum of opencallsht in folder

    Dear Experts

    I have more than 300 xlsb files in target folder all 300 xl files contains sheet Name "Opencall" In data range met filter and unhide some columns

    i want remove filter and unhide all hidden columns in OPencall sheet in every workbooks through run the vba...

    this is target path "C:\Users\mani\Desktop\OPENCALLS_PERF\Consolidattion"

    find the attachment...
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Save/Closed only macro related files and leave unrelated files open in excel?
    By rdowney79 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2013, 04:17 PM
  2. Combine Data from Closed Files within the same folder
    By lasjbp9 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2013, 10:07 AM
  3. Open every file in the folder, remove merge and wrap, save and close files
    By abdesai in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2013, 04:58 PM
  4. [SOLVED] Open all files in a SharePoint folder (Problem: Files open out of order)
    By holmstarrunner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 10:13 AM
  5. [SOLVED] Why can't I unhide a hiden row
    By JBurke in forum Excel General
    Replies: 7
    Last Post: 01-08-2005, 12: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