Macro not working properly when document opened

[cgifford]

I am having a problem with my macro. The macro does some calculations from data listed on the second sheet. When I use it in a new cell (after the doc is opened), it works fine. I saev the doc, close it and re-open it, and I am getting errors. When I do:

oDoc = ThisComponent
oSheet = oDoc,Sheets.GetByName('<name of sheet 2>')

I am getting a runtime error "com.sun.star.container.NoSuchElementException' occuring. When I change this to:

oDoc = ThisComponent
oSheet = oDoc,Sheets.GetByIndex(1)

the error no longer occurs, but the when later in the macro trhying to access the contents of a cell:

oCell = oSheet.getCellByPosition(0,I)

oCell.string seems to be empty, even though the cell in question has a string in it. It is almost as if the macro is running before the doc finishes loading. Any clue as to why this is occuring?

[JohnV]

For your first problem try:
oSheet = oDoc.Sheets.GetByName("name of sheet 2") instead of
oSheet = oDoc,Sheets.GetByName('<name of sheet 2>')

I presume the use of a comma after oDoc was a typo but I doubt '< and >' were.

[cgifford]

The quotes were typos as well, but thanks for the input!

[cgifford]

The macro i created was under "My Macros->Standard". Moving it to the "Name of Doc->Standard" solved the problem!