Transfering data from Reflection to either Word or Excel

[JamesBlack]

First off let me point out that I am very inexperienced in all of this and any help would be appreciated.

I am looking for a VBA macro that would export data from Reflections to either MS Word or Excel. Part of my job entails looking through screen after screen of previously entered data for specific tariff codes and I was thinking it would be so much easier to export the data to word or excel and search the whole document at once as opposed to manually viewing thousands of lines four at a time.

Any help would be fantastic. Please let me know if there is any other information needed to help me out.

 

[Bong]

I'd never heard of Reflection (as a program) but I found this reference that seems to do what you want:

http://www.mrexcel.com/forum/showthread.php?t=63753

_________________
Bob Rashkin

 

[JamesBlack]

Thanks for your reply. The program is Reflections for Unix and Digital by WRQ. (

http://www.attachmate.com/Support/)

The link you sent seems close to what i'm looking for. It looks like it could export the specified data from one screen to Excel. I would need all of the data from the file exported which could amount to several hundered screens.

 

[LamoniDave]

It's been a while since I've worked with Reflection. I remember seeing command scripts that can control emulate keystrokes and logic that can progress through the application, capturing data until it recognizes the end of data.

My experience has been with the pre-VBA script language, but I guess my message is that the tool seems to have the capability you are looking for. I can look for some of the older scripts we're still using if you think they'd help.

 

[macropod]

Hi JamesBlack,

Why not directly query the database that Reflections is giving you access to and work with an electronic report from that?


Cheers
[MS MVP - Word]

 

[JamesBlack]

LamoniDave, That would be great!

macropod, I wouldn't even know where to begin. My experience with VBA is extremely limited. Everything I know is self taught by looking at examples and examining scripts that I recorded myself.

 

[macropod]

Hi JamesBlack,

Presumably, the data presented by Reflections is from a database (eg Informix). A database query (eg using SQL) should be able to retrieve exactly what you're after. The dtabase administrator should be able to organise that.


Cheers
[MS MVP - Word]