Can you tell me please how to transfer data from vba to excel sheets I have got data from api call and parsed it and now I have something ticket number stored in a variable in a vba and now I want that big column like output in immediate window to go to excel sheet .
Hi, I replied to you on the same question in the other video (which was more related to the question). The key is in this other video: ua-cam.com/video/dSZ1DJuutnI/v-deo.htmlsi=AqukQWaEjWM_7PZY
This converts the range data into HTML, I give some examples of its application in the beginning of the video. If you want to create a web table with the same formatting of an Excel table, you need a much bigger macro that will read each of the formatting properties and translate into HTML/CSS.
Hello Sir. I have found your vba classes helpful. Kindly I request how we can add dynamic controls on listbox to delete update and add data to excel sheets. I watched this video ua-cam.com/video/jHd3UI4hi8Y/v-deo.html and wished to know if it can be done on a userform in a listbox other than on sheet cells thanks
Cara, eu fiz algumas adaptações no código que você mostrou para ficar mas adequado ao meu projeto, e foi de grande ajuda. Brigadão mesmo.
Can you tell me please how to transfer data from vba to excel sheets
I have got data from api call and parsed it and now I have something ticket number stored in a variable in a vba and now I want that big column like output in immediate window to go to excel sheet .
Hi, I replied to you on the same question in the other video (which was more related to the question). The key is in this other video:
ua-cam.com/video/dSZ1DJuutnI/v-deo.htmlsi=AqukQWaEjWM_7PZY
You are not converting it. You are building it from the data. I was hoping for a direct conversion so it would pick up cell formatting.
This converts the range data into HTML, I give some examples of its application in the beginning of the video. If you want to create a web table with the same formatting of an Excel table, you need a much bigger macro that will read each of the formatting properties and translate into HTML/CSS.
Hello Sir. I have found your vba classes helpful. Kindly I request how we can add dynamic controls on listbox to delete update and add data to excel sheets. I watched this video ua-cam.com/video/jHd3UI4hi8Y/v-deo.html and wished to know if it can be done on a userform in a listbox other than on sheet cells thanks
I just replied to you on the same question in other video: ua-cam.com/video/jHd3UI4hi8Y/v-deo.htmlsi=iKQgDtfc1JjE3cVe