Command button open a file(path is in CellA1)
Closed
Asif
-
Nov 15, 2011 at 02:11 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 30, 2011 at 05:48 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 30, 2011 at 05:48 PM
Related:
- Command button open a file(path is in CellA1)
- Windows 10 iso file download 64-bit - Download - Windows
- Cs 1.6 money command - Guide
- Kmspico zip file download - Download - Other
- To display a text file in reverse order what command should be used - Guide
- Safari cannot open the page because it is a local file - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 30, 2011 at 05:48 PM
Nov 30, 2011 at 05:48 PM
If this is working
Set DmisParts = DmisApp.PartPrograms.Open("R\PCDMISW\PartProgram.PRG")
Shell "C:\PCDMISW\PCDLRN.exe C:\PCDMISW\PartProgram.PRG"
then you can change your code as
Set DmisApp = CreateObject("PCDLRN.Application")
Set DmisParts = DmisApp.PartPrograms.Open(ActiveSheet.Cells(1, 1).Value)
Shell "C:\PCDMISW\PCDLRN.exe " & ActiveSheet.Cells(1, 1).Value
or may be this
Shell "C:\PCDMISW\PCDLRN.exe " & ActiveSheet.Cells(1, 1).Value & """"
Set DmisParts = DmisApp.PartPrograms.Open("R\PCDMISW\PartProgram.PRG")
Shell "C:\PCDMISW\PCDLRN.exe C:\PCDMISW\PartProgram.PRG"
then you can change your code as
Set DmisApp = CreateObject("PCDLRN.Application")
Set DmisParts = DmisApp.PartPrograms.Open(ActiveSheet.Cells(1, 1).Value)
Shell "C:\PCDMISW\PCDLRN.exe " & ActiveSheet.Cells(1, 1).Value
or may be this
Shell "C:\PCDMISW\PCDLRN.exe " & ActiveSheet.Cells(1, 1).Value & """"