We have to take more than 100 invoices from tally and rename the client name. Now, my question is how can I get those invoice from tally erp9 to MS excel using macros?
We have to take more than 100 invoices from tally and rename the client name. Now, my question is how can I get those invoice from tally erp9 to MS excel using macros?
I do not know what you are referring to.
What is tally erp9?
Is it a text file? If it is please attach it to your reply
- is the data sensitive? you may not want to attach the file....
Something you could try:
Click Data Tab
Get Data from Text
Navigate to the file
and see what Excel imports for you automatically
Last edited by kev_; 05-31-2017 at 06:33 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
tally erp is our accounting software
You will need to look at all the options in your software
Is your accounting software Windows based?
Is there an option to EXPORT data?
If Windows based, then you may find the option under File..\.Export... (this is a guess ...)
If you find the Export option, then you need to export the data and it may be possible to export as an Excel file or a csv file
- those would probably be the best options for you
Last edited by kev_; 05-31-2017 at 06:53 AM.
thanks, we can do that manually. but i want do that automatically, How to do it?
kev deleted this post- Sucuri was misbehaving!
Last edited by kev_; 05-31-2017 at 09:20 AM.
Use Excel to interrogate your accounting files
- Your data files may be protected by your accounting software
- data may be encrypted so that Excel cannot read it (again this is a guess - I do not know your software)
- Even if Excel could interrogate your accounting files directly, it would be safer to use the Export function that is built into your software for this purpose.
- this involves interrogating accounts data files, find the invoices file, find the invoices you want.... etc - sounds very tricky
- ask software vendor if this is possible
or Use Excel to automatically select options in accounting software
- I do not know if Excel could do that automatically
- ask software vendor if this is possible
this is a test post
- reply text being blocked by firewall I will amend later
thinks for replay...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks