refer to variable named workbook

Related to a previous question,.
How can I refer to a variable named workbook.

Set wb2 = ThisWorkbook.FullName Replace("Performance", "Scoreboard", , , vbTextCompare)

doesn't work
and I have tried a few combinations.
Sorry if I am a pain.
LVL 1
Stephen ByromWarehouse/ShippingAsked:
Who is Participating?
 
Chris BottomleyConnect With a Mentor Commented:
IN fact I missed a bit, brackets!

Set wb2 = Application.Workbooks.Open(Replace(ThisWorkbook.FullName, "Performance", "Scoreboard", , , vbTextCompare))

Chris
0
 
Chris BottomleyCommented:
Have you tried:

Set wb2 = application.workbooks.open replace(thisworkbook.FullName, "Performance", "Scoreboard",,,vbTextCompare)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

the syntax for the replace function is

Replace(expression, find, replace[, start[, count[, compare]]])

In your previous question (which would have been a lot easier to find if you had posted a related question or included a link to the previous question), this line of code was suggested:

application.workbooks.open replace(thisworkbook.FullName, "Performance", "Scoreboard",,,vbTextCompare)

Your current line of code is missing an element:

>> Set wb2 = ThisWorkbook.FullName Replace("Performance", "Scoreboard", , , vbTextCompare)

You do not state the "expression" bit, but seem to supply the "find", "replace" and "compare" bits only.

I'm not quite sure what you want to achieve, but maybe

Set wb2 =  Replace(ThisWorkbook.FullName, "Performance", "Scoreboard", , , vbTextCompare)

<not tested!>

If that does not help, please post your code in full and explain the context of what you are trying to achieve.

cheers, teylyn
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Stephen ByromWarehouse/ShippingAuthor Commented:
Thanks again for the help.
The assistance I get on here also helps me understand more the syntax etc.
Thanks again.

To Teylyn,
I am sorry for not being more helpfull with the links in my original post. I will remember to do that in future.
0
 
Chris BottomleyCommented:
FYI, when a question is 'related' you have the option from that closed question to "sk a related question" via the button ... this includes a hyperlink to the original question in your new one and then would perhaps serve to provide the clarification Teylyn suggested.  This is always good because the more relevant info you post the more likely you are to get multiple experts responding and that has to be a good thing for you as the asker.

Chris
0
 
Stephen ByromWarehouse/ShippingAuthor Commented:
Thanks for the tip Chris.
I will remember that in future.
(there will be more questions, there always are)
:)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
>> (there will be more questions, there always are)

:)

What would life be without challenges?

Glad you found your answer from an expert who knows the subject.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.