卸载了office后,装了WPS发现BOM和座标导出都出错了;修改了宏处理文件,WPS与OFFICE两环境下与PADS-layout软件座标导出+BOM导出软件自动关联,附件贡献给大家!
互相修改程序接口就行了:
将: Set xl = GetObject(,"Excel.Application")
改成:Set xl = GetObject(,"Et.Application")
将: Set xl = CreateObject("Excel.Application")
改成:Set xl = CreateObject("Et.Application")