Access <->Excel

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Access <->Excel

Logged in as: Guest

arrSession:exec spGetSession 2,2,656

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Access <->Excel
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Access <->Excel - 7/6/2002 11:42:24 AM

lateflower

Posts: 1
Score: 0
Joined: 7/6/2002
From:
Status: offline

Hi there,
I need to make a connection between a sort of Access database and an Excel sheet.

Code to create the sheet:
Dim XL

Set XL = WScript.CreateObject("Excel.Application")
XL.Workbooks.Add

XL.ActiveSheet.Cells(1,1).Value="Value1"
XL.ActiveSheet.Cells(2,1).Value="Value2"
XL.ActiveSheet.Cells(1,2).Value="Value3"
XL.ActiveSheet.Cells(2,2).Value="Value4"

XL.Range("A1:B2").Select
XL.Selection.Borders.LineStyle = 1 'xlContinuous
XL.Application.Visible = True

But now I need code [VBScript] that can find the new Excel sheet an make a connection to is so cell values can be zapped over to Access.

Has anyone got a tip how to do this?

John