02-03-2022
05:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
02-03-2022
05:10 AM
Hi,
I'm currently working on a rule which exports the bom to an excel. I need to add an additional column which adds the name of the main assembly to each row, as shown in the attached image.
I currently have something like this:
'Add additional data to macro excel GoExcel.CellValue("C:\User\Desktop\" & test & ".xlsm", "Parts List", "K1") = "Mainassy" GoExcel.CellValue("C:\User\Desktop\" & test & ".xlsm", "Parts List", "L1") = "assembly1" GoExcel.CellValue("C:\User\Desktop\" & test & ".xlsm", "Parts List", "M1") = "Amount" GoExcel.CellValue("C:\User\Desktop\" & test & ".xlsm", "Parts List", "N1") = "1"
But i need something that will add the text to all cells in a column instead of just one.
Does anyone know if there is a possibility to do this?
Solved! Go to Solution.