Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing OLE DB connection
I'm trying to create a macro that will automatically Edit OLE DB Query each
month. The closest help I got was the following: tSource="C:\Mar05\File05.xls" With cn .Provider = "Microsoft.Jet.OLEDB.4.0" .ConnectionString = "Data Source=" & tSource & ";" & _ "Extended Properties=Excel 8.0;" .Open End With Not sure of the Open but what I'd like to see the new source file when I check on the Edit OLE DB Query screen the next time. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an OLAP connection to distribute with an Excel sheet | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
changing page break in an excel file | New Users to Excel | |||
Changing Server on a Microsoft Query | Excel Discussion (Misc queries) |