Different hard drive lettering

Hi all
Very new to forum life so apologies if I get this wrong or my question is a bit basic.

My problem is that for some unknown reason my work laptop hard drive is designated as d: not c:.
Therefore when I write a macro that accesses winzip on my d: the same macro will not work on just about all other pc's with the normal c: designation.

Is there a way I can make the drive references generic, I've read about unc drive naming but that seems to me to be network drives and I can't see how it relates to local drives.

Many Thanks

Mike

Hi Joseph
The path leads to winzip to open a logfile and get at data for analysis in a user form/spreadsheet

Code extract:

Please Login or Register  to view this content.

so the macro is looking in d: prog files for 7-zip and thus would not work on a pc with c: