| View previous topic :: View next topic |
| Author |
Message |
satanhead
Newbie
Joined: 16 Apr 2003
Posts: 3
|
 Posted: Thu Jan 08, 2004 2:38 pm Post subject: Ms-Excel 2002 (MS-Excel XP) with VDS 4.51... is it possible? |
 |
|
1) How do i print directly (no selecting printer dialog) from vds4.51 to excel?
2) What else can be done if I dont want to use DDE to link VDS and MS-Excel XP?
3) Can anyone create a plugin for working with MS-Office document? Like text-formatting in MS Word, set a slideshow effects just by clicking a button? ----> (i'm Willing to buy this plugin; if anyone ever created it)
4) How do i retreive data from a cell (e.g. R3C24) ? is it possible if i dont want to run the MS-Excel program? |
|
| Back to top |
|
 |
marty
Professional Member
Joined: 10 May 2001
Posts: 789
|
| Posted: Thu Jan 08, 2004 3:50 pm Post subject: |
|
|
| Quote: | | set a slideshow effects just by clicking a button? |
What do you mean exactly, a plugin to create a slideshow or support PowerPoint effects?
Funny I just saw your post on MMBforums also just now  Undecided on which tool to use righ?t?
Thanks... |
|
| Back to top |
|
|
SK
Newbie
Joined: 29 Dec 2003
Posts: 14
|
| Posted: Sat Jan 10, 2004 2:21 pm Post subject: |
|
|
I don't know if this will help, but you can use 'tab delimited text' to create Excell worksheets:
| Code: |
list create,1
list add,1,John@tab()21@tab()1111111
list add,1,Kris@tab()27@tab()2222222
list savefile,1,C:\friends.xls
list close,1
|
than you can open it in Excell and add/remove/edit fields manually. Be sure not to format the text (e.c. apply styles Bold/Italic... cell colors), as it will be saved in Excell format - not plain text.
Now how to get data from file:
| Code: |
option fieldsep,@tab()
list create,1
list loadfile,1,C:\friends.xls
%A = @count(1)
repeat
%B = @next(1)
parse "%%Name;%%Age;%%Phone",%B
info Name: %%Name@cr()Age: %%Age@cr()Phone: %%Phone
%A = @pred(%A)
until @zero(%A)
list close,1
|
Hope this will help...
_________________
SK |
|
| Back to top |
|
|
PGWARE
Web Host
Joined: 29 Dec 2001
Posts: 1565
|
| Posted: Sat Jan 10, 2004 5:23 pm Post subject: |
|
|
You can use a rtf control, there is a free dsu available here on vdsworld and the vdsobj.dll will allow you to use a richedit control on your window to edit .doc files for text formatting. However this will not produce MS Word document type files rather - rtf dcouments. You may be able to get away with editing 'some' ms word documents using a richedit control.
Other then that I don't think there is any other way to modify MS Word documents then using MDI and MDI is rather limited. You would definately need a COM object but such things aren't currently possible in VDS  |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
@vdsworld