Click here to Skip to main content
15,901,284 members
Home / Discussions / C#
   

C#

 
AnswerRe: how to assign listbox value to datagridview in c# Pin
Eddy Vluggen26-Sep-14 5:51
professionalEddy Vluggen26-Sep-14 5:51 
AnswerRe: how to assign listbox value to datagridview in c# Pin
ChintanShukla29-Sep-14 23:22
professionalChintanShukla29-Sep-14 23:22 
QuestionNeither validators nor Validationsummery is working Pin
demoninside926-Sep-14 0:50
demoninside926-Sep-14 0:50 
AnswerMy Vote of 1 Pin
Keith Barrow26-Sep-14 1:57
professionalKeith Barrow26-Sep-14 1:57 
AnswerRe: Neither validators nor Validationsummery is working Pin
Eddy Vluggen26-Sep-14 5:54
professionalEddy Vluggen26-Sep-14 5:54 
GeneralRe: Neither validators nor Validationsummery is working Pin
demoninside926-Sep-14 19:34
demoninside926-Sep-14 19:34 
GeneralRe: Neither validators nor Validationsummery is working Pin
Richard MacCutchan26-Sep-14 21:38
mveRichard MacCutchan26-Sep-14 21:38 
GeneralRe: Neither validators nor Validationsummery is working Pin
Keith Barrow29-Sep-14 22:37
professionalKeith Barrow29-Sep-14 22:37 
QuestionHo to assign a numbering system to the file system hierarchy Pin
Rick450d25-Sep-14 12:41
Rick450d25-Sep-14 12:41 
JokeRe: Ho to assign a numbering system to the file system hierarchy Pin
PIEBALDconsult25-Sep-14 14:02
mvePIEBALDconsult25-Sep-14 14:02 
GeneralRe: Ho to assign a numbering system to the file system hierarchy Pin
SledgeHammer0125-Sep-14 15:06
SledgeHammer0125-Sep-14 15:06 
AnswerRe: Ho to assign a numbering system to the file system hierarchy PinPopular
Freak3025-Sep-14 22:00
Freak3025-Sep-14 22:00 
SuggestionRe: Ho to assign a numbering system to the file system hierarchy Pin
Richard Deeming26-Sep-14 1:14
mveRichard Deeming26-Sep-14 1:14 
GeneralRe: Ho to assign a numbering system to the file system hierarchy Pin
BillWoodruff26-Sep-14 1:22
professionalBillWoodruff26-Sep-14 1:22 
AnswerRe: Ho to assign a numbering system to the file system hierarchy Pin
BillWoodruff26-Sep-14 1:21
professionalBillWoodruff26-Sep-14 1:21 
QuestionHow to extract VBA code from Excel in Visual Studio and read it as text with c#? Pin
Member 1110881725-Sep-14 0:01
Member 1110881725-Sep-14 0:01 
This is what I'm trying to do:

Im opening Excel workbook

using (SpreadsheetDocument myDoc = SpreadsheetDocument.Open(filepath, false))
{
WorkbookPart wbPart = myDoc.WorkbookPart;
//myDoc.WorkbookPart.VbaProjectPart
Sheet mySheet = wbPart.Workbook.Descendants<sheet>().
Where(s => s.Name == sheetName).FirstOrDefault();

if (mySheet == null) //sheet bestaat niet
{
throw new ArgumentException("sheetName");
}

WorksheetPart wsPart = (WorksheetPart)(wbPart.GetPartById(mySheet.Id));
Worksheet worksheet = wsPart.Worksheet;

and then a lot of stuff is going on, I'm making list of all the functions, checking formulas, saving errors, not really important.

What I want to do next is to call a VBA code from this workbook and be able to read is as text and use some string manipulation stuff to find some thing out (like how long are the used functions or find comments, whatever).

Someone an idea how make this possible? I would be really greatfull..
AnswerRe: How to extract VBA code from Excel in Visual Studio and read it as text with c#? Pin
Eddy Vluggen25-Sep-14 2:19
professionalEddy Vluggen25-Sep-14 2:19 
AnswerRe: How to extract VBA code from Excel in Visual Studio and read it as text with c#? Pin
Chris Quinn25-Sep-14 4:41
Chris Quinn25-Sep-14 4:41 
QuestionRecevoir des mails Pin
Member 1110858924-Sep-14 23:51
Member 1110858924-Sep-14 23:51 
SuggestionRe: Recevoir des mails Pin
George Jonsson25-Sep-14 0:07
professionalGeorge Jonsson25-Sep-14 0:07 
GeneralRe: Recevoir des mails Pin
Member 1110858925-Sep-14 0:34
Member 1110858925-Sep-14 0:34 
GeneralRe: Recevoir des mails Pin
Richard MacCutchan25-Sep-14 0:45
mveRichard MacCutchan25-Sep-14 0:45 
AnswerRe: Recevoir des mails Pin
Wayne Gaylard25-Sep-14 0:46
professionalWayne Gaylard25-Sep-14 0:46 
SuggestionRe: Recevoir des mails Pin
Richard Deeming25-Sep-14 2:32
mveRichard Deeming25-Sep-14 2:32 
GeneralRe: Recevoir des mails Pin
Wayne Gaylard25-Sep-14 2:36
professionalWayne Gaylard25-Sep-14 2:36 

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.