Jump to content
Sign in to follow this  
brian75

Excel UDF help

Recommended Posts

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 by brian75

Share this post


Link to post
Share on other sites
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.


√-1 2^3 ∑ π, and it was delicious!

How to get your question answered on this forum!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×