Send Parameter Into Macro

[ryanlcs]

Hi

I have a macro in which I will trigger it to run automatically, under windows scheduler. Eg:

"D:\Data\Macro.xls".

I am expecting to pass parameter in such way, which I did for my other exe application.

"D:\Data\Macro.xls" parameter_1.

I want the macro to read the parameter_1 in such way.

No idea at all whether this is possible.

Thanks.

[rwgrietveld]

Why not make a User Defined Function and place it in personal.xls. This way it is available to you (ALWAYS) and you can pass parameters at will.

[ryanlcs]

I am not sure about what you mean. Can u pls elaborate more? thanks.

[Andy Pope]

I don't think you can pass or read the command line parameters as you can with a standalone application.

Can you write the parameter to a text file and get your macro to read the information from there?

[ryanlcs]

I am able to read from a text file.

But actually my concern is that if this macro is a "scheduled" macro, then macro will handle it differently as compare to manual run. So, reading the parameter from text file doesnt solve it.

[Andy Pope]

Do you mean you don't want the code to execute if the workbook is opened manually rather than be the scheduler?

In which case the existance of the text file can be used to determine whether a scheduled run is required.

Or did you mean something else?