hi all,
in addition to the suggestions had already... try
Option Explicit
'>>
Public Sub Tester()
'for each open workbook
Call Dimagrire
End Sub
'<<
'>>
Public Sub Tester2()
'for one open workbook
Call Dimagrire("Pippo.xls")
End Sub
'<<
'--
Hi Sundarvelan,
Read this article or use VBA Macro mentioned thereby:-
http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http:/
Hi
You have to Delete all un used coloumn and un used row
Affter that u can Create CSV File
On Thu, Nov 25, 2010 at 3:20 PM, wrote:
> Hi
>
> You have to clean up all your sheets. i.e. Re-Set excel last cells by
> deleting un used cells.
>
> Delete all un used coloumn and un used row.
>
> Sent
Hi Sundarvelan,
First, the actual problem need to find out. Only then it can be solved
in an efficient manner.
1. How many worksheets do you have?
2. How many rows and columns are occupied in each worksheet?
3. How many charts and pictures have been used?
Reduction of file size depends on thes
Hi
You have to clean up all your sheets. i.e. Re-Set excel last cells by deleting
un used cells.
Delete all un used coloumn and un used row.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Sundarvelan N
Sender: excel-macros@googlegroups.com
Date: Thu, 25 Nov 2010 12:54:02
