skengineer
New Member
- Joined
- Jan 8, 2016
- Messages
- 3
I'm working on a utility to save time / simplify a process of copying and pasting an existing compiled (.exe) Excel file into a new compiled (.exe) Excel template. My idea is to create a separate Excel file that contains VBA code to launch the .exe files and automatically do the copying and pasting. To accomplish this, I need to launch the .exe file, unhide and unlock a tab called 'Info', and then copy and paste info from various cells to the other .exe file.
I found the code on how to open the file; I could use some help getting started on how to unhide and unprotect the tab (it's password protected). Any suggestions would be appreciated!
Sub Runcalc()
Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1)
End Sub
Thanks in advance
I found the code on how to open the file; I could use some help getting started on how to unhide and unprotect the tab (it's password protected). Any suggestions would be appreciated!
Sub Runcalc()
Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1)
End Sub
Thanks in advance