[SOLVED]Run macro with excel in background

[stersergiu]

Hi,
Is it possible to run a macro with excel and not act in each excel window just like Application.ScreenUpdating = FALSE ? Or a similar thing like copying the clipboard contents with s.getclip into a file s.setfile("file.txt") ?
I've tried searching for similar results on the board but couldn't find anything.

Thanks

[pedrotairum]

The file part is possible. The Excel, I didn't really understood what you want to do.

As for the file you can do like this:

Function Function2

Code:

Copy      Help

str file="$desktop$\file.txt"
str s

s.getclip
s.setfile(file)

[stersergiu]

When you run a macro in EXCEL VBA with Application.ScreenUpdating = FALSE it doesn't show the whole processing of the macro. It runs in background and it does it faster. I want to ask if Gintaras has something like that implemented in QM.

[Gintaras]

Macro Macro2151

Code:

Copy      Help

ExcelSheet es.Init
es.ws.Application.ScreenUpdating=0
;...

[stersergiu]

Thank you Gintaras !