Open directory in word using macro
Hi.
I want to change this macro.
Sub Makro1()
'
' Makro1 Makro
'
'
ActiveDocument.MailMerge.OpenDataSource Name:= _
"Q:\SESTORIN\opt\NIMAB Produktion\Div Nimab projektering\TEST PROJEKTSTRUKTUR\25. Övrigt\03. Databas\Projektregister.xlsx" _
, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=Q:\SESTORIN\opt\NIMAB Produktion\Div Nimab projektering\TEST PROJEKTSTRUKTUR\25. Övrigt\03. Databas\Projektregister.xlsx;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database=" _
, SQLStatement:="SELECT * FROM `Blad1$`", SQLStatement1:="", SubType:= _
wdMergeSubTypeAccess
ActiveDocument.MailMerge.ViewMailMergeFieldCodes = wdToggle
End Sub
What I want to change is
Q:\SESTORIN\opt\NIMAB Produktion\Div Nimab projektering\TEST PROJEKTSTRUKTUR\25. Övrigt\03. Databas\Projektregister.xlsx
I would like to open the directory so I can choose the specific file I want to use instead of
"Q:\SESTORIN\opt\NIMAB Produktion\Div Nimab projektering\TEST PROJEKTSTRUKTUR\25. Övrigt\03. Databas\Projektregister.xlsx" _
And after I have choosen the file I want to use the macro will continue.
Anyone who can help me?
|