ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   C# open xla file with automation (https://www.excelbanter.com/excel-programming/339497-c-open-xla-file-automation.html)

Arnaud

C# open xla file with automation
 
Hi,

Problem : with winmerge I can't compare xla files -- binaries files differs.

objectif : open xla files by automation excel in C#.
then with automation export every source files and launch winmerge to
compare them.

-- then I use this code :
this.excelWorkbook = this.excelApp.Workbooks.Open(
project.xla, vk_update_links, vk_read_only, vk_format,
vk_password,
vk_write_res_password, vk_ignore_read_only_recommend,
vk_origin,
vk_delimiter, vk_editable, vk_notify, vk_converter,
vk_add_to_mru,
vk_local, vk_corrupt_load);

it woks fine but only on xls files.
but the code I want to compare are located in xla files.
Is there a way to automation XLA files ?

Arnaud

Arnaud

C# open xla file with automation
 
oops sorry my xla files is become corrupted while testing please delete this
thread

"Arnaud" wrote:

Hi,

Problem : with winmerge I can't compare xla files -- binaries files differs.

objectif : open xla files by automation excel in C#.
then with automation export every source files and launch winmerge to
compare them.

-- then I use this code :
this.excelWorkbook = this.excelApp.Workbooks.Open(
project.xla, vk_update_links, vk_read_only, vk_format,
vk_password,
vk_write_res_password, vk_ignore_read_only_recommend,
vk_origin,
vk_delimiter, vk_editable, vk_notify, vk_converter,
vk_add_to_mru,
vk_local, vk_corrupt_load);

it woks fine but only on xls files.
but the code I want to compare are located in xla files.
Is there a way to automation XLA files ?

Arnaud



All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com