Visual Basic 4 / 5 / 6 RSS Visual Basic 4 / 5 / 6 RSS

How to access and modify values of a OLE object(Excel Worksheet)

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Reply

•
•
Join Date: Jul 2006
Posts: 13
Reputation: deep_3657 is an unknown quantity at this point 
Solved Threads: 0
deep_3657 deep_3657 is offline Offline
Newbie Poster

How to access and modify values of a OLE object(Excel Worksheet)

 
0
  #1
Jun 16th, 2007
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
Quality Website Design & Development-India
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2007
Posts: 166
Reputation: AV Manoharan is an unknown quantity at this point 
Solved Threads: 9
AV Manoharan AV Manoharan is offline Offline
Junior Poster

Re: How to access and modify values of a OLE object(Excel Worksheet)

 
0
  #2
Jun 18th, 2007
Why don't you try it?

There is nothing impossible when you get the connection and permission.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2006
Posts: 13
Reputation: deep_3657 is an unknown quantity at this point 
Solved Threads: 0
deep_3657 deep_3657 is offline Offline
Newbie Poster

Re: How to access and modify values of a OLE object(Excel Worksheet)

 
0
  #3
Jun 18th, 2007
•
•
•
•
Originally Posted by AV Manoharan View Post
Why don't you try it?

There is nothing impossible when you get the connection and permission.
Yes I want to use it, but have no idea about how to go about it
Quality Website Design & Development-India
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2006
Posts: 848
Reputation: QVeen72 is on a distinguished road 
Solved Threads: 120
QVeen72's Avatar
QVeen72 QVeen72 is offline Offline
Practically a Posting Shark

Re: How to access and modify values of a OLE object(Excel Worksheet)

 
0
  #4
Jun 18th, 2007
Hi Deep,

U r opening Excel using "Excel Object " or by Opening in "OLE Control"...?

I have the code if u r opening with
Excel Object.

Regards
Veena
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2006
Posts: 13
Reputation: deep_3657 is an unknown quantity at this point 
Solved Threads: 0
deep_3657 deep_3657 is offline Offline
Newbie Poster

Re: How to access and modify values of a OLE object(Excel Worksheet)

 
0
  #5
Jun 18th, 2007
•
•
•
•
Originally Posted by QVeen72 View Post
Hi Deep,

U r opening Excel using "Excel Object " or by Opening in "OLE Control"...?

I have the code if u r opening with
Excel Object.

Regards
Veena

I have embedded excel as a OLE object
Quality Website Design & Development-India
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2007
Posts: 166
Reputation: AV Manoharan is an unknown quantity at this point 
Solved Threads: 9
AV Manoharan AV Manoharan is offline Offline
Junior Poster

Re: How to access and modify values of a OLE object(Excel Worksheet)

 
0
  #6
Jun 18th, 2007
•
•
•
•
Originally Posted by deep_3657 View Post
I have embedded excel as a OLE object
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.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2006
Posts: 13
Reputation: deep_3657 is an unknown quantity at this point 
Solved Threads: 0
deep_3657 deep_3657 is offline Offline
Newbie Poster

Re: How to access and modify values of a OLE object(Excel Worksheet)

 
0
  #7
Jun 18th, 2007
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.
Quality Website Design & Development-India
Professional Website layouts & Templates - Ready to Use website Designs
Great Directory | TN Directory - Free SEO friendly directories
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2007
Posts: 166
Reputation: AV Manoharan is an unknown quantity at this point 
Solved Threads: 9
AV Manoharan AV Manoharan is offline Offline
Junior Poster

Re: How to access and modify values of a OLE object(Excel Worksheet)

 
0
  #8
Jun 19th, 2007
•
•
•
•
Originally Posted by deep_3657 View Post
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
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC