[N62790]

Is it possible to read the active file handle in an excel macro and write data directly to that open file?

[Ionut]

Yes, that are macros for.

[N62790]

Ionut, on 30 January 2011 - 04:55 AM, said:

Yes, that are macros for.

Hi IOnut, sorry maybe I have to express myself a little better:
An excel file i.e. 'a.xls' is open and from this excel file the macro editor is opened. Now I try to find out how I can access the excel file itself, that means I would like to identify the file handle and then use this handle to read or write data to the binary code of this excel file (not to the excel table).

[thava]

what do you mean? write the file in binary's then how excel open that file?
i think may be i am wrong? make it clear do you want overwrite the cell value(like a mask)

[Ionut]

If I undestand correct, you want an "old style" manipulation of an xls file, like a binary open in C/C++. This I think can be achived only with WinApi functions. VBA had the purpose to make easier excel files manipulation in a "high level" way: working directly with cell, worksheets, ranges through objects.

Quote

An excel file i.e. 'a.xls' is open and from this excel file the macro editor is opened. Now I try to find out how I can access the excel file itself,

If an excel file is open, you cannot write data the way you want. It should get the path, close it and then open the file through winapi.

[N62790]

Ionut, on 01 February 2011 - 03:29 AM, said:

If I undestand correct, you want an "old style" manipulation of an xls file, like a binary open in C/C++. This I think can be achived only with WinApi functions. VBA had the purpose to make easier excel files manipulation in a "high level" way: working directly with cell, worksheets, ranges through objects.

Quote

An excel file i.e. 'a.xls' is open and from this excel file the macro editor is opened. Now I try to find out how I can access the excel file itself,

If an excel file is open, you cannot write data the way you want. It should get the path, close it and then open the file through winapi.

Hi IOnut, you are right with your description. I definitely have to change my approach. Thank you very much for your help and time spend.

thava, on 31 January 2011 - 08:50 AM, said:

what do you mean? write the file in binary's then how excel open that file?
i think may be i am wrong? make it clear do you want overwrite the cell value(like a mask)

Hi Thava, you are right I did want to write binary to the file and not just change a field or cell. I will look for an other solution. In any case thank you for your contribution. take care.

[BobRodes]

Ionut is quite right. Read up on the EnumWindows API function: http://msdn.microsof...(v=vs.85).aspx.

Here's the VB translation of the function specification (use the "Windows API Viewer" in VS 6.0 Tools menu folder to find these):

Public Declare Function EnumWindows Lib "user32" (ByVal lpEnumFunc As Long, ByVal lParam As Long) As Long

The way this works is you create a Sub, pass the name of the sub to lpEnumFunc using the AddressOf operator, and this function will go through all the top level windows on the screen and call your sub once for each window, passing each handle in as it goes.

HTH

[N62790]

BobRodes, on 04 February 2011 - 02:17 PM, said:

Ionut is quite right. Read up on the EnumWindows API function: http://msdn.microsof...(v=vs.85).aspx.

Here's the VB translation of the function specification (use the "Windows API Viewer" in VS 6.0 Tools menu folder to find these):

Public Declare Function EnumWindows Lib "user32" (ByVal lpEnumFunc As Long, ByVal lParam As Long) As Long

The way this works is you create a Sub, pass the name of the sub to lpEnumFunc using the AddressOf operator, and this function will go through all the top level windows on the screen and call your sub once for each window, passing each handle in as it goes.

HTH

Hi Bob,
thanks for your hint, I will try to follow your link ... :-)
might be helpfull for other applications as well ...
blue skies
Gunther Spitzer