I have this simple VBA code below, and I don't know why is not working.

1. How To Enable Macros In Android Phone
2. How To Run Excel Macros On Ipad
3. Eseguire Una Macro Vba Su Android En

What I want to do is to put the VBA Command into a variable as text and run it as a command. In this case, I want to run like MsgBox 'Job Done!' and print just:

Abbiamo due metodi per creare una macro: attraverso lo strumento di Registratore di Macro, integrato in Word, Excel, PowerPoint; attraverso l'immissione diretta di codice VBA, all'interno dell'ambiente Visual Basic Editor. Di questo Editor ci occuperemo nei paragrafi successivi di questa guida.

Job Done!

M-M

2 Answers

You may be tempted by adding your own string 'Executer':

A.S.HA.S.H

Short answer is, you cannot do that (You should not do that) but ... read the following to find out why and see a work around!

As you know you are writing your code in a compiler. What you want to do is running human-legible line of text as a command which is not possible. While you run the program all of it is compiled to machine language. When you pass that line of text to it, it cannot recognize it as a command and you will end up getting an error. What you can do is passing arguments to it:

You can also run an executable which can be written as a text file within a macro and then runs within the same Sub (extension needs to be taken care of).

If you cannot change the variable (i.e. test) then you need to take another approach towards it. I would suggest something like extracting the argument which can be passed to the function and use that. Something like below;

I believe there was a same question on SO but I couldn't find it. I will included it as a reference if found it.

P.S. These two posts may help to find an answer:

ANOTHER SOLUTION

This needs to trust the VB project. Quoting from ExcelForum and referencing to Programmatic Access To Visual Basic Project Is Not Trusted - Excel

Quote:

Place your Macro-Enabled Workbook in a folder which you can designate as macro friendly.

Then open the workbook.

Click on the Office Button -> Excel Options ->Trust Center -> Trust Center Setting -> Trusted Locations.

Then you add your folder (where you have your Excel Macro-Enabled Workbook) as a trusted location.

Also you need to do this:

File -> Options -> Trust Center -> Trust Center Setting -> Macro Setting ->Check the box beside 'Trust access to the VBA project object model'

Close and re-open your workbook.

Those who use your macro should go through the same steps.

Unquote.

Then you can use this which I got from VBA - Execute string as command in Excel (This is not tested)

@A.S.H answer does the thing that last solution intends to implement. I am including it here for the sake of completeness. You can refer to the original answer and up-vote it.

M-MM-M

Not the answer you're looking for? Browse other questions tagged excelvbavariablescommandeval or ask your own question.

This question already has an answer here:

• Run a batch file in a completely hidden way 23 answers

How To Enable Macros In Android Phone

On Windows XP, can I run a batch (.bat or .cmd) file, via a shortcut, without a 'black window'?

Hennesdugresdugres

marked as duplicate by fixer1234, DavidPostill♦ windowsOct 7 '16 at 10:01

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

migrated from stackoverflow.comMay 11 '10 at 18:32

This question came from our site for professional and enthusiast programmers.

9 Answers

Save the following as wscript, for instance, hidecmd.vbs after replacing 'testing.bat' with your batch file's name.

The second parameter of oShell.Run is intWindowStyle value indicating the appearance of the program's window and zero value is for hidden window.

The reference is here http://msdn.microsoft.com/en-us/library/d5fk67ky.aspx

This is just a simplification of Shaji's answer. You can run your batch script through a VBScript (.vbs) script like this:

This will execute your batch file with no command window shown.

Peter Mortensengreatwolfgreatwolf

Just to expand on the 'Use Windows Scripting' answers (which I consider best because it's built-in already) here's how to do it by using a single wrapper script and passing the name of the 'real' batch file as a parameter. Additional parameters will be passed on to the batch file.

So e.g. save the above file as NoShell.vbs somewhere then call:

Finally, if you're looking to run this from somewhere that doesn't understand the .vbs file (such as an 'External Tools' in Visual Studio), you'll want to call C:WindowsSystem32wscript.exe with the vbs file as its first parameter and your batch file as the second.

You can change the properties of the shortcut to run minimized.

To run it completely invisibly you'll need something else, like Windows Scripting.

aleale

How To Run Excel Macros On Ipad

Peter Mortensen

Free GPL open source 'Create Hidden Process'

Microsoft Security Essentials, and probably most other virus/malware scanners will treat the executable, chp.exe, as a virus because it hides whatever program you specify from displaying a window or a task bar button, just like viruses do.

It's not a virus. It doesn't hide the target process from appearing in task manager for example. And of course the source code is included so you can see that it's very small and doesn't do anything but run whatever program you give it.

You don't even have to trust that the included chp.exe really was built from that source. You can go ahead and discard the included chp.exe and compile your own from the source, and all the necessary tools to do so are even free and downloadable.

You can also just make a shortcut to the .bat or .cmd file, then right-click on the shortcut, Properties, Shortcut tab, Run: Minimized. Then in scheduled tasks, use the shortcut instead of the .bat/.cmd file directly. That will prevent a window from popping up, but a taskbar button will still appear.

You can use window scripting such as AutoIt.

As an example, just write this to the AutoIt script editor. It's fairly simple

If you want to run it in a loop,

Compile it as .exe - and you are done.

Likewise, in AutoHotkey:

endolith

Use Hidden Start (costs $20)

Hidden Start - Run Applications and Batch Files without a Console Window or UAC Prompt

Console applications and batch files are regularly run at Windows startup or in a schedule. The main inconvenience of this is that each application opens a console window that flickers on the screen. Hidden Start (or Hstart) is a lightweight command line utility that allows you to run console applications and batch files without any window in the background, handle UAC privilege elevation under Windows 7 and Vista, start multiple commands in parallel or synchronously, and much more.

endolith

Simple solution, without using any extra programs.

Eseguire Una Macro Vba Su Android En

1. Create the batch file you want to execute and test it.
2. Create a shortcut for it.
3. Edit the properties of the shortcut: in the Shortcut tab, choose Run Minimized. Assign a hot key to it and you're done!

Good luck!

Not the answer you're looking for? Browse other questions tagged windowscommand-linebatch-fileshortcuts or ask your own question.