[Solved] Sheets - getByReference
Posted: Fri Jun 14, 2019 9:13 am
Hello All,
I am trying to Access Calc Sheets with the following call:
Sheet = Doc.Sheets.getByName("CompanyA")
But, I wan't to Access the sheet with a reference, instead of a hard coded value. Like the following;
Dim CName As String
CName = "CompanyA"
Sheet = Doc.Sheets.getByName(CName)
This does not work. I tried using value(CName) which did not help either. Can I? How?
Nope, I dont want to lock myself to Sheet = Doc.Sheets(n) as it brings complications in the Management of the Doc.
Thanks in advance.
Gürkan
I am trying to Access Calc Sheets with the following call:
Sheet = Doc.Sheets.getByName("CompanyA")
But, I wan't to Access the sheet with a reference, instead of a hard coded value. Like the following;
Dim CName As String
CName = "CompanyA"
Sheet = Doc.Sheets.getByName(CName)
This does not work. I tried using value(CName) which did not help either. Can I? How?
Nope, I dont want to lock myself to Sheet = Doc.Sheets(n) as it brings complications in the Management of the Doc.
Thanks in advance.
Gürkan