Highlighted

VBA problem with text from InDesign and Again after update

Community Beginner ,
Apr 18, 2020

Copy link to clipboard

Copied

I hava a problem in VBA excel I am taking text using methods:

Set AdobeInDesignApp = CreateObject("InDesign.Application")
AdobeInDesignApp.Charset = "utf-8"
Set AdobeInDesignOpenedDocument = AdobeInDesignApp.ActiveDocument

 

and If I take text using:

AdobeInDesignApp.Documents.Item(1).TextFrames.Item(i).contents

I can see some "???" etc. How to do it in correct way ? 

I have also formatted text in InDesign. 

Once I do it like that 

AdobeInDesignApp.Documents.Item(1).TextFrames.Item(i).contents= Replace(AdobeInDesignApp.Documents.Item(1).TextFrames.Item(i).contents, "000", "19999")

 

it changed my price correctly but break correct formating : 

Correct before:

1.JPG

Wrong after

 
TOPICS
Scripting

Views

228

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

VBA problem with text from InDesign and Again after update

Community Beginner ,
Apr 18, 2020

Copy link to clipboard

Copied

I hava a problem in VBA excel I am taking text using methods:

Set AdobeInDesignApp = CreateObject("InDesign.Application")
AdobeInDesignApp.Charset = "utf-8"
Set AdobeInDesignOpenedDocument = AdobeInDesignApp.ActiveDocument

 

and If I take text using:

AdobeInDesignApp.Documents.Item(1).TextFrames.Item(i).contents

I can see some "???" etc. How to do it in correct way ? 

I have also formatted text in InDesign. 

Once I do it like that 

AdobeInDesignApp.Documents.Item(1).TextFrames.Item(i).contents= Replace(AdobeInDesignApp.Documents.Item(1).TextFrames.Item(i).contents, "000", "19999")

 

it changed my price correctly but break correct formating : 

Correct before:

1.JPG

Wrong after

 
TOPICS
Scripting

Views

229

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Apr 18, 2020 0
Community Beginner ,
Apr 18, 2020

Copy link to clipboard

Copied

2.JPG

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 18, 2020 0
smolar22 LATEST
Community Beginner ,
Apr 20, 2020

Copy link to clipboard

Copied

hi, I still need a help 😞

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 20, 2020 0