macro opearation in a file to be performed in background

[mahendra]

hi,
I am working with a excel file having some auto open macro,which process my data and file closes automatically. but during this whole operation the excel window appears on my desktop for about one second. I need this excel window must not appear and all operations in excel must be performed in background only so that i can save my processing time.

thanks in advance. please help me.

 

[venkat1926]

It is not clear what you want. any how add a code at the beginning
application.screenupdating=false
and then at the end before the end sub
application.screenupdating=true

 

[mahendra]

i have already incorporated these two comments these are helpful in hiding the all operations going inside the excel sheet but still file opens for a short duration,on my desktop. so i need that all this activity must be performed in background without opening the excel. please help me.

 

[GTO]

Is the workbook being opened programatically? If so, is it being opened by another workbook's code?

 

[mahendra]

thanks for reply. I am opening these workbook through a batch file.in which autoopen macro performs required data processing inside the file and workbook closes automatically through macro.

 

[GTO]

A batch file as in DOS?

 

[mahendra]

yes it is in dos. a batch file running programs from command prompt directly.

 

[GTO]

Okay. Sorry, but I know very little DOS. Maybe Kenneth Hobson or someone will stop by, but I don't see how you would be able to get it started in a hidden state.

If it is that much of a pain to have the file "flash" for a second, could the batch file run a .vbs script instead? I think you could use the .vbs file to create excel and open the file without being visible.

Just out of cureiousity, what's the command line look like? Do you use Start? (Sorry, as stated very little knowledge on top of a bad memory)

Mark

 

[Jaafar Tribak]

As Mark suggested you could run a VBS program instead of the Excel program.

example:

Open NotePad Place in it the following 2 lines and save it with a .vbs extension.

Set oHiddenExcelInstance = CreateObject("Excel.Application")
oHiddenExcelInstance.Workbooks.Open " Enter your Workbook Path & Name here"

Then , from the commandline run the vbs script.

Regards.

 

[mahendra]

thanks for ur accurate reply i am try this solution. and inform u soon.