Triggers on a table

If I have a trigger on a table to detect INSERTS and I insert a record not via SSMS but via a SQL script embedded in some Excel VBA, does the trigger capture it or does it only work inside of SSMS?

A trigger on a table will fire regardless of what application is modifying data within that table, unless the trigger is disabled.