Login / Signup

Excel file loading issue: Application - Load

 
Scripting
Last Post by e.mahaut 5 years ago
3 Posts
3 Users
0 Likes
24 Views
RSS
t.mathew
 t.mathew
(@t-mathewarcinfo-com)
Posts: 64
Estimable Member
Topic starter
 

Hi,
An issue is noted with version 11.2 in opening excel file using the instruction APPLICATION (LOAD,.......... If the path of the excel file contains space inside the folder name makes the excel application open with the wrong file path.

See the images attached, Here made to pass the file location path via argument and it tries to open bad files.
1.

5083=823-ef4f9cc59b9fddf07186755e748d8947

2.

5083=821-547454e21e7a38ed22233d0f2e9566a4

3.

5083=822-104efdd61bd7c243d300063785025914

4.

5083=820-2ae2a10a103b20668492af0ce9726a13

KR
Tijo

 
Posted : 09/06/2021 4:54 pm
f.martin
 f.martin
(@f-martinarcinfo-com)
Posts: 148
Member Admin
 

Hi,

Try to add (escaped) double-quotes to encapsulate the path

 
Posted : 09/06/2021 4:59 pm
e.mahaut
 e.mahaut
(@e-mahautarcinfo-com)
Posts: 270
Member Moderator
 

Hi Tijo,

I confirm the suggestion of Florent.
Here is a sample code
Application("LOAD", "C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE", ""F:\My Folder With Spaces\Extraction.xlsx"");

 
Posted : 09/06/2021 5:05 pm
Forum Jump:
  Previous Topic
Next Topic