SUU-Design Forum

I searched the forum, VTM FAQ etc. but did not find any advice in regard of the following problem.

I am using VBA in Ms Office Access to automate certain operations. What I want to do is to open a selected vtx file in VTM Viewer in order to watch the movie from a selected episode (picture on the vtx file).
I am not a novice in VBA programming!

I tried shell command in the following format:

Shell """C:\Program Files\Video Thumbnails Maker\PicturesThumbnailsViewer.exe "" ""E:\_Marek\Pobieranie\_________TEMP1\_____CLASSIC MOVIES\____FOR ASSES\_Fabularne\After Death by Fassbinder 1989\After Death 1989.mp4.vtx""", vbNormalFocus

where the path and name of the vtx file is explicitly provided as a string in quotes.

However, I need to use the same functionality where the path and name of the vtx file is carried by a string variable.
I tried several combinations of "&" and "", such as the following one where the variable FilePathandName carries the full path and name of the vtx file

Shell "C:\Program Files\Video Thumbnails Maker\PicturesThumbnailsViewer.exe " & """" & FilePathandName & """", vbNormalFocus

but none of various such combination really worked. PTV either did not open at all, or opened displaying the blank screen as if no vtx file was send to it.

I will appreciate your advice and an example of the VBA correct syntax to be used for the aforementioned functionality, where the path and name of the vtx file is carried by a string variable.

Can you try to run the command in Windows command prompt on your PC? Will it work for you?

admin wrote: ↑02 Jan 2025, 21:41 Can you try to run the command in Windows command prompt on your PC? Will it work for you?

Code: Select all

"C:\Program Files\Video Thumbnails Maker\PicturesThumbnailsViewer.exe" "E:\_Marek\Pobieranie\_________TEMP1\_____CLASSIC MOVIES\____FOR ASSES\_Fabularne\After Death by Fassbinder 1989\After Death 1989.mp4.vtx"

admin wrote: ↑02 Jan 2025, 21:41 Can you try to run the command in Windows command prompt on your PC? Will it work for you?

Code: Select all

"C:\Program Files\Video Thumbnails Maker\PicturesThumbnailsViewer.exe" "E:\_Marek\Pobieranie\_________TEMP1\_____CLASSIC MOVIES\____FOR ASSES\_Fabularne\After Death by Fassbinder 1989\After Death 1989.mp4.vtx"

Hello, thanks for your reply. W tried as I was advised and PTV displays correctly. However, if the same syntax is used in VBA, it will not work. After a couple of attempts I found that the syntax in VBA should be:

Shell """C:\Program Files\Video Thumbnails Maker\PicturesThumbnailsViewer.exe """ & Space(1) & """N:\____NON-PROK\Siempre juntos\Siempre_Juntos__2007_[1].avi.vtx"""

Anyway, the latter syntax works perfectly and thank your for your assistance.
Rgds
Marek

It does not seem to be a "normal" VBA syntax, as other applications, i.e. media viewers require a different one.