Recent content by leowang

I solved it, and thank you all above to give the suggestion. that's great.

Hi, buddy, anyone can help me to figure out why this one does not work. very appreciate you help. Thanks in advance! Sub WeightedAverageCalculation() ' 'this one is doing weighted average calculation 'from different file paths, different workbooks and different worksheets...

hey, there, I have a VBA module that I need to reference a file path in the module. (1) I am wondering is there a way that I can make define the path as a varible and then reference the variable? Instead of typing:S:\Jobs and income indicators project\1994-2006 files\workbook's name.xls every...

hi, there, thank you very much,,,,,. I read your code you actually provided, but I have some difficulties to get the referable ideas from that, sorry about that. Leo

Hi, boblarson Could you let me know how to do it? or provide an example for me? very appreciate you. leo

hi, everyone, I am new for VBA, please someone helps me on this problem. the question is after i got the data from my local drive, i have a difficulty to calculate my weighted average in specific cell. I put what i wrote down for a reference. very appreciate your help. sub...

Hey,Wayne, I have a question regarding this with the same logic, but I could not calculate using formula, so my question what i should do ? Thank you so much and very appreciate. sub WeightedAverageCalculation() Dim pathname As String Dim filename As String Dim fullname As String pathname =...