Click here to Skip to main content
15,891,529 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Registering an exe as a service. Pin
draghu26-May-09 23:36
draghu26-May-09 23:36 
GeneralRe: Registering an exe as a service. Pin
Dave Kreskowiak27-May-09 1:33
mveDave Kreskowiak27-May-09 1:33 
GeneralRe: Registering an exe as a service. Pin
draghu27-May-09 2:43
draghu27-May-09 2:43 
GeneralRe: Registering an exe as a service. Pin
Dave Kreskowiak27-May-09 11:58
mveDave Kreskowiak27-May-09 11:58 
QuestionServer Connectivity if no server exist Pin
pdnet18-May-09 3:57
pdnet18-May-09 3:57 
AnswerRe: Server Connectivity if no server exist Pin
Dave Kreskowiak18-May-09 8:54
mveDave Kreskowiak18-May-09 8:54 
AnswerRe: Server Connectivity if no server exist Pin
Samir Ibrahim19-May-09 4:35
Samir Ibrahim19-May-09 4:35 
QuestionExcel column formatting issue, format style changed when formatted again with the same style Pin
BREdwards18-May-09 3:36
BREdwards18-May-09 3:36 
Hello, I am in the process of trying to fix this bug that has cropped up in some code I am maintaining. The issue is this: The application runs through some data from an excel spreadsheet and when it is finished, it formats and saves the spreadsheet before closing it out. This works, but heres the thing, when a spreadsheet is run through the app the first time, the columns are formatted correctly as Currency, but when the same spreadsheet is run again, the columns formatted as Currency are now formatted as Accounting for some reason even though the lines of code doing the formatting clearly state Currency like this:

objExcelSheet.Columns(eSheetLocations.AMT).Style = "Currency"

This is proving to be one heck of a noodle scratcher, as I have no clue why it is doing this. I had originally considered a workaround by trying to get the current style by having a variable set to it, but the variable returns Nothing when I step through. The reason I need this to stay Currency is because zero-dollar amounts need to be seen as "$0.00" and not "-" as this confuses the end users. Any help and advice is welcome, thanks in advance.
AnswerRe: Excel column formatting issue, format style changed when formatted again with the same style Pin
Johan Hakkesteegt19-May-09 3:06
Johan Hakkesteegt19-May-09 3:06 
QuestionCompare 2 Excel Sheets Pin
vijay248218-May-09 3:25
vijay248218-May-09 3:25 
AnswerRe: Compare 2 Excel Sheets Pin
dan!sh 18-May-09 4:08
professional dan!sh 18-May-09 4:08 
QuestionHow to merge columns Pin
Pankaj Garg18-May-09 0:20
Pankaj Garg18-May-09 0:20 
AnswerRe: How to merge columns Pin
Dave Kreskowiak18-May-09 1:52
mveDave Kreskowiak18-May-09 1:52 
QuestionBackgroundWorkers 'RunWorkerCompleted' not fired Pin
Sonhospa17-May-09 23:38
Sonhospa17-May-09 23:38 
AnswerRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Dave Kreskowiak18-May-09 4:06
mveDave Kreskowiak18-May-09 4:06 
QuestionRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Sonhospa18-May-09 9:11
Sonhospa18-May-09 9:11 
AnswerRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Dave Kreskowiak18-May-09 10:01
mveDave Kreskowiak18-May-09 10:01 
NewsRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Sonhospa18-May-09 10:12
Sonhospa18-May-09 10:12 
GeneralRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Dave Kreskowiak18-May-09 13:13
mveDave Kreskowiak18-May-09 13:13 
GeneralRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Sonhospa18-May-09 20:14
Sonhospa18-May-09 20:14 
GeneralRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Dave Kreskowiak19-May-09 17:14
mveDave Kreskowiak19-May-09 17:14 
NewsRe: BackgroundWorkers 'RunWorkerCompleted' not fired - Resolved Pin
Sonhospa18-May-09 10:53
Sonhospa18-May-09 10:53 
QuestionConvert Text file into Excel file Pin
vijay248217-May-09 23:14
vijay248217-May-09 23:14 
AnswerRe: Convert Text file into Excel file Pin
Rajesh Anuhya17-May-09 23:29
professionalRajesh Anuhya17-May-09 23:29 
GeneralRe: Convert Text file into Excel file Pin
vijay248218-May-09 0:09
vijay248218-May-09 0:09 

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.