| Excel sheet processing [message #81601] |
Wed, 05 March 2003 01:39  |
Victoria
Messages: 152
Registered: July 2002
|
Senior Member |
|
|
Hi,
I have one button in my form.When i press that button,windows standard dialog box should open showing only the .xls files.After selecting the .xls file,
the following operations on the xls sheet should be done in the background.
Find and Replace string
Change Font Type and Size
and Save as (text space delimited) document.
(Here i did not mean doing it manually)
Finally rename this file with .dat extension.
Please write full details about it.
THanks
~V~
|
|
|
|
| Re: Excel sheet processing [message #81607 is a reply to message #81601] |
Wed, 05 March 2003 06:59  |
magnetic
Messages: 324
Registered: January 2003
|
Senior Member |
|
|
Its not an easy job :)
Some hint...
The most important things are :
-you should know how to work with forms ole2 built-in.
-know how the interaction is with excel objects and
handles [[visual basic]].
then you can write procedures to send parameters to excel [[searchstring,replacestring,fontname/size]] to excel.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
