![]() |
#1
|
|||
|
|||
![]()
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? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Get the latest filename from directory with a macro | spider85 | Word VBA | 2 | 07-10-2017 10:43 PM |
![]() |
Gwinnett | Mail Merge | 3 | 03-01-2017 09:25 AM |
![]() |
JON25T | Mail Merge | 3 | 12-22-2016 01:34 PM |
![]() |
staicumihai | Word VBA | 2 | 10-28-2016 03:01 AM |
![]() |
jc491 | Word VBA | 8 | 09-11-2015 08:31 AM |