Write text to specific Excel cells using CASL
Write text to specific Excel cells using CASL
(OP)
Does anyone know how to specify in excel what cell the 'Write' statement sends strings to?
x = "Some Text"
sFile = "H:\My Documents\ExcelMacro.xls"
Open append sFile as #1
write #1, x
close #1
This will write to cell A1. If the marco is ran again, it will write to A2, and so on.
Does anyone know how to write to cell B1? or C2? or D8?
Thanks
x = "Some Text"
sFile = "H:\My Documents\ExcelMacro.xls"
Open append sFile as #1
write #1, x
close #1
This will write to cell A1. If the marco is ran again, it will write to A2, and so on.
Does anyone know how to write to cell B1? or C2? or D8?
Thanks
Talk To Other Members
RE: Write text to specific Excel cells using CASL
Aside from that I'd say the best way to do what your attempting on a limited basis with casl is to write a delimited flat file in the manner your using above then import it in Excel via VBA or wizard.
Sometimes you gotta leave your zone of safety. You have to manufacture Inspirado. You gotta get out of the apartment. You've got to run with the wolves. You've got to dive into the ocean and fight with the sharks. Or just treat yourself to a delicious hot fudge sundae........ with nuts. - Jack Black