Retrive and wait macro

[shreeku]

Hi Friends.


Can you help me out in creating Macro, i am working in Bloom blerg, i need a macro to retrieve data from the other macro which we already have a addin in the excel, i want a macro to retrive data for 1000 rows (changable) wait for 10 or 15 second (changable), then go to other 1000 rows and do the same..

HI guyz is it possible can this be done?

Attaching file for reference.

[JBeaucaire]

Application.Wait is used in a macro instruct the macro to pause for a certain amount of time.

[shreeku]

Application.Wait is used in a macro instruct the macro to pause for a certain amount of time.

Thanks JBeaucaire for the info, so how should i set up the macro with this can u help me out!

[JBeaucaire]

A minimalist example, this macro will look UP column A to see how many rows of data there are, then it will add that formula into column B for you into 1000 cells at a time, forcing them to recalculate, then pause 15 seconds, then do the next 1000 rows, etc, until all the rows have been processed. This is to give you a starting point you can adjust for your needs.

Please Login or Register  to view this content.

[shreeku]

Hi JBeaucaire, is there a way to add a input box(lcol = InputBox) code for the ticker number "=BPD(security ticker, RC1, 5122)" (i.e the 5122 code is changable) and input box(lcol = InputBox) for the wait time how much time we need to wait.

[JBeaucaire]

Maybe:

Please Login or Register  to view this content.

[shreeku]

Hi JBeaucaire, i forgot to mention that the Security ticker is in open and closed inverted comma's i.e "Security ticker" when i am making changes in this row

Please Login or Register  to view this content.

it changes to red and gives compile error..

[shreeku]

Hi JBeaucaire, can u help me on the compiling error!

[JBeaucaire]

Maybe:

Please Login or Register  to view this content.

[shreeku]

Hi JBeaucaire, i am getting "Mismatch error runtime error 13" and also i want data from 2 column that is B2 , so it should check what is the data in cell A2 and should display data in cell B2 and so on...

[JBeaucaire]

So this is different from your originally posted example? BPD is a function not in the workbook, so I can't speak to how/whether it works. My macro above as based on helping you enter the "formula" I saw in your original workbook the same way I saw it entered. You have a better workbook example?

[shreeku]

Hi JBeaucaire let me check in my office and i will get back to u!, coz i cant check it now at home! but what abt the other column. but from my knowledge i am attaching file this might be more clear

[JBeaucaire]

Maybe change the column reference in that line of code:

Please Login or Register  to view this content.

[shreeku]

Hi JBeaucaire i have attached the file this might be more clearer to u! but thanks Bro for ur prompt and Quick Reply really Appreciate on this!

[JBeaucaire]

These are extremely simple edits, you're going to have to be able to make tweaks like this yourself if you're going to employ VBA.

The same exact macro from post #6 with only the edits described in #9 & #13:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[shreeku]

Hi JBeaucaire, The macro works fine till the 1000 row after that it shows "Runtime error 13” type mismatch" the below Code gets highlighted..

Please Login or Register  to view this content.

[shreeku]

Bro can u help me out!

[JBeaucaire]

When you DEBUG at that moment and hover your mouse over that line of code, what is the value of WaitTime?

[shreeku]

Waittime=15

[JBeaucaire]

Spotted a typo:

Please Login or Register  to view this content.

[shreeku]

will try tomorrow and let you know Bro! thanks what if there are many rows need to be retrieve what changes i have to do...