Hello, everyone!

Microsoft provides a free utility called "Excel Viewer" that allows you 
to open and view Microsoft Excel documents.  It can be downloaded here...

http://www.microsoft.com/downloads/details.aspx?familyid=1cd6acf9-ce06-4e1c-8dcf-f33f669dbc3a&displaylang=en

I am attempting to create an instance of the Excel Viewer object in code 
and use it to import Excel files into my application.  I can already do 
this using the full Excel application, but I would like the option of 
using the Excel Viewer application also.

The Excel Viewer utility is installed on my computer as XLVIEW.EXE in 
the C:\Program Files\Microsoft Office\Office12 folder.  I assumed that 
the following line of code would work, but it doesn't:

oExcel := GetObject( , "Xlview.Application" )	

Nor does this...

oExcel := GetObject("C:\Program Files\MicrosoftOffice\Office12\XlView.exe")

Does anyone have any ideas regarding how I can get this to work?  Any 
help will be appreciated.

Thanks!

Chris Carmac

Hi Chris,

I don't think you can use "Excel Viewer" to import files - only to view 
or print them.  Obviously, if that's all you need to do then you can 
just use runshell.

AFAIK, "Excel Viewer" specifically will not export data.  It does 
provide the ability to mark and copy the data to the ClipBoard - which 
can then be Pasted in another App, but that's the limit.

-Joe



Chris Carmac wrote:
> Hello, everyone!
> 
> Microsoft provides a free utility called "Excel Viewer" that allows you 
> to open and view Microsoft Excel documents.  It can be downloaded here...
> 
> http://www.microsoft.com/downloads/details.aspx?familyid=1cd6acf9-ce06-4e1c-8dcf-f33f669dbc3a&displaylang=en 
> 
> 
> I am attempting to create an instance of the Excel Viewer object in code 
> and use it to import Excel files into my application.  I can already do 
> this using the full Excel application, but I would like the option of 
> using the Excel Viewer application also.
> 
> The Excel Viewer utility is installed on my computer as XLVIEW.EXE in 
> the C:\Program Files\Microsoft Office\Office12 folder.  I assumed that 
> the following line of code would work, but it doesn't:
> 
> oExcel := GetObject( , "Xlview.Application" )   
> 
> Nor does this...
> 
> oExcel := GetObject("C:\Program Files\MicrosoftOffice\Office12\XlView.exe")
> 
> Does anyone have any ideas regarding how I can get this to work?  Any 
> help will be appreciated.
> 
> Thanks!
> 
> Chris Carmac

Hello Chris,

> The Excel Viewer utility is installed on my computer as XLVIEW.EXE in
> the C:\Program Files\Microsoft Office\Office12 folder.  I assumed that
> the following line of code would work, but it doesn't:
> 
> oExcel := GetObject( , "Xlview.Application" )
> 
> Nor does this...
> 
> oExcel := GetObject("C:\Program
> Files\MicrosoftOffice\Office12\XlView.exe")
> 
> Does anyone have any ideas regarding how I can get this to work?  Any
> help will be appreciated.

Use Regedit to search the HKEY_CLASSES_ROOT hive to see if any COM registrations 
point to the EXE.  If so, then an OLEVIEWer application should reveal the 
extent of object model presented by the viewer.  If the viewer doesn't register 
any COM then you only have the command line options available.

Regards,

Rodd Graham, Consultant
Graham Automation Systems, LLC

hi,

> Microsoft provides a free utility called "Excel Viewer" that allows you to 
> open and view Microsoft Excel documents.  It can be downloaded here...

it is about 77MB(!)
it is a "Viewer" only, no OCX, DLL or COM found with CommViewer.

if you got a Handle of running XlView.EXE ... you can try to "remote" it by

FUNCTION SendInput( cInput )
RETURN DllCall( "user32",32,"SendInput", Int(Len(cInput) / 28) , cInput , 
28)

to send Keystoke from Xbase++ to its Queue

grretings by OHR
Jimmy

I searched the registry, and I also searched my computer using the 
OleView tool, but I didn't find any COM registrations I can use to 
access the Excel Viewer.

Oh well, it was worth a shot. 

Thanks for you responses!  I appreciate the help.  

Chris


Chris Carmac wrote:
> Hello, everyone!
> 
> Microsoft provides a free utility called "Excel Viewer" that allows you 
> to open and view Microsoft Excel documents.  It can be downloaded here...
> 
> http://www.microsoft.com/downloads/details.aspx?familyid=1cd6acf9-ce06-4e1c-8dcf-f33f669dbc3a&displaylang=en 
> 
> 
> I am attempting to create an instance of the Excel Viewer object in code 
> and use it to import Excel files into my application.  I can already do 
> this using the full Excel application, but I would like the option of 
> using the Excel Viewer application also.
> 
> The Excel Viewer utility is installed on my computer as XLVIEW.EXE in 
> the C:\Program Files\Microsoft Office\Office12 folder.  I assumed that 
> the following line of code would work, but it doesn't:
> 
> oExcel := GetObject( , "Xlview.Application" )   
> 
> Nor does this...
> 
> oExcel := GetObject("C:\Program Files\MicrosoftOffice\Office12\XlView.exe")
> 
> Does anyone have any ideas regarding how I can get this to work?  Any 
> help will be appreciated.
> 
> Thanks!
> 
> Chris Carmac

I think Open Office would have a COM object you could use to view an 
excel file.


Chris Carmac wrote:
> 
> I searched the registry, and I also searched my computer using the 
> OleView tool, but I didn't find any COM registrations I can use to 
> access the Excel Viewer.
> 
> Oh well, it was worth a shot. 
> 
> Thanks for you responses!  I appreciate the help.  
> 
> Chris
> 
> 
> Chris Carmac wrote:
> 
>> Hello, everyone!
>>
>> Microsoft provides a free utility called "Excel Viewer" that allows 
>> you to open and view Microsoft Excel documents.  It can be downloaded 
>> here...
>>
>> http://www.microsoft.com/downloads/details.aspx?familyid=1cd6acf9-ce06-4e1c-8dcf-f33f669dbc3a&displaylang=en 
>>
>>
>> I am attempting to create an instance of the Excel Viewer object in 
>> code and use it to import Excel files into my application.  I can 
>> already do this using the full Excel application, but I would like the 
>> option of using the Excel Viewer application also.
>>
>> The Excel Viewer utility is installed on my computer as XLVIEW.EXE in 
>> the C:\Program Files\Microsoft Office\Office12 folder.  I assumed that 
>> the following line of code would work, but it doesn't:
>>
>> oExcel := GetObject( , "Xlview.Application" )  
>> Nor does this...
>>
>> oExcel := GetObject("C:\Program 
>> Files\MicrosoftOffice\Office12\XlView.exe")
>>
>> Does anyone have any ideas regarding how I can get this to work?  Any 
>> help will be appreciated.
>>
>> Thanks!
>>
>> Chris Carmac

You can use this component and distributed with your applications

http://www.farpointspread.com/products/spread/spread.aspx



"Chris Carmac" <ccarmac@freedomsoft.info> wrote in message 
news:3f227020$47016f6$2a7f4@news.alaska-software.com...
> Hello, everyone!
>
> Microsoft provides a free utility called "Excel Viewer" that allows you to 
> open and view Microsoft Excel documents.  It can be downloaded here...
>
> http://www.microsoft.com/downloads/details.aspx?familyid=1cd6acf9-ce06-4e1c-8dcf-f33f669dbc3a&displaylang=en
>
> I am attempting to create an instance of the Excel Viewer object in code 
> and use it to import Excel files into my application.  I can already do 
> this using the full Excel application, but I would like the option of 
> using the Excel Viewer application also.
>
> The Excel Viewer utility is installed on my computer as XLVIEW.EXE in the 
> C:\Program Files\Microsoft Office\Office12 folder.  I assumed that the 
> following line of code would work, but it doesn't:
>
> oExcel := GetObject( , "Xlview.Application" )
> Nor does this...
>
> oExcel := GetObject("C:\Program 
> Files\MicrosoftOffice\Office12\XlView.exe")
>
> Does anyone have any ideas regarding how I can get this to work?  Any help 
> will be appreciated.
>
> Thanks!
>
> Chris Carmac
>