deleted variable keeps coming up

[Anonymous]

Hi experts,

I am deleting a variable, save the qvw, and run it from the publisher. As soon as the task runs completely the variable is again created in the qvw. What could be the source? Varibale is not being updated by any spreadsheet. I am wondering where I should look for the source that keeps creating deleted variable.

Thanks!

[Anonymous]

Yes, I am opening from client. This issue is strange! This document was developed by someone else, I am making some changes. I have found work around but still the issue haunts me. There are some macros but i dont think any macro is related to this issue.

I have listed all macros below-

sub OMT

  ActiveDocument.Sheets("OMT").Activate

end sub

sub OMR

  ActiveDocument.Sheets("OMR").Activate

end sub

sub Master

  ActiveDocument.Sheets("Master").Activate

end sub

sub Main

  ActiveDocument.Sheets("Main").Activate

end sub

sub Summary

  ActiveDocument.Sheets("Summary").Activate

end sub

sub TPM

  ActiveDocument.Sheets("TPM").Activate

end sub

[Anonymous]

I see the variables emerging again in source folder.

[Anonymous]

How about if you copy the qvw to another folder, delete the variable and then reload it ?

If no joy then try to delete the variable at the end of the script by setting it to null() :

     LET vYourVariable=null();

[swarup_malli]

You might be referencing an external file which have variables defined in them.

comment out the $Include statement

[Anonymous]

These things are checked.

[swuehl]

What's the name of your variable? And where is this variable used / how do you determine that it is recreated?

[swarup_malli]

My bad I should have read the above replies.Try exporting the script to an external file.Then use that script in a newly created qvw .This might shed some light on what might be happening

[swuehl]

And have you checked that there is no hidden script?

[Anonymous]

Yes

[swuehl]

We can assume this issue is only present when you are using the publisher, so not present when reloading the same QVW in the desktop client? Can you elaborate how the publisher job looks like? Anything special?