General discussion

Locked

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.

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

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to After Hours Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums