excel-macro

I am trying to fetch all web tables but I am not able to fetch them. I have tried same program for other website and its working but for this particular website its not working at all. Sub Export_HTML_Table_To_Excel() Dim htm As Object Dim Tr As Object Dim Td As Object Dim Tab1...

Have any excel VBA code that can filter criteria previous month last transaction?

Can Someone help me with my project? I am beginner in Excel-Macro. I have to copy a 1 column that is a merged cell and paste it to another merged cell but in the new Sheet. Please do help me Excel-Macro Gurus..! I really need your help. ありがとうぐざいます Best Regards, Lex

I have a checkbox that does a lot of work on a worksheet depending on if its value is true or false. It was working fine until today, I decided that I wanted to have the checkbox also Lock or Unlock a cell dependent on its value. The whole code is as follows: Private Sub CheckBox4_Click()...

Hi all, Been searching online for a solution but to no avail. Problem: I have 2 different excel files, excel A and excel B. Excel A has age time money Excel B has age time date I need to combine these two columns of both file to be the same, age time date money. Cheers, Jack

Hi. Glad to be apart of the community even if for a short period :D So, my problem... I want to get the weeknumber from a date in a cell using an excel macro. I have this code right now, but I keep getting a compiler error If...