Using defined macros in a VBScript

[ChrisF]

I'm using VBPro v7.2

I set up macros to start my script, for example

macro name = PROJECT_DIR
macro value = C:\My Projects

I can then use the macroin subsequent steps, like copying files, for example

source dir = %PROJECT_DIR%\source

But now I want to use the macro in a step that has a VBScript, and the macro NEEDS to be inside quotes. So without the macro, I do

dbFile = "C:\My Projects\myFile.db"

How can I do the equivalent of this instead?

dbFile = "%PROJECT_DIR%\myFile.db"

[kinook]

Within a Run Script step, you can reference it just like that. If the code is in project/global script (View | Other Windows | Script Editor), use

dbFile = Application.ExpandMacrosAndScript("%PROJECT_DIR%") & "\myFile.db"

http://www.kinook.com/VisBuildPro/Manual/runscript.htm
http://www.kinook.com/VisBuildPro/Manual/scripteditor.htm

[ChrisF]

Thanks, this worked like a charm!