Excel VBA reference a macro variable inside quotes -
Excel VBA reference a macro variable inside quotes - i'm trying reference string macro variable insude quotes. here's have. why couldn't &state. arrrggg! thanks dim state string state = "ak" workbooks.open filename:= _ "\\sac-psas-02\pm\ma\scott\ow\hpi trend pci outlier removal\lr_hpi_""" & state & """ .csv" simply: "\\sac-psas-02\pm\ma\scott\ow\hpi trend pci outlier removal\lr_hpi_" & state & ".csv" (you need multiple " within string when want " character) excel-vba