macro to run in background

[joshi868b]

Hello
I am running a macro which pings different ip address and update result in excel sheet .but when this macro run a black command window continuously appears till the time it compmetes.it doesnot allow me to do other jobs on pc .i want this macro to run continuously without black screen window so that i can work on other program in pc
Thanks in advance

[Kyle123]

Can't you just write vsbscript that writes to a text file? You could then open this in Excel

[joshi868b]

Can't you just write vsbscript that writes to a text file? You could then open this in Excel

Hello
Dear can u te me what u want me to do shall i post the code

[Kyle123]

Please post your code

[Kyle123]

Have a look here: https://social.technet.microsoft.com...ers?forum=ITCG

[joshi868b]

Please post your code

It reads the ip address from sheet and update reachable or unreachable in other column

Please Login or Register  to view this content.

[Kyle123]

That's what the batch script does in the above link - also, please use code tags when posting code

[joshi868b]

That's what the batch script does in the above link - also, please use code tags when posting code

Kindly explain plz

[Kyle123]

No, did you even look at the link?

[joshi868b]

No, did you even look at the link?

I checked but it is a notpad file how can i update it in excel sheet on a particular column

[joshi868b]

I checked but it is a notpad file how can i update it in excel sheet on a particular column

Still waiting for your reply plz

[joshi868b]

What are the command used to avoid black command window which keeps on flickring when macro run

[gmr4evr1]

Try this after your macro name or Dim line(s)

Please Login or Register  to view this content.

Then, before end sub try

Please Login or Register  to view this content.

[joshi868b]

Try this after your macro name or Dim line(s)

Please Login or Register  to view this content.

Then, before end sub try

Please Login or Register  to view this content.

It doesn't work black screen keep on flickring

[joshi868b]

It doesn't work black screen keep on flickring

My code is below

Please Login or Register  to view this content.

[gmr4evr1]

Don't forget, anytime you use Application.ScreenUpdating = False at the beginning of your code, you MUST put Application.ScreenUpdating at the end of your code.
As for it not working, I'm not sure why you keep getting the flickering.
Could you attach a sample workbook with some data and your code so I can see what is going on with it?

[joshi868b]

Don't forget, anytime you use Application.ScreenUpdating = False at the beginning of your code, you MUST put Application.ScreenUpdating at the end of your code.
As for it not working, I'm not sure why you keep getting the flickering.
Could you attach a sample workbook with some data and your code so I can see what is going on with it?

It is a simple excel sheet having ip address in column b and results in column c

[mgs73]

Try changing you shell command to this:

Please Login or Register  to view this content.

Or you may want to use vbMinimizedNoFocus if you want to be able to see the window.

[joshi868b]

Try changing you shell command to this:

Please Login or Register  to view this content.

Or you may want to use vbMinimizedNoFocus if you want to be able to see the window.

It is showing some error 450
Wrong number of argument or invalid property assignment

[mgs73]

How about this:

Please Login or Register  to view this content.

or this:

Please Login or Register  to view this content.

Hope one or the other works for you - best of luck!

[Kyle123]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

[grimes0332]

You cannot hide the Command Window that appears using wshShell.Exec. You can if you use wshShell.Run but that does not support reading the output via StdOut.ReadAll, you would have to redirect the output to a file and read that.

Live with the flashing window for simplicity.

[joshi868b]

How about this:

Please Login or Register  to view this content.

or this:

Please Login or Register  to view this content.

Hope one or the other works for you - best of luck!

Not working

[grimes0332]

It won't work - seeing the comment in post 10, I suggest you check your other thread.

[joshi868b]

You cannot hide the Command Window that appears using wshShell.Exec. You can if you use wshShell.Run but that does not support reading the output via StdOut.ReadAll, you would have to redirect the output to a file and read that.

Live with the flashing window for simplicity.

Dear Grimes pleaz tell me full procedure i m new to this

[alansidman]

@joshi868b

Please read the forum rules. You have violated two of them. Don't duplicate posts. Use Code tags. I have added the code tags for you and have merged your two posts into this one. Please read the forum rules and abide by them in the future. Future violations of these rules may result in infractions.

[joshi868b]

@joshi868b

Please read the forum rules. You have violated two of them. Don't duplicate posts. Use Code tags. I have added the code tags for you and have merged your two posts into this one. Please read the forum rules and abide by them in the future. Future violations of these rules may result in infractions.

I am sorry for violating the rules beacause of my ignorance kindly send a link of rules so that i will keep the forum rule paramount.

[alansidman]

See attachedCapture.PNG

[MATT.B]

the way you will need to do this is open notepad and paste

Please Login or Register  to view this content.

it the notepad save the file as c:\invisible.vbs c:\ being your root drive or a folder of your choosing but I recommend it be a system folder
then have excel run the ping command using

Please Login or Register  to view this content.

but the problem with this is you no longer have an output for excel to look at you cant do what your doing with out the command window popping up
the command window pops up because there is an output you can suppress the command window but then there is no output and excel gets no data
im still new to vbs but if there was a way to suppress the window output and save it to a text you may be able to do it that way.
I know from the command prompt if you

Please Login or Register  to view this content.

it will save the ping output to a text file but the window will still come up.
I just don't think what your asking is possible but I could be wrong