Click here to Skip to main content
15,880,200 members
Home / Discussions / C#
   

C#

 
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 Pin
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 
AnswerRe: Recevoir des mails Pin
George Jonsson25-Sep-14 0:43
professionalGeorge Jonsson25-Sep-14 0:43 
QuestionC# System.Timers.Timer Elapsed event issue Pin
Gangawane24-Sep-14 23:45
Gangawane24-Sep-14 23:45 
AnswerRe: C# System.Timers.Timer Elapsed event issue Pin
BillWoodruff25-Sep-14 0:00
professionalBillWoodruff25-Sep-14 0:00 
SuggestionRe: C# System.Timers.Timer Elapsed event issue Pin
George Jonsson25-Sep-14 0:32
professionalGeorge Jonsson25-Sep-14 0:32 
AnswerRe: C# System.Timers.Timer Elapsed event issue Pin
Dave Kreskowiak25-Sep-14 1:46
mveDave Kreskowiak25-Sep-14 1:46 
AnswerRe: C# System.Timers.Timer Elapsed event issue Pin
Ravi Bhavnani25-Sep-14 9:00
professionalRavi Bhavnani25-Sep-14 9:00 
QuestionHow many way dependency injection can be implemented in c# Pin
Tridip Bhattacharjee24-Sep-14 21:30
professionalTridip Bhattacharjee24-Sep-14 21:30 
AnswerRe: How many way dependency injection can be implemented in c# Pin
BillWoodruff24-Sep-14 22:07
professionalBillWoodruff24-Sep-14 22:07 

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.