RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
A macro will be very useful if anyone can create a very challenging macro in excel by the name Generate XML
In the excel sheet, It should first select data from say A2 to the last column say A50 and from A2 to the last row where the data is entered say A1000. Note: -This data may vary in rows and columns from time to time.Hence the data should be copied till the last row where there is data. Copy it.
A file is saved in the folder ABC on the desktop. Open the file. There are different types of file folders in the folder. Select the sheet with the name ImportData.xml, right click and open in Notepad + +, paste the copied data from excel in the importdata.xml sheet in a particular line say line 15. Save the xml sheet and close. Right click the folder Importdata.xml, go to properties, click the security tab, select the whole path mentioned next to object name and copy.
Next it should go to the tally folder. A tally is already open with a company name. It is at the start - home page Gateway of Tally. In tally it should select and enter the “import data option” which will take you to another folder “import data”. In import data select the vouchers option and enter. That option will take you to another folder import vouchers and in the name of the file to be imported (XML) , paste the path copied from Importdata.xml in the space.
The macro should stop here after the path is pasted in tally.
In the excel sheet, It should first select data from say A2 to the last column say A50 and from A2 to the last row where the data is entered say A1000. Note: -This data may vary in rows and columns from time to time.Hence the data should be copied till the last row where there is data. Copy it.
A file is saved in the folder ABC on the desktop. Open the file. There are different types of file folders in the folder. Select the sheet with the name ImportData.xml, right click and open in Notepad + +, paste the copied data from excel in the importdata.xml sheet in a particular line say line 15. Save the xml sheet and close. Right click the folder Importdata.xml, go to properties, click the security tab, select the whole path mentioned next to object name and copy.
Next it should go to the tally folder. A tally is already open with a company name. It is at the start - home page Gateway of Tally. In tally it should select and enter the “import data option” which will take you to another folder “import data”. In import data select the vouchers option and enter. That option will take you to another folder import vouchers and in the name of the file to be imported (XML) , paste the path copied from Importdata.xml in the space.
The macro should stop here after the path is pasted in tally.