Search results

Thank you @Marc L for taking the time to provide an excellent code. It has reduced a lot of the vba code lines and also the creation of csv file is much faster. Your code will also be of help to others :):cool::awesome: Regards, Don

Thank you for your response. Please find attached the files: 1. Sample workbook with the macro 2. Csv file generated from step 1 (with a blank line at the end of the file) 3. Expected CSV file (without a blank line at the end of the file) The current Macro (as below) which we are using...

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

Thank you Marc

Thank you Marc for your help. Regards, Don

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

Hi, For me, I have never seen before parameters being defined as (ZP$, ZF$, EP$, EF$, T$) with $ sign. Overall the whole function is something new learning experience. Thank you for taking the time to write the Function. What is the benefit of defining parameters in such a manner than the...

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

Thank you for your reply. I found something which might be useful: https://www.engram9.info/excel-2007-vba-2/creating-custom-task-panes.html Will have to further dig it Regards, Don

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

I came across some post on the net, regarding sending webmail using CDO option. Would this feature be used to achive my requirements using VB and how? Thank you & regards, Don

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

Thank you mohadin for the correction. It deletes one occurence of the row. I would like the following: 1. To delete all occurence of the rows which matches the Find criteria ( pTable.ListColumns("Batch Number" = pBatchNumberValue) Look forward to hearing from you. Regards, Don

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

Thank you Fluff13. This is also new and good to know. For understanding purpose, I suppose for me your previous solution is good. Regards, Don

Thank you very much Fluff13 :):awesome: Regards, Don

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

Hi @vletm Yes, my original post is via 'VBA code' and that is what I am looking for. Knowing it to do with formulas is nice to know for me. Power Query is something new for the users and for me too (which was for a diferrent post). However, they would like to see how this requirement can be...

Hi @vletm Sure I will give it a try with the formulas (was a nice to know information). I would be glad to know how this could be done via VBA code, so this can be executed always on demand (with a button) Regards, Don

Thank you AlanSidman for the tutorial links. I will go through the same. Would you know how this can be done via VBA? Regards, Don

Thank you very much p45cal :awesome::) Regards, Don

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

Thank you p45cal, it works good. I haven't tried Power Query, so no idea how this would work. It is asking a bit more from you. If possible and time permits, could you mention in steps how did you do this? Regards, Don

it highlights the below line on button press (Debug): and when the highlihted line is changed to and button pressed: it gives this error message: Regards, Don