•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 392,090 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,939 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser:
Views: 2286 | Replies: 7
![]() |
•
•
Join Date: Jul 2006
Posts: 13
Reputation:
Rep Power: 3
Solved Threads: 0
Hello,
I want to know is it possible to access and modify content of a Excel worksheet dynamically inserted as OLE object in a form. I wish to check and update values of various cells by cell number of the worksheet, but not being sure if possible.
thanks in advance
I want to know is it possible to access and modify content of a Excel worksheet dynamically inserted as OLE object in a form. I wish to check and update values of various cells by cell number of the worksheet, but not being sure if possible.
thanks in advance
Quality Website Design & Development-India
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
•
•
Join Date: Jul 2006
Posts: 13
Reputation:
Rep Power: 3
Solved Threads: 0
Quality Website Design & Development-India
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
•
•
Join Date: Jul 2006
Posts: 13
Reputation:
Rep Power: 3
Solved Threads: 0
Quality Website Design & Development-India
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
•
•
Join Date: Jun 2007
Posts: 166
Reputation:
Rep Power: 2
Solved Threads: 7
See, I requested you to try.
See when you have the connection as an OLE object its behaviour is just like a table of the database. Each sheet corresponding to one table and within each sheet the columns represent table fields.
the record set object works fine here also.
Try and let me know your progress.
•
•
Join Date: Jul 2006
Posts: 13
Reputation:
Rep Power: 3
Solved Threads: 0
But the excel documents I am working with are not the set of records like we have in database.
I am working with excel files which are soft copies of various physical documents like invoice, quotations etc. Programitically I would say various informations are scattered all around.
However Cell Number where a specific information is found is always fixed. This is the reason i wish to access is by cell numbers rather than by database approach.
I am working with excel files which are soft copies of various physical documents like invoice, quotations etc. Programitically I would say various informations are scattered all around.
However Cell Number where a specific information is found is always fixed. This is the reason i wish to access is by cell numbers rather than by database approach.
Quality Website Design & Development-India
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
•
•
Join Date: Jun 2007
Posts: 166
Reputation:
Rep Power: 2
Solved Threads: 7
•
•
•
•
But the excel documents I am working with are not the set of records like we have in database.
I am working with excel files which are soft copies of various physical documents like invoice, quotations etc. Programitically I would say various informations are scattered all around.
However Cell Number where a specific information is found is always fixed. This is the reason i wish to access is by cell numbers rather than by database approach.
Then I suggest, the recordset is to be populated by two indexes to draw row as well as coulums.
That is, suppose your recordset is in the second record, then the raw corresponds to the cursor location second among the records.
Then you have to access columns right with the recordsetname.Fields(index)-which is your columns in excel in that row
recordsetname.MoveNext increases the row count to one
and again your column index has to reinitialise else it will be out of your excel columns.
Now, you got it I hope.
Get back to the thread
regards
AV Manoharan
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
- Accessing excel worksheet in a word document (VB macro). (Visual Basic 4 / 5 / 6)
- Access displays 'OLE object' on linked Oracle datetime (Oracle)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: anyone interested in developing open source software
- Next Thread: help me its urgent!


Linear Mode