Tell it to write X and it puts a 0

Shadow3641 · Post by **Shadow3641** » Thu Mar 30, 2017 1:19 pm

I have a backup program running and I use a excel sheet to track the progress of it in case it gets interrupted I can just restart and it will pick up where it left off. I'm using this bit of code to write to a cell in the spreadsheet the problem is that i'm telling it to write a X and its putting a 0 instead any ideas? at the end of the program it resets all the cells with a Y to set it up for the next time this part works fine.

Code: Select all

  XLOpen>%USERDOCUMENTS_DIR%\BackupArray.xls,0,xlBook
  XLSetCell>xlBook,Sheet1,%Loop%,6,X,res
  XLSave>xlBook,%USERDOCUMENTS_DIR%\BackupArray.xls
  XLQuit>xlBook

Thanks for any help

hagchr · Post by **hagchr** » Thu Mar 30, 2017 2:20 pm

Maybe you are using x as a variable somewhere in the code and it has a value of 0 when you write to the file.

Shadow3641 · Post by **Shadow3641** » Thu Mar 30, 2017 2:30 pm

I searched all through my code and i'm not writing to a var X. I think i'm just going to write a 1 or 0 in that block instead of a X and Y and give it a shot

mightycpa · Post by **mightycpa** » Thu Mar 30, 2017 2:55 pm

Maybe you've unwittingly written a TIC-TAC-TOE bot.

Have you tried putting an apostrophe in front of that X?

I noticed one in the documentation example, and of course, that's excel's clue that you're using text.

XLSetCell>xlBook,Sheet1,2,2,'205,res

Shadow3641 · Post by **Shadow3641** » Thu Mar 30, 2017 6:46 pm

Yep for some reason that worked Don't know why it did that It was working perfectly fine then i added one section to it and it started to flip out. Thanks for the help

Tell it to write X and it puts a 0

Tell it to write X and it puts a 0

Re: Tell it to write X and it puts a 0

Re: Tell it to write X and it puts a 0

Re: Tell it to write X and it puts a 0

Re: Tell it to write X and it puts a 0