Hi Noorain,
unfortunatelly it won't help, but you give me some thoughts,
Thanks you it helps
Pawel
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Friday, July 13, 2012 10:21 AM
Subject: Re: $$Excel-Macros$$ long opening file o
s but my knowladge is still not there, sad but true.
> Maybe some other solution, please.
>
> Regards,
>
> Pawel
>
>*From:* Divaker Pandey
> *To:* excel-macros@googlegroups.com
> *Sent:* Friday, July 13, 2012 9:40 AM
> *Subject:* Re: $$Excel-Macros$$ long opening
Hi lupinski,
Please try it once again..
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 R
ening file on the external server
try to calculate required calculation with the help of macros.
Divaker
On Fri, Jul 13, 2012 at 12:14 PM, pawel lupinski wrote:
Hi All,
>
>I need your help on this issue. I have quite big file (21MB) that is doing a
>lot of calculation between tab
try to calculate required calculation with the help of macros.
Divaker
On Fri, Jul 13, 2012 at 12:14 PM, pawel lupinski wrote:
> Hi All,
>
> I need your help on this issue. I have quite big file (21MB) that is doing
> a lot of calculation between tabs, in order to run this file more efficient
>
Hi All,
I need your help on this issue. I have quite big file (21MB) that is doing a
lot of calculation between tabs, in order to run this file more efficient I've
switch off calculation, and I'm switch it on when needed. When I've done this
file on my computer its opening slowly but not so ba
