|
-
Aug 24th, 2001, 09:22 AM
#1
Thread Starter
Member
probs w/ VB to Excel
the following is the code i am using to test to see if i can get it to add info to excel but i cant seem to get it to work can someone help - i just want to for now take the word TEST and add it to excel later on i will expand and make it add what ever is in listbox and add it to excel THANKS ALOT
Dim xlsWorkBook As Excel.Workbook
Dim xlsWorkSheet As Excel.Worksheet
Set xlsWorkBook = GetObject("D:\MoviePlayList VB\test.xls")
Set xlsWorkSheet = xlsWorkBook.Worksheets("C")
Print sheets2.Cells(1, 2) = "TEST"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|