The Question
I'm pumping data into an Excel file, but this Excel file has macros and security is set to medium, so a warning dialog appears asking if macros can be run.
Does anyone know how I can answer Yes to the dialog, or set the security level to Low before my session and restore it to medium after the session?
The Answer
You have to set the registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security
Create or Update the Value "Level" (type REG_DWORD )
1 = Low, 2 = Medium, 3 = High, 4 = Very High
Robert van der Hulst