G
Geoff Lambert
This must surely be one of the simplest VB questions??
I am trying to figure out how to extract the name (tab name) of the
active sheet into VB, so I can then concatenate it into a longer string
that specifies a query file.
i.e. on ActiveSheet "FRED", I want to extract the string "FRED" and then
build the string "FRED.IQY"
As it happens, I have an add-in worksheet function Sheetname() that will
produce this name for me. So I can have a cell (e.g. at C2 that already
has the string "FRED" in it
My problem is to extract this from either cell C2 or fron the name of
the ActiveSheet into a string.
There are 150 sheets in my workbook. I want the macros to be run on only
the ActiveSheet
It must be a very simple syntax and code.
But what is it?
Thanks
Geoff Lambert
I am trying to figure out how to extract the name (tab name) of the
active sheet into VB, so I can then concatenate it into a longer string
that specifies a query file.
i.e. on ActiveSheet "FRED", I want to extract the string "FRED" and then
build the string "FRED.IQY"
As it happens, I have an add-in worksheet function Sheetname() that will
produce this name for me. So I can have a cell (e.g. at C2 that already
has the string "FRED" in it
My problem is to extract this from either cell C2 or fron the name of
the ActiveSheet into a string.
There are 150 sheets in my workbook. I want the macros to be run on only
the ActiveSheet
It must be a very simple syntax and code.
But what is it?
Thanks
Geoff Lambert