Excel UDF help

[brian75]

Greetings All,

I'm a noob and I'm trying to figure out how to record the serial # of each machine that runs a certain script.  So far (modifying a co-worker's script) I've been able to get the serial # and write it to a variable called $SerialNum.  My question is would I use _ExcelWriteCell to write the value of $SerialNum to cell A1 in the spreadsheet?  If so how do I tell it the value in _ExcelWriteCell = the value of $SerialNum?  I was just thinking I would open the spreadsheet, insert a new row, write my value to A1, then save and close it.  Thanks much for any assistance!

Edited September 18, 2013 by brian75

[JLogan3o13]

It seems you are on the right track. Look at _ExcelBookOpen(), _ExcelWriteCell() and _ExcelBookClose() in the Help file. Once you have tried a few things out, feel free to post here if you run into issues; we'd be happy to help.