Excel GetCell "Type mismatch"

[Gintaras]

Yes, it can be because the network folders probably are not mapped to H: and P: in QM process, because QM process runs as admin. There are separate mappings for standard user and admin.

Macro Macro272

Code:

Copy      Help

if !FileExists("H:" 2)
,Wsh.WshNetwork n._create
,VARIANT v=1
,n.MapNetworkDrive("H:" "\\xxx\yyy\zzz" v)
,n.MapNetworkDrive("P:" "\\xxx\yyy\zzz2" v)

Or run your macro in separate process as User. Look in Properties.