This is giving me some error-messages, but I have noticed that you changed the backslash in
{SKIPIF{MERGEFIELD Anz}= "0"}{QUOTE{INCLUDETEXT "{FILENAME \p}
\..\sb{MERGEFIELD Anz}.docx"}}
to a double normal slash "
//..//sb"
and after I changed that in the word doc, the old excel code is running perfectly.
The only problem remaining is that Excel replaces "." with "_" can I somehow stop that?
I have the following .bat-file to change parts of names in a file.
How can I change the path to the path of the folder that the .bat file is in (so that everyone can use this on his computer)?
And can I integrate this in the excel vba code?
And here is what i wrote in the .bat-file:
Code:
@echo off
Setlocal enabledelayedexpansion
Set "Pattern=_"
Set "Replace=."
For %%# in ("C:\Users\AZEM\Work Folders\Desktop\Verteidigungsanzeigen\*.docx") Do (
Set "File=%%~nx#"
Ren "%%#" "!File:%Pattern%=%Replace%!"
)
Pause&Exit