将_VBA_转换为VB.net？ [英] convert _VBA_ to VB.net?

问题描述

有没有人知道将VBA从Excel导入VB的任何有用方法

2005？


我发誓;世界上2/3的Vb6代码从未触及Visual

Basic 6.0;我想重新使用我现有的一些代码而不需要付出很多努力。


我以为转换器可以帮助我做到这一点;但是它不会从电子表格中导入VBA


谢谢


Susie

解决方案

是啊..我确定有一个生活在电子表格中的_LOT_ VB6代码和

VBS文件;如果VB转换器可以使用

这些文件，那肯定会很好。


当然，跳上全速列车是不可能的


我认为我们都应该投票支持Ralph Nader为微软的总裁。我认为他是唯一可以节省这个价值的人。


-Aaron

2月9日晚上7点14分，susie ... @ hotmail.com < susie ... @ hotmail.com>

写道：

有没有人知道将VBA从Excel导入VB的任何有用方法

2005？

嗯...说实话我从来都不是一个vba人，但是从没有

一个人已经给了你任何有用的答案 - 我会刺伤....


2005年，你有能力一次转换代码片段...如果您在菜单中查看

，您应该看到一个选项，上面写着升级

Visual Basic 6 Code。然后，您可以复制并粘贴或键入代码

以查看翻译的内容。我想，你可以将你的

vba函数复制到那个框中，看看会发生什么:)我怀疑你因为VBA和VB6之间的差异而导致
会有一些问题，但是无论如何，
可能会让你在那里。


-

Tom Shelton

Tom，


OP是Aaron Kempf的阻力。今天寻找其他帖子
su******@hotmail.com


布鲁斯


" Tom Shelton" < to ********* @ comcast.netwrote in message

news：11 ********************* *@m58g2000cwm.googlegr oups.com ...

2月9日晚上7:14，susie ... @ hotmail.com < susie ... @ hotmail.com>

写道：

>有没有人知道从Excel导入VBA的任何有用方法进入VB
2005年？

嗯...说实话我从来都不是一个vba人，但是因为没有

一个人给了你任何有用的答案 - 我会采取刺....


2005年，你有能力一次转换代码片段。如果您在菜单中查看

，您应该看到一个选项，上面写着升级

Visual Basic 6 Code。然后，您可以复制并粘贴或键入代码

以查看翻译的内容。我想，你可以将你的

vba函数复制到那个框中，看看会发生什么:)我怀疑你因为VBA和VB6之间的差异而导致
会有一些问题，但是无论如何，
可能会让你在那里。


-

Tom Shelton

does anyone know any helpful ways to import VBA from Excel into VB
2005?

I just swear; 2/3rds of the Vb6 code in the world never touched Visual
Basic 6.0; and I want to re-use some of my existing code without a
bunch of effort.

I was thinking that the convertor could help me to do this; but It
won''t import the VBA from a spreadsheet

thanks

Susie

解决方案

yeah.. I''ve sure got a _LOT_ of VB6 code living in spreadsheets and
VBS files; it sure would be nice if the VB convertor would work with
those files.

Of course, it''s impossible to jump on a full speed train

I think that we should all vote for Ralph Nader for president of
Microsoft; I think that he is the only person that can save this
company

-Aaron

On Feb 9, 7:14 pm, "[e-mail]" <[e-mail]>
wrote:

does anyone know any helpful ways to import VBA from Excel into VB
2005?

Well... To be honest I''ve never been much a vba person, but since no
one has given you any helpful answers yet - I''ll take a stab....

In 2005 you have the ability to convert code snipits at a time... If
you look in the menu, you should see an options that says Upgrade
Visual Basic 6 Code. You can then copy and paste or type code into it
to see what the translation would be. I suppose, you could copy your
vba functions into that box and see what happens :) I suspect you
will have some issues due to differences between VBA and VB6, but it
might get you partway there anyway.

--
Tom Shelton

Tom,

The OP is Aaron Kempf in drag. Look for other posts today by
su******@hotmail.com

Bruce

"Tom Shelton" <to*********@comcast.netwrote in message
news:11**********************@m58g2000cwm.googlegr oups.com...

On Feb 9, 7:14 pm, "[e-mail]" <[e-mail]>
wrote:

>does anyone know any helpful ways to import VBA from Excel into VB
2005?

Well... To be honest I''ve never been much a vba person, but since no
one has given you any helpful answers yet - I''ll take a stab....

In 2005 you have the ability to convert code snipits at a time... If
you look in the menu, you should see an options that says Upgrade
Visual Basic 6 Code. You can then copy and paste or type code into it
to see what the translation would be. I suppose, you could copy your
vba functions into that box and see what happens :) I suspect you
will have some issues due to differences between VBA and VB6, but it
might get you partway there anyway.

--
Tom Shelton

这篇关于将_VBA_转换为VB.net？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！