|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Problems with saving a .xls-workbook created by using wscript.shell
Hey. I'm trying to save csv-file like .xls, when I have used wscript.shell to format it into a excel-sheet. But I am having problems. The code generates an excel-sheet, but I can't do any formatting or saving (from the script itself I mean. I can format it using excel). I'm trying to make a script that automizes the formatting (like autofit etc.). My plan is to first save the file as an -xls file, then do the formatting with another script. Here is the code I got so far (this does not attempt to do any autofitting or saving).
---------------------------------------------- sValue = shell.RegRead("HKCR\Applications\EXCEL.EXE\shell\edit\command\") strFn = Args.item(0) sCmd = sValue & " " & strFn shell.Run sCmd ------------------------------------------ Any idea of how I can save this, or do some more formatting without saving it? |
|
#2
|
||||
|
||||
|
you have the Excel.Application component, which as far as I know provide the interface for working with Excel sheets for any programming language, including VB.
|
|
#3
|
||||
|
||||
|
Quote:
__________________
Come JOIN the party!!! Quote of the Month: Retirement: Because you've given so much of yourself to the company that you don't have anything left we can use. Questions to Ponder: What do you do when you see an endangered animal eating an endangered plant? iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm") copyright© 2008 sbenj69 |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Problems with saving a .xls-workbook created by using wscript.shell |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|