Use string variable instead of string it Excel VBA

Question

I'm fully new with Excel VBA and struggling already for hours to use a string variable instead of writing the string. Probably a very simple solution, however I cannot seem to find similar cases nor did anything I tried work out :s

I define a variable name NewSbWb (= "REQ1351") as following

Dim NewSbWb As String
NewSbWb = ActiveWorkbook.Sheets(1).Range("D2").Value

if I then use functions such as the following:

Workbooks("REQ1351").Activate

or

currentSheet.Copy Before:=Workbooks("REQ1351").Sheets(sheetIndex)

I would like to use the string variable NewSbWb instead of writing "REQ1351".

I hope one of you can help me. Many thanks in advance!

Simply: Workbooks(NewSbWb).Activate

Alex K.
– Alex K.

2015-06-29 13:31:58 +00:00
Commented Jun 29, 2015 at 13:31 — Alex K.
– Alex K., Commented Jun 29, 2015 at 13:31

Gotrekk · Accepted Answer · 2015-06-29 13:32:36Z

1

Dim NewSbWb As String
NewSbWb = ActiveWorkbook.Sheets(1).Range("D2").Value
Workbooks(NewSbWb).Activate
currentSheet.Copy Before:=Workbooks(NewSbWb).Sheets(sheetIndex)

answered Jun 29, 2015 at 13:32

Gotrekk

4943 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use string variable instead of string it Excel VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related