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.
Thanks.
By: JJ Liaw
This is one awesome blog.Thanks Again. Keep writing.
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.
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.
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!
Thanks-a-mundo for the blog article.Really looking forward to read more. Cool.
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.
Methadone Rehab Free Substance Abuse Treatment ÿþ< Youth Substance Abuse Drug And Alcohol Inpatient Rehab Near Me
ÿþh
Very informative blog post.Thanks Again. Really Great.
Great article.Really thank you! Cool.
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.
Samhsa Treatment Medical Alcohol Rehab ÿþ< Substance Abuse Treatment And Family Therapy Local Drug Treatment Centers
ÿþh
You are brave.
Drug Treatment Programs Alcohol Treatment Near Me ÿþ< Local Alcohol Rehab Centers Suboxone Rehab
ÿþh
Alcohol Recovery Near Me Alcohol Recovery Programs Near Me ÿþ< Inpatient Drug Treatment Alcohol Outpatient Programs Near Me
ÿþh
Hi,Great, you liked our content.
Drug Rehab For Young Adults Drug Treatment Rehab ÿþ< Christian Alcohol Rehab Suboxone Program
ÿþh
When you make a mistake, you fix it.
Inpatient Drug Treatment Facilities Free Rehab Facilities ÿþ< Residential Alcohol Rehab Substance Abuse Programs Near Me
ÿþh
thanks for the great say as usual
Really enjoyed this post.Thanks Again. Great.
Thanks for the useful info.
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.
Wow, great blog post.Really thank you! Really Cool.
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!
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?
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!
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.
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!
Hello there! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains. If you know of any please share. Thank you!
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?
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?
셔츠룸 You should be proud of yourself.