Windows 10: Basic VBScript problem - getting Userforms to work!

I have created loads of Userforms in Excel, but just can't get it to work from a VBScript vbs file...Dim objForm Set objForm = CreateObject"Forms.UserForm.1"fails!This forum implies i need toregsvr32 "C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\MSForms.dll" but that fails with x80000151 system error message.I don't have a MSForms.dll. I do have a FM20.dll in C:\Program Files\Microsoft Office\root\vfs\System\Any ideas.

:)

 

Excel UserForm Frame Border and Color

System OS - Windows 10

Application - Excel 2019

I use UserForms to present or collect information from the end user. Previously the UserForm frame and its color looked like the following:





Currently in the VBA editor, the UserForm looks like the the image below and seems very similar to the former style of the UserForm.





When the current UserForm is displayed to the end user, it looks like the image below:





I am not proficient in Windows, but I suspect that something must have altered some systemwide frame and color parameters. I would like to know that parameters might have caused the change to the display style for the UserForm and how to get the current values of these parameters as well as the default or former values of these parameters that altered the style of the UserForm frame and colors.

 

Is there a way to get a list of all the folders that are open in Windows Explorer using vbscript or a DOS command?

Is there a way to get a list of all the
folders that are open in Windows Explorer using vbscript or a DOS command?

And while we are at it, Is there a way using vbscript or a DOS command, to get a list of all:

1. The .doc? files that are open?
2. The .pdf files that are open?

I just need to know how to get the data; I can make a list from the data.

Any tips about finding out where I could get help in answering these questions would be much appreciated.

Thanks,

Marc

 

Cheap Photo box that will get the job done

WEll i took on this project for PP hes a hardware reviewer and wants to get the professional looking pics for the Pc parts

Materials:

• Big cardboard box

• a razor

• white material 3 yards

• cone lights

• stapler

• medical tape

• pvc pipe about 6 inches longer than your box

• white paint any cheap finger paint would work

the project I'm guessing will cost me $30 if it works out properly
I will post pictures and step by step as i do it