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.
Cheers
Ron
Set objExcel = CreateObject(“Excel.Application”)
Set objWorkbook = objExcel.Workbooks.Open(“N:\_REPAIRS\RMAs\RMA_Issued\RMA140829-1.xlsm”)
objExcel.Application.Visible=True
objWorkbook.Worksheets(1).Activate
