Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting VBA app to VB.net project
1) you can just "drag" modules from the Excel IDE to a
folder or desktop. similarly, you can drag these same modules into a VB6 IDE. The issue in VB is that to run and Excel specific code, you need to set a reference in the VB project to the Excel Library. 2) How can your users run an Excel application without having Excel installed? To run ANY program it has to be installed on the client workstation or PC. Maybe you need to re-phrase the question? Patrick Molloy Microsoft Excel MVP -----Original Message----- I've got a couple of standalone Excel applications that I want to make avaialbale to people who don't have Excel on their systems. I would hate to re-write these by hand. Does anyone know of a method or tool that will allow me to import/convert from VBA to VB without re-writing all my code? In the absence of a tool that will do it all (or most) of the work, I,d be OK with a list of hints, tips and suggested methodology from people who have had to do this before. Thanks, Mike Burke . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting VBA app to VB.net project
You are so right: I need to re-phrase the objective. I'm trying to reproduce the funtionality of my Excel applications in Visual Basic so the end user doesn't have to have Excel installed. I presume this will mean using grids and generic objects instead of workbooks/worksheets and mso objects. In my fantasy, there is a tool that will allow me to map Excel-specific references to VB.net (or even VB6) equivalencies, and preserve most of the code. If there is not a tool, perhaps there is a document that cross-references VBA to VB.net. (If there isn't one, there should be...I may have to make one someday.) Some of the applications include a lot of graphics for simulation. It was pretty easy to put them on a grid in Excel, but I presume I can get better and faster results in a standalone VN.net application. I just dread spending 6 months doing the re-writes. Thanks for your help. Mike Burke *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting VBA app to VB.net project
"Michael Burke" wrote in message ... You are so right: I need to re-phrase the objective. I'm trying to reproduce the funtionality of my Excel applications in Visual Basic so the end user doesn't have to have Excel installed. I presume this will mean using grids and generic objects instead of workbooks/worksheets and mso objects. In my fantasy, there is a tool that will allow me to map Excel-specific references to VB.net (or even VB6) equivalencies, and preserve most of the code. No but you could write your own functions to do this and then replace the excel calls with those functions If there is not a tool, perhaps there is a document that cross-references VBA to VB.net. (If there isn't one, there should be...I may have to make one someday.) The grid tools supplied in .net are not really up to this I'd suggest looking the the VSFlexGrid from Component One https://home.componentone.com/produc...1&ProductID=68 Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
project | Excel Worksheet Functions | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
I pay $ for this project | Charts and Charting in Excel |