Bring back to exel a value computed in VB macro

[Sylvain GENTIN]

Hi
I try to bring back to exel a string computed by VB macro
function.
---------------------------------------------------------
Function CameoFilter(FileName As String, ByRef TextLine As
Variant)
....
TextLine = ...
End Function
---------------------------------------------------------
Exel command :
CameoFilter("myfile.txt", C22)
---------------------------------------------------------
any help would be grately appreciated.

cheers
Sylvain GENTIN

[Herfried K. Wagner [MVP]]

Hello,

"Sylvain GENTIN" <sg*****@ford.com> schrieb:

I try to bring back to exel a string computed by VB macro
function.
---------------------------------------------------------
Function CameoFilter(FileName As String, ByRef TextLine As
Variant)
...
TextLine = ...
End Function
---------------------------------------------------------
Exel command :
CameoFilter("myfile.txt", C22)
---------------------------------------------------------
any help would be grately appreciated.

This is a VB.NET language group. You will more likely get an answer if you
post to the microsoft.public.excel.programming group or to one of the VB
Classic groups (microsoft.public.vb.*).

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
http://www.mvps.org/dotnet

[Fergus Cooney]

Hi Sylivian,

|| I try to bring back to Excel a string computed by
|| VB macro function.

What does this mean, exactly ?

Regards,
Fergus