creating html pages from excel

[allthenames]

Hi, I just need a simple script that can create a filename and path based on a directory. For example

CreateDir>C:\Users\Ben's Asus\Documents\%cell%\%cell%.txt

with "cell" being the variable to save to.

Here is my full script for reference.




Let>k=1
Label>start
let>ret=test
setfocus>Excel*
dderequest>Excel,C:\Program Files\screen-scraper basic edition\water.xlsx,R%k%C1,cell,10
StringReplace>cell,SPACE,,cell
MessageModal>%cell%
WriteLn>C:\Users\Ben's Asus\Documents\%cell%.html,result,%cell%%TITLE%
If>k>3,finish
Let>k=k+1
Goto>start
Label>finish


It is reading the column cells one by one creating simple html pages for each line.

any help is appreciated. Thanks

[Marcus Tettmar]

Just going back through posts that didn't get an answer. Are you still looking for an answer on this? Looks to me like you've answered it yourself. You can use CreateDir as you have. To create a file, depends what kind of file it is. Just use WriteLn to create a text file.