Ligne de commande

previously known as VSO Image Resizer

Moderator: Fabrice

pasmar250659
Junior Member
Posts: 1
Joined: Wed May 31, 2017 2:54 pm

Ligne de commande

Post by pasmar250659 »

Bonjour à tous,

Utilisateur depuis longtemps je souhaite automatiser sous vba. Après analyse des différentes commandes voici l'extrait de ma procédure.

xlDossier = " U:\02016 - Dossier 2016\10485AVT - Rue de Berchon - 7340 Colfontaine\Berchon21"

stAppName = "C:\Program Files (x86)\ObviousIdea\Light Image Resizer 5\Resize.exe " '
stAppProfile = " /profile=original25% /run"

stAppName = stAppName + xlDossier + stAppProfile
Call Shell(stAppName, 1)

Resize s'ouvre correctement mais je ne retrouve pas les photos existante dans le dossier.

Quelqu'un peut-il m'éclairer.

Grand merci
User avatar
Phil
ObviousIdea
Posts: 305
Joined: Wed Mar 16, 2011 11:51 pm
Contact:

Post by Phil »

Hello,

your path contains spaces, so you need to wrap it in quotation marks. I think in VBA you have to double them to use in a string.

It should work like this:

Code: Select all

xlDossier = " ""U:\02016 - Dossier 2016\10485AVT - Rue de Berchon - 7340 Colfontaine\Berchon21"" "

Same also for the profile, if it contains spaces it won't work. Better use quotes:

Code: Select all

stAppProfile = " /profile=""original25%"" /run"
Post Reply