VBA 2016: open file, minimize, write to another file, filter

In my VBA.xlsm (2016) …

1. want to open 2 big data excel files (data1.xlsx and data2.xlsx) to read.

2. conside the speed, I want to minimise both of them.

3. after read data from data1.xlsx, it is not used anymore. so, I want to close it.

4. after process the real data in data2.xlsx all result are save into my_array(y, y) (it is big array as well.)

5. want to open a new output file (new_output.xlsx) to write my_array(x,y)

6. want to filter new_output.xlsx to some other sub-files.

my questions…

1. 2: I did it manally. HOW TO DO IT FROM MACRO?

3: Don’r know how to do it from macro.

4: OK.

5. Done. But it spent a long time (2 hr). How to improve the speed? (close data2.xlsx before write?)

6. I can do the filer function. But, don’t know how to FILTER OTHER FILE.


By: JJ Liaw

432 thoughts on “VBA 2016: open file, minimize, write to another file, filter

  1. Sewa Bus Pariwisata Jakarta

    Now i’m planning to start my personal blog soon, but I am slightly lost on anything. Would you suggest starting up with a free system like WordPress or proceed for a paid choice? There are so several choices available that I am completely confused. Any ideas? Thanks a lot.

  2. kertas undangan

    I simply desired to thank you thus much again. I feel not sure the issues that I would have got gone through without typically the form of hints revealed by simply you regarding that condition.

  3. Loretta Uram

    Great website. Lots of useful information here. I’m sending it to a few friends ans also sharing in delicious. And naturally, thanks for your sweat!

  4. sewa bus pariwisata

    Some us know just about all in relation to the compelling method you present powerful methods on this web site and consequently strongly encourage contribution through other ones on this kind of subject while our personal child is actually discovering the great deal. Have enjoyable with the rest of the portion regarding the year.

  5. produksicetak.com

    Hello. This particular awesome article couldn’t become written much better! Reading through this post reminds me personally of my previous space mate. He always stored chatting about this. We will forward this web site to him. Fairly specific he will have the good read. Thank an individual for sharing.

  6. vertical blind

    Do an individual mind if I offer a couple of the posts as long since I provide credit and even sources back to your own blog? My blog is usually in the same specialized niche as yours, and my personal users would benefit through some of the data you provide here. Remember to let me know in the event that this ok with a person. Thank you.

  7. astm f1852

    Hey there! I know this is kind of off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having difficulty finding one? Thanks a lot!

  8. tension control bolts

    I was wondering if you ever considered changing the layout of your site? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or 2 images. Maybe you could space it out better?

  9. modern construction equipments

    Have you ever considered about including a little bit more than just your articles? I mean, what you say is valuable and everything. But think of if you added some great photos or videos to give your posts more, “pop”! Your content is excellent but with pics and video clips, this blog could undeniably be one of the best in its niche. Excellent blog!

  10. Youtube

    Hmm it looks like your site ate my first comment (it was super long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I too am an aspiring blog writer but I’m still new to everything. Do you have any tips and hints for beginner blog writers? I’d certainly appreciate it.

  11. home cleaning

    Great website you have here but I was curious about if you knew of any discussion boards that cover the same topics talked about here? I’d really like to be a part of online community where I can get comments from other experienced people that share the same interest. If you have any recommendations, please let me know. Kudos!

  12. house cleaning

    I’m curious to find out what blog system you happen to be using? I’m experiencing some small security problems with my latest site and I would like to find something more safe. Do you have any suggestions?

  13. motherhood and work life

    I’m curious to find out what blog system you have been working with? I’m having some small security issues with my latest site and I would like to find something more risk-free. Do you have any recommendations?

Comments are closed.