Search results

Pls have a read here... https://exceljet.net/formula/faster-vlookup-with-2-vlookups Importing to access & then do the query will take more time as i expected & checked.

Just checked that sorting 1M rows * 8 columns doesn't take time. So do the same first then dual vlookup combination will be much faster.

Good to know that. That's the application constant for object close method. https://msdn.microsoft.com/en-us/library/office/aa220077(v=office.11).aspx

This should to work...check it.

Why .send not working. Have u checked you email address, is this correct. Limit loop to 2. Put your own email in to/cc. Using smtp or exchange?

Change display to send & then check.

Agree! Next instance of mail should be created after closing/sending the 1st else it will occupy lots of memory as loop is in the queue there.

Pls don't duplicate the post. Have patience.

I have plotted few methods. You may manipulate to do further.

Pls don't duplicate the post. Have some patience.

What i suggest that first run a collector file that will collect info from the each pc then put that serial no in the main file which needs to be protected. You can't prevent the smart user!!

Monty Check it if help after little manipulating... http://chandoo.org/forum/threads/match-criteria-then-not-a-print-page.25717/#post-154024

As it was expected & thinking about that... Using array would be fast rather than writing line by line & to check it i have did few test & found below result on a PC having Core2Duo+4GB Ram+Win7+Excel 2007. Best results are... Shri : 2000 cells_0.00390625 Shri : 20000 cells_0.04296875 Shri ...

Thanks Marc L for the light on the same! I might missed that post! Monty : Thanks you too as i leaned something new too today!!

Hi, Thanks for the kind words. I am just learning by helping...

That might got replaced not skipped. Try it. Const sPath As String = "S:\ALL\Planning Team\Weekly Metrics\2017 Weekly_Metrics_Rebuild_V2\Weekly Metrics Reports\Clean Reports\SHORTAGE TEST\" Sub Shortage_Attachments2() Dim ns As Namespace Dim Inbox As MAPIFolder, SubFolder As MAPIFolder Dim...

This is what you need to change.. Print #1, Range("A" & iCntr); & It's fast enough so doesn't need anything else as already suggested by the valuable inputs. The link was for the Concatenate ; whenever you need in future!

Complete read & check the comments....

After reading the article you will have something new to visualize... https://www.experts-exchange.com/articles/7811/A-Better-Concatenate-Function.html

@ThrottleWorks You are just awesome like as chandoo. God bless you my dear. @vletm Keep visiting dude!!

You can create new user with a little code which will check the duplication & add the new to the DB. This also be improved to login/out timestamp. Pls start a new thread for very own query. You may ref the post there.

PP3321 It's because you have copied/imported the data in the sheet thus xl recognized the used range as [B1:C3]. Copy the cells [B2:C2] to another sheet & then check.

This might be useful as having much explanations.. https://www.rondebruin.nl/win/s8/win003.htm

Hi You have just taken a decade to arrange a sample copy from office to home... Not an issue.... I will take care on Monday.

Faseeh Have fun on the beautiful day of your life.