in reply to
Using Win32::OLE and Excel - Tips and Tricks
Hello, Your tutorial was wonderful! I found a lot of great info. I'm a new Perl programmer, and have been playing around with your code to try to fit my needs. Could you give me any advice on how to proceed with the following task? Instead of either opening a file or creating a new one, I'd like to do BOTH. I was thinking of creating a loop where I could basically say something like:
if $excelfile exists, then open $excelfile, otherwise, create a new workbook named $excelfile
However, being new to Perl, I haven't quite been able to find the correct syntax. Can you provide any clues as to how to do this, or is it even possible?
Thanks, and great work!