Hi Guy's hope you are all well, i am basing this code to open a file from my camera SD card, when an image is taken, is stores as file name DSC then maybe 6 numbers afterwards, when the SD Card is cleared, another image taken can be another number
ie: DSC00390, Next image maybe DSC00391 etc....
I ma trying to open a file that starts in DSC then anything afterwards, the code below just says file not found
Code:Dim camFile as String, SrcPath as String, DriveSelect as String DriveSelect = Forms!frmMainMenu!cboDrive 'e:f:g: etc SrcPath = DriveSelect & "\DCIM\101MSDCF\" CamFile = "DSC" & "*.*" I think it's this line i have got wrong ? Application.FollowHyperlink SrcPath & CamFile