Data from same workbook issue

[Biznez]

Hi, how can i make this so it doesnt open another excel sheet but uses the one thats already open. For example, this macro is in workbook book1 and i want it to use the data in cell b3 from this same workbook to input data into Attachmate.

Thanks

        Dim xlApp As Object, xlSheet As Object, MyRange As Object
        Set xlApp = CreateObject("excel.application")
        xlApp.Application.DisplayAlerts = False 'Turn off Warning Messages'
        xlApp.Visible = True
        xlApp.Workbooks.Open Filename:="c:\test.xlsx"
        Set xlSheet = xlApp.ActiveSheet
        Set MyRange = xlApp.ActiveSheet.Range("B3:B14")

 

[SkipVought]

GetObject()

 

[Biznez]

Thanks SkipVought, so basically i remove createobject and use getobject()
why does it still open new excel sheet though? i just want to use the current one that already opened

 

[SkipVought]

Sorry I did not read your post fully.

If you are coding in excel VBA, you do not need to create or get an Excel Aplication Object. It's in the application you're using! You would only need to create an Excel Application Object if you were coding in some OTHER application, like Attachmate!Extra, or MS Access.

So you have a macro in Book1? You really ought to SAVE this workbook before doing any more coding.

Will this workbook act as a master for opening other workbooks and scraping data from a terminal emulator, or just opening test.xlsx?

 

[SkipVought]

So far you've started three threads in two Attachmate forums.

The first one you entered regarded screen navigation, which is a basic requirement before proceeding to other questions. Has this logic been addressed?

 

[Biznez]

this is the master workbook and im not opening any other files

 

[SkipVought]

So tell me what this macro in the master will do.

 

[Biznez]

i have master excel sheet with customers account # in cell A1. When i click on a button it will go into mainframe with that account # and extra data and input it into the same excel sheet

 

[SkipVought]

So why do you open text.xlsx?

 

[Biznez]

i removed that and it still doesnt work

 

[SkipVought]

WHAT still does not work? My crystal ball is "not working!

 

[remy988]

When i click on a button it will go into mainframe

do you know if this button calls a script written in Excel VBA or does it call an Extra Macro to run?

if your script is in Excel VBA, there would be no need for the above code that you posted on 14 Apr 15 20:35

 

[Biznez]

hi remy988, script is in Excel VBA. can you please explain

 

[remy988]

Biznez, please answer Skip's question

WHAT still does not work?