Spike48
Technical User
- Nov 18, 2013
- 8
Hey guys, I've been lurking around these forums for a while and steadily increasing my knowledge thanks to it, but now I need some direct help. I'm fairly new to vba and coding in general, so I have some trouble understanding pieces of code I find here and on other forums that I then try to adapt for my own needs.
The problem:
I'm currently running an Excel 2010 macro that imports a bunch of stuff from the currently open Attachmate session, does things with it and the end result then gets pasted somewhere else. It works just fine, I decided to do the macro in excel because I find excel vba much easier to work with than extra basic, which I don't really know at all. However, I *need* to spare the average Joe of an user the trouble of opening excel and starting a macro from there every single time; it would simply be much more convenient if the macro could be started from Attachmate. I'm sure it's doable, however, I have no idea how to do achieve this.
I found an older thread where someone had a similiar problem and apparently fixed it ( ). I do not know how to adapt the solution for my own needs, however. Please mote that my macro does not start automatically when I open the excel file and I don't want it to (unless there's no other way to do it, other than closing it and reopening it via macro every time).
Let's assume the file with the macro is called 1.xlsm and is stored on C:\excel\macro. The macro is in "module1" and is called "macro1". If someone could help me adapt the solution / create a new one, it'd be fantastic. How should the extra basic code look like? Thanks!
The problem:
I'm currently running an Excel 2010 macro that imports a bunch of stuff from the currently open Attachmate session, does things with it and the end result then gets pasted somewhere else. It works just fine, I decided to do the macro in excel because I find excel vba much easier to work with than extra basic, which I don't really know at all. However, I *need* to spare the average Joe of an user the trouble of opening excel and starting a macro from there every single time; it would simply be much more convenient if the macro could be started from Attachmate. I'm sure it's doable, however, I have no idea how to do achieve this.
I found an older thread where someone had a similiar problem and apparently fixed it ( ). I do not know how to adapt the solution for my own needs, however. Please mote that my macro does not start automatically when I open the excel file and I don't want it to (unless there's no other way to do it, other than closing it and reopening it via macro every time).
Let's assume the file with the macro is called 1.xlsm and is stored on C:\excel\macro. The macro is in "module1" and is called "macro1". If someone could help me adapt the solution / create a new one, it'd be fantastic. How should the extra basic code look like? Thanks!