Click here to Skip to main content
15,892,768 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionRe: showing persian date in datagridview when programming by vb.net 2005 Pin
majid eskandarian18-Jul-14 20:55
majid eskandarian18-Jul-14 20:55 
AnswerRe: showing persian date in datagridview when programming by vb.net 2005 Pin
ZurdoDev19-Jul-14 2:43
professionalZurdoDev19-Jul-14 2:43 
QuestionRe: showing persian date in datagridview when programming by vb.net 2005 Pin
majid eskandarian20-Jul-14 3:09
majid eskandarian20-Jul-14 3:09 
AnswerRe: showing persian date in datagridview when programming by vb.net 2005 Pin
Richard MacCutchan20-Jul-14 7:07
mveRichard MacCutchan20-Jul-14 7:07 
AnswerRe: showing persian date in datagridview when programming by vb.net 2005 Pin
ZurdoDev20-Jul-14 10:31
professionalZurdoDev20-Jul-14 10:31 
AnswerRe: showing persian date in datagridview when programming by vb.net 2005 Pin
Eddy Vluggen18-Jul-14 5:15
professionalEddy Vluggen18-Jul-14 5:15 
AnswerRe: showing persian date in datagridview when programming by vb.net 2005 Pin
ZinsatPak27-Jul-14 23:46
ZinsatPak27-Jul-14 23:46 
Questionhow to covert multiple XML files to Excel Files using VB Script Pin
prevase17-Jul-14 23:22
prevase17-Jul-14 23:22 
I have a requirement to convert multiple XML files to Excel files using VBScript. I have used the below script to convert the XML files, but on creation of the Excel files I encouter this:

(a)The column names are getting created with the full path like "/Report/Answers/Answer/Answer"

(b)There are additional fields for aggregation like "/Report/Answers/Answer/Answer/#agg"

(c)The column names are displayed in the reverse order i.e. bottom to top level.

The Script is as mentioned below:

Dim xlApp, xlWkb, SourceFolder,TargetFolder,file
Set xlApp = CreateObject("excel.application")
set fs = CreateObject("Scripting.FileSystemObject")
Const xlNormal=1
SourceFolder="c:\temp\XMLfiles"
TargetFolder="c:\temp\XLSfiles"

'Hide Excel
xlApp.Visible = false

'Process each file in SourceFolder
for each file in fs.GetFolder(SourceFolder).files
'Open file in SourceFolder
Set xlWkb = xlApp.Workbooks.Open(file)
'Get Filename
BaseName= fs.getbasename(file)
'Concatenate full path. Extension will be automatically added by Excel
FullTargetPath=TargetFolder & "\" & BaseName
'Save as XLS file into TargetFolder
xlWkb.SaveAs FullTargetPath, xlNormal
'Close file
xlWkb.close
next

Set xlWkb = Nothing
Set xlApp = Nothing
Set fs = Nothing

Kindly let me know your inputs to modify the code to display the column names alone and also to remove the agg columns that are generated.
Questionprint a file via serial port printer without print dialog Pin
Member 1030446816-Jul-14 16:44
Member 1030446816-Jul-14 16:44 
AnswerRe: print a file via serial port printer without print dialog Pin
Richard MacCutchan16-Jul-14 22:48
mveRichard MacCutchan16-Jul-14 22:48 
Questionbuild a windows service in vb to run on server core 2012 with minimum GUI Pin
jkirkerx16-Jul-14 7:41
professionaljkirkerx16-Jul-14 7:41 
AnswerRe: build a service in vb to run on server core 2012 with minimum GUI Pin
Dave Kreskowiak16-Jul-14 7:48
mveDave Kreskowiak16-Jul-14 7:48 
GeneralRe: build a service in vb to run on server core 2012 with minimum GUI Pin
jkirkerx16-Jul-14 7:55
professionaljkirkerx16-Jul-14 7:55 
AnswerRe: build a service in vb to run on server core 2012 with minimum GUI Pin
PIEBALDconsult16-Jul-14 7:53
mvePIEBALDconsult16-Jul-14 7:53 
GeneralRe: build a service in vb to run on server core 2012 with minimum GUI Pin
jkirkerx16-Jul-14 8:06
professionaljkirkerx16-Jul-14 8:06 
GeneralRe: build a service in vb to run on server core 2012 with minimum GUI Pin
PIEBALDconsult16-Jul-14 8:26
mvePIEBALDconsult16-Jul-14 8:26 
AnswerRe: build a service in vb to run on server core 2012 with minimum GUI Pin
Eddy Vluggen16-Jul-14 7:55
professionalEddy Vluggen16-Jul-14 7:55 
GeneralRe: build a service in vb to run on server core 2012 with minimum GUI Pin
jkirkerx16-Jul-14 7:58
professionaljkirkerx16-Jul-14 7:58 
GeneralRe: build a service in vb to run on server core 2012 with minimum GUI Pin
Eddy Vluggen16-Jul-14 8:29
professionalEddy Vluggen16-Jul-14 8:29 
AnswerRe: build a windows service in vb to run on server core 2012 with minimum GUI Pin
Richard Deeming16-Jul-14 8:19
mveRichard Deeming16-Jul-14 8:19 
GeneralRe: build a windows service in vb to run on server core 2012 with minimum GUI Pin
jkirkerx16-Jul-14 8:26
professionaljkirkerx16-Jul-14 8:26 
Questionprint bitmap file via serial port printer Pin
Member 1030446815-Jul-14 4:11
Member 1030446815-Jul-14 4:11 
AnswerRe: print bitmap file via serial port printer Pin
Dave Kreskowiak15-Jul-14 6:34
mveDave Kreskowiak15-Jul-14 6:34 
QuestionNeed help with poker hands codes Pin
Lapin Noir13-Jul-14 23:04
Lapin Noir13-Jul-14 23:04 
AnswerRe: Need help with poker hands codes Pin
Dave Kreskowiak14-Jul-14 2:20
mveDave Kreskowiak14-Jul-14 2:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.