(Dual Monitor) Control Excel Instance Monitor Location -
i have excel workbook opens workbook. looking for, determine location of main workbook in regards of monitor using (dual monitor). , open other workbook in other monitor.
so guess there way through vba determine whether user has dual monitor , extended. , figure out monitor being used main workbook, force newly opened workbook other monitor. , if user not have dual monitors, snap main workbook half screen , other 1 second half.
this have found far. using getmonitorid function value did not change changing monitor used excel window. http://www.developerfusion.com/thread/49351/vb-dual-screen/
using: excel 2013
regards, mahmoud
Comments
Post a Comment