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
Bookmarks