ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,738
- Office Version
- 2007
- Platform
- Windows
Morning all,
Yesterday i added the code supplied below.
I also was using the worksheet after for quite some time without any errors etc.
This morning when i come to use the same worksheet i see the following error message.
Code execution has been interrupted.
I removed the code that was added,saved etc but still this message appears.
Do you see any reason for this.
Many thanks
Yesterday i added the code supplied below.
I also was using the worksheet after for quite some time without any errors etc.
This morning when i come to use the same worksheet i see the following error message.
Code execution has been interrupted.
I removed the code that was added,saved etc but still this message appears.
Code:
Private Sub CommandButton1_Click()
If IsNumeric(txtInvoiceNumber) Then
CreateObject("Shell.Application").Open "C:\Users\Ian\Desktop\REMOTES ETC\DR COPY INVOICES\" & txtInvoiceNumber.Value & ".pdf"
Else
MsgBox "Invoice N/A For This Customer"
End If
End Sub
Do you see any reason for this.
Many thanks