Posts: 35
Threads: 16
Joined: Apr 2018
12-28-2021, 12:44 AM
(This post was last modified: 12-28-2021, 12:45 AM by apeso.)
Have tried to do something like this when I have at least a file with .dll extension:
if("D:\Harvest\02_GVP_IVRIntelPiloto (Piloto)\PGVITPL.21.12.06.1746 F-118933 - Copy\*.dll")
out "exists"
else
out "don't exists"
But it outs "exists" despite I have moved all .dll files to somewhere else .
Posts: 1,338
Threads: 61
Joined: Jul 2006
use Dir instead
like this
Dir d
if d.dir("D:\Harvest\02_GVP_IVRIntelPiloto (Piloto)\PGVITPL.21.12.06.1746 F-118933 - Copy\*.dll") ;;if file exists
,out "exists"
else
,out "doesnt"
Posts: 35
Threads: 16
Joined: Apr 2018
12-29-2021, 06:31 PM
(This post was last modified: 12-29-2021, 06:36 PM by apeso.)
Thank you, that worked locally but,
I have noticed that if I try to validate a file in a folder shared by a server like: \\##.###.##.##\anything\0001_SUV_RB_CAT_TIPO_PRODUCTO_MI.sql
The result is "doesnt" even though it exists... then tried to opening the file with:
run "\\##.###.##.##\anything\0001_SUV_RB_CAT_TIPO_PRODUCTO_MI.sql"
And it appeared a user form asking for credentials, after inform credentials, have tried to validate again and works with "exists". Is there a way to use the current user session in order to avoid to have a user instance with access privileges to the folder for Quick Macros?
Posts: 1,338
Threads: 61
Joined: Jul 2006
12-30-2021, 03:49 AM
(This post was last modified: 12-30-2021, 03:56 AM by Kevin.)
Try to run the macro/function as non-admin.
see this post for an explanation
https://www.quickmacros.com/forum/showth...9#pid23039