473,326 Members | 2,136 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Importing a form created in VBA

I want to rewrite a macro created in Excel VBA using VB.net. I created a
fairly elaborate form in VBA and want to know if there is an easy way of
importing it into VB.net without manually creating all the form controls.

Grateful for any assistance.
Jun 28 '08 #1
1 1768
There "might" be a probably commercial tool out there that can do this ,
however i would certainly not recomend you to do this
as VB.Net is much more sophisticated as its litle brothers VB6 , VBS ,VBA
it is bether to redesign the form,
you can probably do it in a fraction of the time as the VBA version took
you .

I have rewritten lots of VB6 projects from scratch to VB.Net the 2
programs , did the same but in code took 180 degrees different aproaches
for instance a lot of things in VB6 that could only be done with calling
API`s have now standard methods in the framework .

So for future readability and perfomance of your app i would rewrite the
form

HTH

Michel Posseth

"simonc" <si****@discussions.microsoft.comschreef in bericht
news:95**********************************@microsof t.com...
>I want to rewrite a macro created in Excel VBA using VB.net. I created a
fairly elaborate form in VBA and want to know if there is an easy way of
importing it into VB.net without manually creating all the form controls.

Grateful for any assistance.

Jun 28 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Campbell's List | last post by:
Hi, I'm completely new to MySql and need help importing tables from Access or Dbase. I am using Dreamweaver MX to create a data-driven web site. With the VPS hosting plan we're on, our remote...
11
by: Skc | last post by:
I have a .txt which has been exported as a .csv from an external source. What i need to do is to import this into SQL2000 (into a table) but I need to do special things on the data: 1. I need to...
9
by: Edward S | last post by:
I budget for a Project in an Excel sheet as illustrated below. The months below are usually a 2 year period i.e. 24 months, though it could be over 24 months depending upon a Project. I then...
7
by: Darren | last post by:
I have been attempting to create a reservation planning form in excel that imports Data from an Access database and inserts that information automaticly into the correct spreed sheet and the...
0
by: Vagabond Software | last post by:
I want to use an old pdqcom32.ocx control in a Windows Forms project. I have sucessfully imported the control using aximp.exe and now have a few dll files and the C# source code for the wrapper. ...
3
by: mukeshsrivastav | last post by:
dear sir i want to move form excel to access. i have 5 excel file having same formats and fields.now i want to import all data in one access table. importing one file is easy .but importing and...
0
by: Alun Jones | last post by:
I'm getting the above error in a dialog box from Visual Studio 2005 when trying to sign an assembly using a PFX file, and would like to know how to resolve the problem. Background: The PFX...
1
by: gollumullog | last post by:
Good Day, I have been having this issue for quite a long time, and have yet to find an easy/elegant solution. I am trying to create tables in an Access database. I have these tables as CSV...
1
by: JohntheCad | last post by:
I've created a simple training package that return an ATT file which I can convert into a TXT file. This is 8 separate lines of data in the form of: Field: data I have only done a very basic...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.