Search:
Type: Posts; User: jssutton11
Search:
Search took 0.02 seconds.
-
Thanks for pointing out the problem, it works now. However, I still have a problem opening up the external VBS program when the cell is clicked. I have copy and pasted the VBS code into the same...
-
I'll just post it, it's not long:
On Error Resume Next
Set objWShell = CreateObject("Wscript.Shell")
Set objShell = CreateObject("Shell.Application")
Set objShellWindows =...
-
When I run the code, I have a ton of instances of the program that I called, and it owns my computer. It all executes immediately.
-
Yes, here is my whole code in the worksheet:
Sub ErrorRateAnalysis()
Dim excelReport As Workbook
Dim cellValue As String
Dim rng As String
-
The call to an external program works fine, it's just that sub routine is executing the program immediately when it sees "check" in a cell, where I want it to give the cell the option to be...
-
Also, I want to be able to have the code loop through the spreadsheet and then have the option in each of the cells with "check" in them to double-click and open the program. This code, when tested...
-
The original code works for notepad.exe, but it doesn't work when I want to open a .vbs file. Is there any reason why it won't open a .vbs program?
-
Hi, I want to have a sub routine that will run through an excel spreadsheet and whenever a cell has "check" then it will let that cell be double-clicked to open up an external VBscript that I have...
|
Click Here to Expand Forum to Full Width
|