Excel Memory "Leakage" & Disabling a Hyperlink

[Mang]

Hi everyone,

Its been a long time since my last posting. Now I have 2 questions that hopefully you guys could help.

1. I notice that whenever 1 ran my macro file for more than once at any one time, the macro will most likely than not will return with an error msg of file not found etc. Anyway, the macro is designed to process about 100 to 400++ files any any one time. To avoid the problem, I will have to close Excel completely and re-open it again. Is this a memory leakage problem or is it something else that I have missed or don't know.

2. In one of my code lines, it will execute a hyperlink that is linked to a Dos batch file. Thus Excel will normally asked for a confirmation to run the link. I want to disable the confirmation "notice", and I have tried to insert a "display alert = false", but still it doesnt work. What is the effective way to do this ?

Your assistance is most appreciated.


Salute and thank you.


- Mang -

 

[BrianB]

1. Could well be a memory leakage. Presumably you are closing the files down after processing ? You do not say which version of Excel you are using. Later versions should not be such a problem. Here is some code that I use :-
http://www.mrexcel.com/board2/viewtopic.php?t=145246&highlight=

2. Try running your batch file using Shell - something like this :-

    ' RUNS COMMAND.COM
    RSP = Shell(Environ$("COMSPEC") & " /c  c:\test.bat", vbNormalFocus)

 

[Mang]

Thanks for the reply Brian. And yes as you presumed, I'm using Excel 2000. But since I just got home from work.

I'll try to simulate your suggested codes slightly later tonight.

Anyhow, any idea on my second problem ? i.e.
" In one of my code lines, it will execute a hyperlink that is linked to a Dos batch file. Thus Excel will normally asked for a confirmation to run the link. I want to disable the confirmation "notice", and I have tried to insert a "display alert = false", but still it doesnt work. What is the effective way to do this ? "

Thanks.

 

[BrianB]

I have suggested an alternative.

 

[Mang]

Oops sorry. Yes you did.

I've yet manage to recompile the codes with the suggested solutions.

Anyhow, whether its a smooth sail or problems .. I'll keep you posted.

Thanks again.

- Mang -

 

[Mang]

Hi Brian and everyone,

Just to update a bit since my last reply.

I've manage to test all the codes with your suggested "codes" and it works superbly. It ran faster and yes it solves the memory problem as well.

Thank you so much.

- Mang -