ExcelBanter - opening and writing into notepad

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - opening and writing into notepad (https://www.excelbanter.com/excel-programming/274505-opening-writing-into-notepad.html)

opening and writing into notepad

hey all,

first time i'm ever trying to do something like this, and
i'm stuck. i know how to open up notepad through vba, but
not much else.

what i've got so far is this:

******
Private Sub CommandButton1_Click()

FormatInfo 'function to format cells in spreadsheet
ReturnValue = Shell("notepad.exe", 1)
CreateHTML 'write text into notepad

End Sub
******

basically, i want to create a html file after information
is pasted into a spreadsheet.

my questions are these:
1). how do i actually write into notepad, given if i have
a set html code, and only a few things will change?
2). those parts that will change for each new html file
are cell values in the spreadsheet. so this macro
basically makes html files much easier than copying and
pasting info over and over again for each new group of
info.

and then, ultimately, i want to save and close notepad,
and save it like "blah.html", if "blah" was in cell A3.

so, again, a bunch of the code is exactly the same. just
little parts change, which is why i wanted this macro to
work.

tia.

opening and writing into notepad

Peter..
why use notepad? why not write it to
to a file directly (line by line) print#

search google for examples you'll find tons!
http://www.barasch.com/excel/custhtml.htm

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool

"peter" wrote:

i'm sorry for replying to my own post.

i figured out it was "sendkeys"

only problem i have now is trying to paste a lot of code
in between quotation marks.

if anyone knows how i can do things like

sendkeys "<html
<body
<title
....etc.etc.etc
</html"

please let me know. thanks.