Popup Userform on System's

Hi Parth,

If you are opening the Shared drive using a .bat file, you may not need Excel. You can put a Windows Script Host command in your Batch file that opens a MsgBox that looks exactly like an Excel MsgBox.

See the attached zip file that contains two files with the following code:
a. ExcelForumVbsPopUpMessage.bat - Windows Command File
b. ExcelForumVbsPopUpMessage.vbs - Windows Host Script File

Sample Windows .bat file ExcelForumVbsPopUpMessage.bat:

@echo off
rem ExcelForumVbsPopUpMessage .bat
rem
rem
rem Output a message to the Windows User

rem Pushd   Reference: http://ss64.com/nt/pushd.html
rem Change the current directory to the folder of the currently running .bat file
pushd %~dp0

rem Start   Reference: http://ss64.com/nt/start.html
rem cmd.exe Reference: http://ss64.com/nt/cmd.html
rem Wscript Reference: https://en.wikipedia.org/wiki/Wscript
rem
rem  /min = Run cmd.exe minimized
rem  ""   = No Window Title
rem /c    = Terminate cmd.exe when wscript is completed
rem
start /min "" cmd.exe /c wscript ExcelForumVbsPopUpMessage.vbs

Sample Windows .vbs file ExcelForumVbsPopUpMessage .vbs:

'* ExcelForumVbsPopUpMessage.vbs
'*
'* MsgBox Reference: https://msdn.microsoft.com/en-us/library/sfw6660x%28v=vs.84%29.aspx
'*
'* Output a message to the Windows User
MsgBox "This is line one of a message."   & vbcrlf &   _ 
"This is line two of a message."   & vbcrlf &  vbcrlf &  _ 
"This is lline four of a message (no line 3)."   & vbcrlf &   _ 
"There is probably a 1024 Character Limitation."   & vbcrlf &   _ 
"This is the Last Line.", _
vbOKOnly, _
"Title"

Lewis