Use VB to distinguish between an xlsx event from C# Interop or Excel program -
i have event want triggered when user closes .xlsx file. have c# program regularly checks content within same file. problem have when c# program (which uses interop) closes .xlsx file, triggers vb code. there way isolate access excel file know edited within excel program?
i want vb code triggered when user edits file within excel.
thanks
i decided have c# program create temp file @ beginning , delete @ end. if vb sees temp file, means c# must editing excel file, otherwise can assume user.
Comments
Post a Comment