Search results

It is a inhouse developed application hosted in Amazon Cloud. Can you provide some info. regarding Power Query connecting to other stuff? Can we write VBA code for Power Query? Thanks

Wonderful @Marc L :DD Thank you

Thank you @p45cal. This works. It did not bring any dialogue box. I wouldn't prefer this, as there would be many XML transformation to the various Tables We have an excel VBA workbook which gets connected to a non-excel application. We request data from this non-excel application only via it's...

Thank you, it works

Thank you p45cal. Good idea to know about Power Query. In VBA, the XML data is received from another application and stored in a VBA variable. From this VBA variable it needs to be displayed in a given Table. The structure of the XML received can vary (rows, columns). How can I do this Power...

Thak you for Marc for the hint. I found some code on the web. Not sure how to go about it. Workbook.XmlImportXml (Data, ImportMap, Overwrite, Destination) Workbook.XmlImportXml (<stringData>, <ImportMap ?>, Overwrite, <Range>) What would be the ImportMap, as my structure of XML (columns...

Hello There, I have a XML output received from another application stoerd in a string variable. I would like to show this data in the same workbook and in an exiting table. I am looking for the VBA code to successfully bring about the above requirement. I have attached a sample workbook...

Please ignore my previous post (11), my mistake The code works perfect :):awesome: Thank you @Marc L

Hello @Marc L Thank you for taking the time for the code. Never used Wend, good to know. I executed the code, it displays the second part of the output correct. The first part gets missed out (attached a printscreen) Please advise Regards, Don

If you consider this as an assignment then I will buy you some beer (if it is okay with you) :) I should have solved it by yesterday. But whenever you have time available and can look into it, that would be wonderful :awesome:

Hello p45cal, All I know is, I am seeking your help. I wrote the code and it turned out to be too lengthy & messy one. Discarded it at the end. I am looking forward for a smarter way to get this working and learn too. That is why the post in the forum (with detail description). Regards, Don

Hello @Marc L, @p45cal Thank you for your repsonse. Attached a sample workbook with the explanation for your reference. Regards, Don

Thank you p45cal. The formula would be useful. I will kepp this in mind. For my requirement it has to be in VBA. I will post a sample workbook soon as requestd by Marc Regards, Don

Hello There, I would like to have a VBA Sub which would do the following: Below varaibles: a. l_Paragraph = "A string is any series of characters that are interpreted literally by a script. :x_For example, hello world :x_and LKJH019283 are both examples of strings. In computer...

Super. Thank you @p45cal :)

Wow, this works good. :):awesome::cool: Thank you very much @p45cal for taking the time to make it work. This is very useful and I have learned something good from you. I will study your solution specially the array part. I will try it out with a bigger lText_CSV value. Based on your solution...

Hello @p45cal Thank you for your reply. There is no physical file assigned to lText_CSV. The variable lText_CSV gets the value assigned from a API Webservice response and should be dumped into an Excel Table. This is the reason I included a small sample data assigned to lText_CSV, imitating...

Hello there, I have the below variable which stores a text string (comma separated) from some previous process. This needs to be reflected in a table (to be placed on Table Header Column 2). Please find attached the Sample Workbook.xlsm, which copies the variable string in the clipboard and...

Hello There, I would like to have a VBA Function(s) which would get the below information and return the result as a String. I tried to search on the web and got some but not all the values. My code is quite messier and it takes quite some time to get the results. : Win32_ComputerSystem...

Hello @vletm Thank you for the DoEvents tip. It did improve the performance I tweaked your code to first check if the cursor is in a table. Then look for special cells, after clearing check if the range is clear then exit for as below. Somehow it is working much better. Thanks again for your...

Hello @vletm Your solution worked so far very good (below mentioned with a slight modification) Recently, there came quite a large range. The Excel file was freezing (Not Responding). I searched a lot for the possible options and added some lines of code, still the freezing issue remained...

Wonderful! Thank you it works good Regards, Don

Thank you for the sample code. My excuses. Please find attached sample workbook (Sheet2) for your reference. Somehow the control did not go into the expected Elseif. Below snapshot of the cell format, and the format via VAB Msgbox. Both look different Based on your code, I added another...

Hello @Marc L I have one last column to convert. I tried to follow your given code but couldn't make it. Therefore the request. 3rd Elseif statement ElseIf IsDate(.Value) And .Value <> .Text Then 'This is for period_names As seen in the below snapshot, the period name column...

Super! Thank you very much @Marc L Regards, Don