ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

3 Q & A posts found in March

Tue
Mar 31
2009

I want typing in hindi on ms word and Excel?


Answer

To use any language other than English in Windows
You will need to install it first

Go to
Control Panel > Regional and Language options
And make sure you see your language in that list
and also make sure that you have the checkbox checked for middle east and far east countries

or something like that

VBAXLMan

Tuesday 3/31/2009 7:10:14 PM
Tue
Mar 31
2009

How do you turn macros on in microsoft excel 2007?


Answer

First, you will need to save your file as Excel macro-enabled worksheet with XLSM as extension rather the default XLSX.

If you are doing ans XLS 2003 file type, ignore that

Then once you open the macro file, Excel will show you a new bar above the Formula bar with "Security warning"
like this screen
http://www.file1.net/img.asp?prj=-8-_-2_…

Click on "Options" and enable the macro content

OR
Show the "Developer" tab, here is a lesson on how to show it
http://www.file1.net/lesson.asp?id=6VM8P…

Then in the Developer tab, click on "Macro Security" in the "Code" section


VBAXLMan

Tuesday 3/31/2009 6:18:07 PM
Tue
Mar 31
2009

How can I create a Macro with Excel 2000 and Visual Basic.NET?

When I start Excel 2000 and click tools > marcro > visual basic editor, it starts Visual Basic 6. I also have Visual Basic.NET and would like to program Macros in a more up to date version of VB. Is there a way to do this?


Answer

No, Cozmosis you are wrong

Sorry Nathan
All Excel versions after Excel97, (Including Excel2007) are having VBA version that is based on VB6
Excel97 has the VB5 version of VBA

You can not program VBA code in Excel using other than the built-in VBA

Which is for now all in VB6

You would may be wait until they might put .NET in the coming version of Office

VBAXLMan

Tuesday 3/31/2009 3:42:01 PM

Tags

History