how to open a Excel File....

[jamiguel77]

hi all, how to open a Excel File but in silent mode, this file have some macros and take so so 40 seconds to open, because execute some macros....

Exist a way for open more fast?

Disabling macros? and disabling references to other workbooks?

Thanks

 

[Logit]

If the file you are attempting to open is large in size .... try saving it as .xlsb

That will reduce the file size significantly.

 

[jamiguel77]

ok, thanks for answer....

a dude(tell me if open a new thead)

the client work with monthly data... and him not want have every monthly data on same workbook. but they need compare March 2017 with march 2018 (by sample) i think in save data in a text file.... (i dont want use sql server, because) the client move into citys, and havent connection to sql server..

Wich you recommend me? any technique?

Thanks

 

[Logit]

Open new thread.