vba - Array Concatenate text and variable -


i create array follows:

dim vhdr variant  vhdr = array("jogo", "sala", "operadora", "semana", "nsemana", "acumulado semana 3") 

however, in "acumulado semana 3", 3 variable called semana_atual.

i tried:

vhdr = array("jogo", "sala", "operadora", "semana", "nsemana", ""acumulado & "" - "" & " & semana_atual") 

but didn't work.

what if try (for vba):

vhdr = array("jogo", "sala", "operadora", "semana", "nsemana", "acumulado semana " & semana_atual) 

just need order quotation marks. (i added 'semana' referring need, not have tried).


Comments

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

javascript - Clean way to programmatically use CSS transitions from JS? -

android - send complex objects as post php java -