vbdirectory

Hello, I am looking for some help with my Code. I am getting a File not Found error whenever I try to use anything but the root directory "C:" for the PathName. Thanks, CB Sub GetSubFolderNames() Dim FileName As String Dim PathName As String PathName = "C:\Temp" FileName = Dir(PathName...

I'm receiving an error message ... (Compile error: Duplicate declaration in current scope) ... when I run some code that has 13 components, but I believe it's the following two components that are the issue ... one of the components copies a template sheet multiple times and renames them...

Hi all, I have two functions that I routinely use to check for the existence of paths to files ... I am attempting to debug another sub, and so was trying to compile my entire project in the hope of finding flaws in my code. In the block below, I am receiving a warning "Compile Error: ByRef...

Good Day All how to create new Word 2010 XML Format and later by create folders are need and fill with required XML thanks Sub creatWordXml() Dim FilePath As String, docPropsFolder As String, relsFolder As String, wordFolder As String, relsFolder1 As String, themeFolder As String...

Hi, If I wanted to test if any of these filepaths exist and if not to create, what would be the simplest way to nest create? e.g. S:\Folder1\Folder2\Folder3\Folder4 What I've been using is.. but can it be shortened? If Len(Dir("S:\Folder1\", vbDirectory)) = 0 Then MkDir ("S:\Folder1\"...

I'm trying to create a two-dimensional loop that loops through a file path that puts the folder name in one column, and then the files in that folder in the second column. The output should look like this: <tbody> Folder 1 File name 1 Folder 1 File name 2 Folder 1 File name 3 Folder 2...