Dear SG,
Please open all files on share drive & then run this macro at your end.
Revert me if get any issues in it.
On Thu, Jul 5, 2012 at 7:12 PM, SG wrote:
> hi Noorain,
>
> thanks alot.I haven't tried this.Before trying, i would like to ask some
> queries.I'm not too good in macros...will
hi Noorain,
thanks alot.I haven't tried this.Before trying, i would like to ask some
queries.I'm not too good in macros...will this macro reduce the size of
files placed at share drive or should i open all files on share drive &
then run this macro at my end??? Please clear my doubts on it.
Dear SG.
Please try it..
Option Explicit
Sub SHRINK_EXCEL_FILE_SIZE()
Dim WSheet As Worksheet
Dim CSheet As String 'New Worksheet
Dim OSheet As String 'Old WorkSheet
Dim Col As Long
Dim ECol As Long 'Last Column
Dim lRow As Long
Dim BRow As Long 'Last Row
Dim Pi
Hi Experts,
I'm in crunch situation.Let me try to explain.We have some Excel files
named-1,2 & 3 saved on network share of pune & they are really very heavy
like 40 MB each. What i have to do is to fetch the data of current week for
eg. week-27.I have analysed them & the trend of data is irreg
