Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Full program as-is below. Excel 2010.
Shell refuses to work (PC not MAC), always get error "File not found" no matter how i mangle that line. Naturally, there is NO "help" as this is M$ we are talking about. Sub TestDIR() ' Macro recorded 04/12/2018 by ROBERT BAER ' destPath = "G:\ANALOG" DaTm = Date$ + " " + Time$ Open pPath + "Log.TXT" For Append As #1 ' error "File not found" any variant of Shell. pState = Shell("DIR *.* LOOK.DIR", vbNormalFocus) 'QB3 FORMAT is SHELL "DIR *.BMP LOOK.DIR" Stop Print #1, DaTm + " to " + vNam Close End Sub Help? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shell to another program from Excel | Excel Programming | |||
Is it possible to Shell and remove Excel from memory? | Excel Discussion (Misc queries) | |||
Help: Excel and Shell Command | Excel Programming | |||
Return to Excel after shell an application | Excel Programming | |||
shell out of excel into another app | Excel Programming |