Use principal components regression. First, run a principal components on the standardized explanatory variables. Then, run a least-squares regression using the principal components to predict your y-variable. As the principal components were caclulated from standardaized varibles, the regression coeffients will be the relative weights.