Click here to Skip to main content
15,914,500 members
Home / Discussions / C#
   

C#

 
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 
AnswerRe: How many way dependency injection can be implemented in c# Pin
Sibeesh KV26-Sep-14 0:14
professionalSibeesh KV26-Sep-14 0:14 
AnswerRe: How many way dependency injection can be implemented in c# Pin
Sibeesh KV26-Sep-14 0:28
professionalSibeesh KV26-Sep-14 0:28 
QuestionI wan to make USB Bolcker using vb.net or C# Pin
Deb00724-Sep-14 20:36
Deb00724-Sep-14 20:36 
QuestionRe: I wan to make USB Bolcker using vb.net or C# Pin
George Jonsson25-Sep-14 0:04
professionalGeorge Jonsson25-Sep-14 0:04 

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.