Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
I need help with a macro
#1
Hello all,

I have seen a marco at my job that is capable of transfering data from program onto excel.
It is ran from Excel and it opens the specific windows of the program we use and extract the data needed in to excel.I also can see that the script when i went to visual basics part of excel.

I would like to know how it is done and learn how to do macros of that kind.
can anyone show me how?
#2
it's hard to say. can you post the relevant sections of the excel macro so we can see what it's doing? that way we can point you in the right direction.
An old blog on QM coding and automation.

The Macro Hook
#3
public sub input tickets()
g_hostsettletim=100
set system=createObject("extra.system")
If(system is nothing)Then
Msgbox"could not create the Extra System object. stopping macro playback."
stop
End if
'Get the necessary session object
Dim sess0 As object
set sesso=system.activesession
if (sesso is nothing) Then
msgbox "could not create the session object. stopping macro playback"
stop
End if
If not sesso. visible Then sess o visible =true
sesso screen.waithostquiet (g hostsettletime)

set IMMSscreen =Sess.0.sreen

This section of code contains the recorded events
with IMMS Screen
.sendkeys ("<clear><clear>")
.sendkeys ("mvtm<enter>")
.waithostquiet (g hostsettletime)
.sendkeys ("1<Enter>")
.waithostqiet (g_hostsettletime)
End with


Forum Jump:


Users browsing this thread: 1 Guest(s)