Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Excel > help needed to convert a lotus macro to excell


Reply
 
Thread Tools Display Modes
  #1  
Old 01-22-2004, 01:00 PM
rama4672 rama4672 is offline
Freshman
 
Join Date: Jan 2004
Posts: 37
Default help needed to convert a lotus macro to excell


I have got a work rota done in lotus with macro's, i need to be able to convert it to excell
Reply With Quote
  #2  
Old 01-22-2004, 01:04 PM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

It won't translate automatically. You will have to re-write it

To get started, I would turn on the Macro Recorder using Alt|Tools|Macros|RecordMacros... and then perform the actions necessary.. Turn off the recorder and look at the resultant code (hit Alt-F11 to see your code in 'Module1').

From there you will need to clean the code somewhat (maybe, it often just runs!) and or come here for help with that.

But if you have a ton of Macros to re-write, this will take a lot of work, sorry

-- Mike
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Decimal to Binary Conversion hunron General 8 08-08-2003 05:00 PM
Access create Lotus object, Lotus runs macro?? newinvb Word, PowerPoint, Outlook, and Other Office Products 1 03-06-2003 06:42 AM
Repeating List remmarg Interface and Graphics 2 10-30-2002 05:57 PM
Lotus macro ruined the day lawdie Word, PowerPoint, Outlook, and Other Office Products 8 10-30-2002 05:26 AM
EXCELL VB MACRO tony40 General 3 05-30-2001 09:56 AM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->