User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
     
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.  Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
 
 All Forums
 Xequte User Forums
 Other Software and Discussion
 Import Text Lightning from Excel

Note: You must be registered in order to post a reply.

Size 
UserName:
Password:
Mode 
Format  BoldItalicizedUnderline Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailBrowse for an image to attach to your post Insert CodeInsert QuoteInsert List
   
Message 

 

Emoji
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Black Eye [B)]
Frown [:(] Shocked [:0] Angry [:(!] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
dougransom Posted - Jul 14 2017 : 12:17:01
1. I frequently need to import a triple from excel database (fund code, description, commission, attachment name) into a text lightning that will produce output like

fund code description
disclosure: $25 ticket charge. Commission paid by issuer: commission. Product details attached.

Is there a way in text lightning to use an existing quick text and to just fill in the blanks from the import step?

2. For future release request support for macro-enabled spreadsheets (xlsm).


doug ransom
1   L A T E S T    R E P L I E S    (Newest First)
xequte Posted - Jul 16 2017 : 00:56:20
Hi Doug

1. You can import the data on the fly from an ini file, e.g.

%ADVANCED_READ_FROM_INI_FILE:C:\MYPRODUCT.INI[MAIN]FUNDCODE%

Where MYPRODUCT.INI is a text file formatted like:

[MAIN]
FUNDCODE=12345
FUNDDESC=My description

2. We'll consider that in the future


Nigel
Xequte Software
www.xequte.com
nigel@xequte.com