Results 1 to 13 of 13

Variable in OLE DB Connection

Threaded View

  1. #1
    Registered User
    Join Date
    02-16-2009
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel for Office 365
    Posts
    17

    Variable in OLE DB Connection

    Hi All,

    I have the below connection specified in the Data->Import External Data->Edit Query but I wish to replace the static SHADES799 with a variable Username that will pick up the Windows username of the person running the sheet. How and where can I make this change to achieve desired results?

    Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=d:\Documents and Settings\SHADES799\My Documents\Employee_RankingGrid.xls;Mode=ReadWrite;Extended Properties="HDR=YES;";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=35;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False
    Many Thanks for any help,
    Colm
    Last edited by VBA Noob; 02-18-2009 at 09:29 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1