Re: $$Excel-Macros$$ Port VBA code to VB.net
Your question really leaves out too much to provide an answer... By Definition, VBA is Visual Basic for Applications.It's Visual Basic, plus specific objects/methods/procedures specific to the Application.VBA for Excel has things to access things like Workbooks, Worksheets, and Cells.But it DOESN'T have tools for accessing the Header and Body of a MicroSoft Word document. VBA for Word has the procedures for processing the document Body, but doesn't have anything for accessing Excel worksheets and cells. So, the "A" in VBA has specific things for the specific Application. VB.Net does NOT have these Application specific procedures. Now, it's POSSIBLE to write VBA code that doesn't use any Application-specific code.Perhaps things like userforms and reading/writing to the file system.Maybe even reading/writing to an SQL database.But the userforms in VB.Net are not the same as userforms in Word or Excel. It's kind-of like writing an instruction manual for driving a car and wanting to copy it and modify it to create instructions for riding a bicycle. Some things you can do with a car simply don't have a correlation to the bicycle.--Now, if your question is really how to make this AUTOMATED, that's different.For example: I have a VBscript that is scheduled to run at midnight.It checks to see if some data files have been downloaded.If not, then it waits for 10 minutes and tries again.If they are not updated by 2:00am, then it writes to an error log and exits.If they're available, it launces an Excel file that has a Workbook_Open event macro.The Excel VBA then reads and process the downloaded files (140,000 rows of data).Once it combines the files to create a new report, it writes the report to an Oracle database and exits. So, in this case the VBScript is the "executable" file that launches the Excel/VBA. So, without knowing what your VBA macros do, it is difficult to know how to answer your question. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: My Excel To: excel-macros@googlegroups.com Sent: Tuesday, April 14, 2015 10:53 AM Subject: Re: $$Excel-Macros$$ Port VBA code to VB.net sir,Pls share update of this threadhow to convert vba to .exe thanks in advance On Thu, Oct 9, 2014 at 3:27 PM, Anil Gawli wrote: Dear Rupesh, Pls share the file. Warm Regards, Gawli Anil. On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil wrote: > Hello Expert, > > In my organization we have developed VBA Application for doctors. now we > want to create .exe file of this application > so as per my knowledge we can't create .exe file of VBA application. so we > need to port this code to .net. Could please assist me how to do this. > > > -- > Thanks & Regards, > Rupesh Patil, > (9970196189), > Ayushman Pvt. Ltd. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don&
Re: $$Excel-Macros$$ Port VBA code to VB.net
sir, Pls share update of this thread how to convert vba to .exe thanks in advance On Thu, Oct 9, 2014 at 3:27 PM, Anil Gawli wrote: > Dear Rupesh, > > Pls share the file. > > Warm Regards, > Gawli Anil. > > On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil > wrote: > > Hello Expert, > > > > In my organization we have developed VBA Application for doctors. now we > > want to create .exe file of this application > > so as per my knowledge we can't create .exe file of VBA application. so > we > > need to port this code to .net. Could please assist me how to do this. > > > > > > -- > > Thanks & Regards, > > Rupesh Patil, > > (9970196189), > > Ayushman Pvt. Ltd. > > > > -- > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > > https://www.facebook.com/discussexcel > > > > FORUM RULES > > > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will > > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material and their links is not allowed. > > > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > > members are not responsible for any loss. > > --- > > You received this message because you are subscribed to the Google Groups > > "MS EXCEL AND VBA MACROS" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to excel-macros+unsubscr...@googlegroups.com. > > To post to this group, send email to excel-macros@googlegroups.com. > > Visit this group at http://groups.google.com/group/excel-macros. > > For more options, visit https://groups.google.com/d/optout. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Port VBA code to VB.net
Dear Rupesh, Pls share the file. Warm Regards, Gawli Anil. On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil wrote: > Hello Expert, > > In my organization we have developed VBA Application for doctors. now we > want to create .exe file of this application > so as per my knowledge we can't create .exe file of VBA application. so we > need to port this code to .net. Could please assist me how to do this. > > > -- > Thanks & Regards, > Rupesh Patil, > (9970196189), > Ayushman Pvt. Ltd. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Port VBA code to VB.net
Hello Expert, In my organization we have developed VBA Application for doctors. now we want to create .exe file of this application so as per my knowledge we can't create .exe file of VBA application. so we need to port this code to .net. Could please assist me how to do this. -- Thanks & Regards, Rupesh Patil, (9970196189), Ayushman Pvt. Ltd. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
