Open File off Network Drive

Hi All:

I'm having a bit of trouble opening a file off of a Network Drive for use in Excel. Problem is that every users drive may be mapped differently, so I must first establish the drive letter. Then I would like to located the file and open it.

FYI newPowerpoint is set as Powerpoint.Application

Please Login or Register  to view this content.

I'm sure it's a simple oversight, but I am not able to open the file using this code.


Thanks in advance

Why not just use the network path instead of the drive letter they have it mapped to?