borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (Calculated Fields)Next Topic (Creating Login Program) New Topic New Poll Post Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : how to access field in excel in the program
Poster Message
elgy
Level: Scholar

Registered: 20-07-2005
Posts: 42

icon how to access field in excel in the program

i want to print text in certain column and row in excel, what is the syntax?

the excel is an ole object in a form.

24-03-2006 at 02:53 PM
View Profile Send Email to User Show All Posts | Quote Reply
stickleprojects
Level: Moderator


Registered: 09-09-2002
Posts: 891
icon Re: how to access field in excel in the program


objWorksheet.Cells(Row, Col).Value = text

Regards,
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

25-03-2006 at 03:38 PM
View Profile Send Email to User Show All Posts | Quote Reply
elgy
Level: Scholar

Registered: 20-07-2005
Posts: 42
icon Re: how to access field in excel in the program

quote:
stickleprojects wrote:

objWorksheet.Cells(Row, Col).Value = text

Regards,
Kieron



thx stickle, but i think i should describe it more clearly.

the xl work sheet i put it as ole object in a form.
if i use ole1.cells(row, col).value = text
error message came up, class or method not found and the "Cells" was highlighted.
is that method need reference? what is the reference?
thx b4.
27-03-2006 at 05:18 AM
View Profile Send Email to User Show All Posts | Quote Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : how to access field in excel in the program
Previous Topic (Calculated Fields)Next Topic (Creating Login Program) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder