Popup Userform on System's

[Parth007]

Hi Team,

We have shared drive in our system..
the shared drive is accesssed by 5 users daily to access some files..

Now can we have a popup macro here..
means

When all users open the drive then one Excelfile Userform should open as a popup,The userform have some instructions in it...
the user will read the instructions & click Yes Button.. after which the excel file should close..

This file should open on everyones system once a day...any assistance thank you

[LJMetzger]

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:

Please Login or Register  to view this content.

Sample Windows .vbs file ExcelForumVbsPopUpMessage .vbs:

Please Login or Register  to view this content.

Lewis

[Parth007]

Hi Lewis... actually i am worried if i could put anything in windows script host..would be in C drive ..

Actually users login to shared drive... & once the user connects to shared drive then only the userform should be open ....
userform have some instructions written on it & one button to close the userform thats it...

only the users connecting to shared drive should be able to see it...

shared drive connects automatically as user logins in a system..in future we can update the user form instructions too & hence i thought of keeping the userform in shared drive so that every user connecting to shared drive will be able to see this atleast once a day... plz suggest

[LJMetzger]

shared drive connects automatically as user logins in a system

Probably not. When the User Logs in, there is probably a Startup .bat file created by the Administrator that connects the User to the Shared Drive. This is probably where you're message should be inserted, whether it is from a UserForm (in an Excel File) or by any other means.

There has to be some way to trigger whatever displays your message, and that is also probably from the 'Startup' .bat file. I know of no way of triggering something spontaneously.

I hope this helps.

[Parth007]

Hi Lewis.. where will we place this .bat file or .vbs? If after a week if there is a change in message how do we updte it.. please assist..
I am puzzled as to if users are more than 100 i will have to copy paste this .bat file in all systems

[Keebellah]

Man, use a little logic thinking. If it's a shared folder then all you need to do is place BOTH files in the shared folder an just INFORM the users what they need to do, run the batch file (I'd use the .cmd extension instead of .bat)
I tested it here nice job @LJMetzger thanks for sharing

[Keebellah]

A minor change to the vbs code:

Please Login or Register  to view this content.

This way you can see what the meaning is and then you can continue depending on the user's choice.

[Parth007]

Hi Kebellah, yes that what i thought of saving both the files in Shared drive.. however the users donot follow if i ask them to run the file..
& so it should get automatically popup in their screen forcefully so that they could see it once a day.

[Keebellah]

Hi, it's very simple, if this a process that is required you explain this and have each user set a link in his / her startup folder so that it startup when they login.
It's just a question explaining.
If it's on a network you can ask the network guy to place this in the user's startup script.
All tasks and work procedures start and end with the users complying with the stated policies.
Train the users and you'll probably succeed, if they see the need and advantage, who knows ...

[Parth007]

Thank you so much.. i will test this script in my system..

Putting in Startup is a good idea...
how do i set the belwo code...

Please Login or Register  to view this content.

[Keebellah]

What do you mean by 'How do I set the below code...'?
You save the code a a vbs script (it's the same as a batch file only it's a vbs script because the vbs extension describes what it's going to do

The text in code block below is what you can mail to the users to have them place it in their startup folder or paste it in their desktop but then they will have to click it themselves

Please Login or Register  to view this content.

ExcelForumVbsPopUpMessage.vbs is the name you have give this file, you can also name it something like else like 'DailyPopUp.vbs'

[Keebellah]

What do you mean by 'How do I set the below code...'?
You save the code a a vbs script (it's the same as a batch file only it's a vbs script because the vbs extension describes what it's going to do

The text in code block below is what you can mail to the users to have them place it in their startup folder or paste it in their desktop but then they will have to click it themselves

Please Login or Register  to view this content.

ExcelForumVbsPopUpMessage.vbs is the name you have give this file, you can also name it something like else like 'DailyPopUp.vbs'