P
phong.lee
Hello all,
If anyone can guide me with the following, that would be great. I
have the following code that opens up a new workbook, now i can't
figure out how to get some data from a query that was built in MS
access. Any kind of sample would be greatly appreciated.
Private Sub CmdUpdateLiveDates_Click()
Dim strDatabaseName As String
Dim wb As Workbook
Dim ws As Worksheet
Dim rs As dao.Recordset
'Open new workbook and rename the worksheet tabs
Set wb = Application.Workbooks.Add
wb.Sheets(1).Name = "Live Dates By Month"
wb.Sheets(2).Name = "Live Dates By Portfolio"
wb.Sheets(3).Name = "Live Dates"
strDatabaseName = DatabasePath & "\" & DatabaseName
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
'Intialize database object
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If anyone can guide me with the following, that would be great. I
have the following code that opens up a new workbook, now i can't
figure out how to get some data from a query that was built in MS
access. Any kind of sample would be greatly appreciated.
Private Sub CmdUpdateLiveDates_Click()
Dim strDatabaseName As String
Dim wb As Workbook
Dim ws As Worksheet
Dim rs As dao.Recordset
'Open new workbook and rename the worksheet tabs
Set wb = Application.Workbooks.Add
wb.Sheets(1).Name = "Live Dates By Month"
wb.Sheets(2).Name = "Live Dates By Portfolio"
wb.Sheets(3).Name = "Live Dates"
strDatabaseName = DatabasePath & "\" & DatabaseName
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
'Intialize database object
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~