Search results

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...

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...

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 There, I have a table with a few columns, and I would like to loop through the first row and all the table columns and check it's values. If a column value satisfies the criteria then set the entire column format to a certain format. There is a small conversion for the column where there...

Hello There, I came across below sample VBA code (attached snapshot). At start of each line code, there is a line/seq number. Can anyone suggest which tool can be used for such display and use of line/sequence numbers? Thank you & regards, Don

Hello There, I have a given range (eg. C10:G40) where the data will be pasted. Before I could do that I am checking if that given range is empty/available. If yes then paste the data. If the given range is not empty then I would like to do delete the data: 1.If there are any normal data. 2...

Hello There, Are there any possibilities to have a rich textbox, and how can this be implemented in a Userform? Any sample workbooks would be helpful. Appreciate your response. Regards, Don

Hello There, I would like to know the VBA code to get the entire paragraph at current cursor position in a userform textbox. The solution for my previous post to get the entire word at cursor postion was provided by @Hui. I tried to modify the code inthere, in vain. : Reference below...

Hello There, I have a userform with the Textbox. I would like to know the VBA code to get the entire word where the cursor is placed. I have attached a sample workbook for your reference. Thank you & regards, Don

Hello There, In my Userform I have a multiline textbox. The user can load a file content in this textbox as well as they can enter it manually (multi lines). I would like to display line numbers for each line for this textbox. I am not aware, if this could be displayed in the textbox itself...

Hello There, I have a certain chunk of comma seperated values stored in a VBA string variable. In the active worksheet, the user chooses a cell, where it should be pasted. Before it could pasted, I want to make sure there is enough room (rows/columns) for this string value and it does not...

Hello There, I came across a procedure which creates a csv file based on a given range in worksheet. However, it creates a blank line at the end of file which I would like to delete it. Could you please advice how this can be done with the VBA code? Sub ExportAsCSV() Dim MyFileName As...

Hello There, I have a requirement to create a VBA function to return the modifed date time of a specific file in the specific folder of a .zip file. The parameters provided as follows: 1. Folder Path (Path --> C:\) 2. Name of the .zip file (complete folder path including zip file name -->...

Hello There, I would like to know the VBA code for the following requirement: Following parameters passed to the Function: 1. The name of the .zip file (complete folder path including zip file name: C:\FolderFile.zip) 2. Name of the sub directory in the .zip (where the file to be extracted...

Hi There, Attached is the snapshot where it shows a panel on the right hand side of the window. I see in some Excel applications these are used to display messages/userform controls, etc. I don't know what the actual name of this is, so I called it as side panel I would like to know how to...

Hello There, I am looking for a VBA code which would do the navigation/opening of a url in the default internet web browser and checing of it's Tabs. A: The user will pass the following values: Sr. Parameters Values 1 Default Web Browser : Google Chrome 2 URL : www.google.com 3 Web...

Hello There, I have the below sub to which should delete rows based on value match in a table column. It does delete the rows. Could you please assist in correcting the below code or any other VBA Code which could delete rows in a table based on a value matched to a certain column? Sub...

Hello There, I am looking for the below requirement to do it in VBA: 1. User is using web-based Outllook for emails (outlook not installed on desktop). 2. VBA should scan through a subfolder (eg. Inbox/Customer Invoices) 3. Check if the email has an attachment (eg. pdf file). 4. Extract the...

Hello There, I have attached a sample workbook which returns a value, based on 2 search criteria cell value. This is done via for loop I came across a way to do this via Evaluate (Index, Match). I have attached a sample workbook for your reference (which is working on hard coded range). The...

Hello There, I have a excel table which lists summarised data, based on operation of a file. It includes a file name processed on a particular date, and the various totals of it's operation (eg. total : Matched transaction, transaction having No PO, etc.) On another worksheet it gives a month...

Hello There, I would like to know the actual VBA code which can dynamically filter data based on a flexible array. I have a UserForm with a couple of CheckBoxes. Based on the selection of the CheckBox (checked/unchecked), the value required for the data filter should be added or removed from...

Hello There, I have 2 worksheets: Header (Section, Total Quanity, Total Amount) Lines (Section, Description, Quantity, Unit Price) I would like to know the following how this can be achieved using VBA code. 1. The common column between 2 worksheets is Column 'Section' 2. For every Header...

Hello There, I would like to have a Function in VBA which can return the occurence of a given value for the below situation: 1. Data is filtered 2. Search for a value in a given range and count it's occurence (in the filtered area, visible rows only) Parameters for the Function would be: 1...

Hello There, I have a .xlsm file with a Userform which has a Webbrowser. It works good in my machine. When this file is copied to another machine and the Userform is invoked the Webbrowser does not work nor does it gives any error. I checkd the Userform toolbar and the Webbrowser control was...