ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I import/translate a Visual Basic project to Excel? (https://www.excelbanter.com/excel-programming/357978-can-i-import-translate-visual-basic-project-excel.html)

stamko

Can I import/translate a Visual Basic project to Excel?
 
I am using program wirtten in Visual Basic. I know that Excel can a cut down
version of VB installed. Is there an easy way to import or translate the
project in Excel? It is a relatively big program which will take me ages to
rewrite in Excel. Thanks for your help


MSweetG222

Can I import/translate a Visual Basic project to Excel?
 
I found this site very helpful.
http://www.cpearson.com/excel/vbe.htm

If you have a chance, review his topics page for other helpful info.
http://www.cpearson.com/excel/topic.htm


--
Thx
MSweetG222



"stamko" wrote:

I am using program wirtten in Visual Basic. I know that Excel can a cut down
version of VB installed. Is there an easy way to import or translate the
project in Excel? It is a relatively big program which will take me ages to
rewrite in Excel. Thanks for your help


MSweetG222

Can I import/translate a Visual Basic project to Excel?
 
Oops. Sorry, I didn't notice you said VB.
--
Thx
MSweetG222



"MSweetG222" wrote:

I found this site very helpful.
http://www.cpearson.com/excel/vbe.htm

If you have a chance, review his topics page for other helpful info.
http://www.cpearson.com/excel/topic.htm


--
Thx
MSweetG222



"stamko" wrote:

I am using program wirtten in Visual Basic. I know that Excel can a cut down
version of VB installed. Is there an easy way to import or translate the
project in Excel? It is a relatively big program which will take me ages to
rewrite in Excel. Thanks for your help


John.Greenan

Can I import/translate a Visual Basic project to Excel?
 
There's no "simple" automated way to do this that I am aware of - I did look
for something like this about 18 months ago, perhaps things have changed
since then. Many vb commands are available in excel vba, but this is
normally a cut and paste / correct / test / iterate job. You can save
regular and class modules from VB and load into VBA and with some tweaking
forms will work, but I've only ever done this as a manual process.

--
www.alignment-systems.com


"MSweetG222" wrote:

Oops. Sorry, I didn't notice you said VB.
--
Thx
MSweetG222



"MSweetG222" wrote:

I found this site very helpful.
http://www.cpearson.com/excel/vbe.htm

If you have a chance, review his topics page for other helpful info.
http://www.cpearson.com/excel/topic.htm


--
Thx
MSweetG222



"stamko" wrote:

I am using program wirtten in Visual Basic. I know that Excel can a cut down
version of VB installed. Is there an easy way to import or translate the
project in Excel? It is a relatively big program which will take me ages to
rewrite in Excel. Thanks for your help



All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com