-
Could anyone tell me why this is not working?
I have the file created and in the correct directory but it still doesn't work - any ideas?
Private Sub mnuAbout_Click()
Shell ("Notepad.exe" & App.Path & "\About.txt")
End Sub
This is also not working:
txtTotal = Format(txtTotal, "#.000")
Any idaes on it?
Thanks,
JO
-
Answer #1:
You need a space between the app and the file path and get rid of the parathensis.
Code:
Shell "Notepad.exe " & App.Path & "\About.txt"
Answer #2:
Most likely the value being past in not an integer. try the following.
Code:
txtTotal = Format(cInt(txtTotal), "#.000")
-
Thanks, Answer#1 worked!!!
Answer#2 didn't - it only displays one decimal now.
-
I'm sorry it was my mistake Answer#2 works,
Thank you so much
JO
-
No Problem, let me know if you need anything else.