ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Use Macro to Run External Program (https://www.excelbanter.com/excel-programming/350847-use-macro-run-external-program.html)

Peter

Use Macro to Run External Program
 
Hello,

I've heard that I can use a macro from Excel to operate a non-Microsoft
program. I would like to be able to parse through the rows of data in the
worksheet and enter the data into the program. A plus would be able to copy
the data from the program and paste it back in the the worksheet. Would this
be possible? I am using Office 2003.

Thanks.

[email protected]

Use Macro to Run External Program
 
hi,

As you expected, the non-microsoft programming lanauages are able to
handle the excel spreadsheet
on condition that Microsft Excel is installed on your PC.

Not knowing of your program, I would like to introduce an article using
delphi,
the article is
"Accessing and managing MS Excel sheets with Delphi"
http://delphi.about.com/od/database/l/aa090903a.htm

may be helpful,

Best regards,

sjoo


NickHK

Use Macro to Run External Program
 
Peter,
Without knowing the other app in question, the answer would be a maybe.

NickHK

"Peter" wrote in message
...
Hello,

I've heard that I can use a macro from Excel to operate a non-Microsoft
program. I would like to be able to parse through the rows of data in the
worksheet and enter the data into the program. A plus would be able to

copy
the data from the program and paste it back in the the worksheet. Would

this
be possible? I am using Office 2003.

Thanks.





All times are GMT +1. The time now is 12:11 PM.

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