VBA: Go Back A Folder and Get The Main Folder Name

[sanjeevpandey]

Hi,

I have a file in a subfolder, I'm trying to go back a folder and get the name of the main folder in the file (listwb - workbook) name. Its working well until going back a folder, but not after.

My code so far is:

Please Login or Register  to view this content.

listwb is the workbook that I want to save with the mainfolder name in it. The mainfolder name could be 12h30 or 19h30.

The problem is the part "sFolder.Name" is not working, the error is "Invalid Qualifier". What is that? How can I get past this error? I really need to get it done, so please any help would do alot.

Thanks in advance!
Sanjeev

[shg]

sFolder is a simple string variable, not an object. It has no Name property.

[sanjeevpandey]

Hi shg, thanks for your reply.

So, how can I get the name of the main folder? There is the main folder, then a subfolder and the file is in the subfolder. So, I tried to go back 2 folders and get the name of the mainfolder.

How can it be done otherwise then? I've no idea.

[shg]

One way:

Please Login or Register  to view this content.

[Leith Ross]

Hello sanjeevpandey,

Here is another method. This uses the Shell application to return the folder names and paths. I think this is probably the method you wanted.

Please Login or Register  to view this content.