Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: VB6 open Excel file problem
10-25-2007, 07:50 PM #1
- Join Date
- Mar 2007
- Thanked 0 Times in 0 Posts
VB6 open Excel file problemCode:
Set objStockList = CreateObject("Excel.Application") Set objStockListWB = objStockList.Workbooks.Open(StockListPathName, ReadOnly:=True) Set objStockListSH = objStockList.Sheets objStockList.Windows(1).Visible = False
This is used in an unattended program, thus no manual intervention is possible.
The first time this is attempted, the response is a message box indicating a choice of: "switch to" and "retry".
What can I do to avoid the unnecessary message box. The VB6 program losses focus, so it cannot send a "sendkeys".
"Good software like good food takes time to prepare"