• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy the column vales to .ini file and delete the old values in .ini file.

mteas

New Member
Hi!

Herewith i am attaching the Excel File. My Requirement as follows.
1) When I Press the Button number at the end of each column then those column values to be copied.
2) The above copied cell values to be pasted in .ini file / .txt file as rows.
3) So, Excel Column vales should be Copied and pasted as rows in Output file (.txt/.ini).
4) Old Values to be deleted before pasting.
4) save the output file in c drive path.
5) Open the saved file .

Out put text file as below

[Value]
OrderType=Limit Order
TP=40
SL=20
Qty=75
Inst=FUTIDX
Segment=NFO
Symbol=BANKNIFTY
Option=CE
Strike=10200
Expiry=25JUN2020
 

Attachments

  • excel to .ini file output..xlsx
    11.4 KB · Views: 3
Last edited:
mteas
You missed few parameters,
but You can continue from this.

Hi sir,
Is it possible to copy (Transpose) the values to sheet 2 instead of .txt file output. i need button click mode at the end of each column in sheet 1. Thanks in advance.
 
mteas
...hmm?
> to copy
- - that would mean eg that Your could manually copy & paste all from sheet1 to sheet2 - no need any vba.
> button click mode end of each column
- - what would that mean?

You should reread Forum Rules
There are useful sentences for You, especially in
How to get the Best Results at Chandoo.org
 
Back
Top