General discussion


VB Script to open Excel Spreadsheet

By rwtate ·
Tags: Off Topic
Greetings; I have a working VB script that opens a network based excel file. I am embedding it in a barcode so that when scanned the spreadsheet opens for a technician to manually enter information on it. I do not want to auto-populate any cells once it is open. The problem is that it loops. The script continues to open the file again and again. I need to find the right syntax to stop that loop but leave the file open for editing. Any help with this would be most appreciated.


Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("N:\_REPAIRS\RMAs\RMA_Issued\RMA140829-1.xlsm")

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums