|
| thanks for your Message, but this was my first trail and the result was not
a correct and beautiful Excel Table.
Oh, well we can't have that can we! :-)
I don´t know i create a correct Excelsheet from my Textfile inside Visual
Basic. And i hope you forgive me my very bad english -))
That's alright, I do. You should post more information detailing what part of the process is not working. For instance, you say you 'don't end up with a correct and beautiful Excel table'. Can you define 'correct and beautiful'? Can you describe how your
actual outputted Excel sheet is falling short of this? Can you post the code you are using? Can you post a (small!) example of the data being converted?
You say you don't get a correct *and beautiful* spreadsheet... BTW, it is easier to have a template with the formatting etc. on, such as borders, column headings, colors, frames, etc. then open this up and put the data into it and resave it, than to progr
amatically do everything from scratch.
Very thanks
Olli
"Bonj" <a@b.com> schrieb im Newsbeitrag
news:egspfnSEEHA.1604@TK2MSFTNGP11.phx.gbl...[color=darkred]
> dim xlapp as object, xlwbk as object
> set xlapp = createobject("excel.application")
> set xlwbk = xlapp.workbooks.open("c:\source.txt")
> xlwbk.saveas "c:\dest.xls"
> xlapp.quit
> news:4060b66d$0$23554$91cee783@newsreade
r01.highway.telekom.at...
|
|