Retrieving the path of my PnP device using VBA

**Bigard** · 02-26-2020, 10:11 AM

Hello everyone !

So I'm working on a macro that has to retrieve the path of my PnP device in order to run a .bat file. To call the bat file I use the Shell() function. Both of the doc (containing the macro) and the .bat are in the said PnP device.

Before sending my doc and the bat to the my USB key, I tried it on my PC and everything runned smoothly. Since everything is on the key I can still retrieve the path (as shown in the code down bellow) but the bat file doesn't run because Shell() doesn't find the script.

So hum... yeah... how can I get a valid path to the .bat for Shell() to run ?

Please Login or Register  to view this content.

As you can see I tried different methods to retrieve the path in hope it would be accepted by Shell() (Spoiler : it was no use :p).
I hope my explanation was clear enough.

Looking forward to your answer !

PS : it's my first post on this forum, so tell me if I should post that somewhere else. Plus : I didn't find any thread discussing that particular question, but if I'm wrong I'd be more than happy to check it out

**rorya** · 02-26-2020, 12:27 PM

If the document and the batch file are in the same folder, then you should be using ActiveDocument.Path rather than a hardcoded path.

**Bigard** · 02-27-2020, 06:10 AM

Thank you for your answer.

Actually I did try that solution. You can see the code line in my 1st post above (as a comment since I didn't want to lose it and wanted to show you I tried different solutions).

Here is the said line :

Please Login or Register  to view this content.

So if I rewrite that part of the code, it will go like this

Please Login or Register  to view this content.

Once executed I get the error "5" which is "incorrect argument or call of procedure".

By the way I tried something else since yesterday :

Please Login or Register  to view this content.

So what I'm trying to do with this is to literally call the shell, and make it run cmd after cmd in order to move from the C: drive to (in my case) D: drive (not glamorous, I think we can all agree on that).

Once again the Shell function doesn't seem to understand several cmds as it returns the following error :

Please Login or Register  to view this content.

But I need to research a bit more about that.

**rorya** · 02-27-2020, 06:18 AM

What path did filepath contain? You may need to enclose it in quotes:

Please Login or Register  to view this content.

**Bigard** · 02-27-2020, 06:46 AM

Ok so I made it work !

On my PC :
filePath contained "D:\USB_Campaign"
filePath1 contained only the first 2 caracters on the left, so : "D:"

I saw the solution with the "quotes enclosure", but I tried this one first :

Please Login or Register  to view this content.

And it works !

Retrieving the path of my PnP device using VBA

LinkBack

Thread Tools

Rate This Thread

Display

Retrieving the path of my PnP device using VBA

Re: Retrieving the path of my PnP device using VBA

Re: Retrieving the path of my PnP device using VBA

Re: Retrieving the path of my PnP device using VBA

Re: Retrieving the path of my PnP device using VBA

Thread Information

Users Browsing this Thread

Similar Threads

Using Excel File one device.

Save to a USB device

Excel file use only one Device

In/Out Device tracking system

[SOLVED] Retrieve USB Disk Device ID

EXT engaging when using an external 10-key device

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions