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 <myxlg...@gmail.com>
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 <gawlianil8...@gmail.com> wrote:
Dear Rupesh,
Pls share the file.
Warm Regards,
Gawli Anil.
On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil <patil.rupesh1...@gmail.com> 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.
--
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.
