Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-15-2018, 05:55 AM
Broman66 Broman66 is offline Open directory in word using macro Windows 7 64bit Open directory in word using macro Office 2013
Novice
Open directory in word using macro
 
Join Date: Mar 2018
Posts: 1
Broman66 is on a distinguished road
Default 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?
Reply With Quote
 



Similar Threads
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
Open directory in word using macro Mailmerge Directory - TableJoiner Macro Gwinnett Mail Merge 3 03-01-2017 09:25 AM
Open directory in word using macro directory: want to a ensure all three lines in a directory entry appear on the same page. JON25T Mail Merge 3 12-22-2016 01:34 PM
Open directory in word using macro Word 2010 Macro to rename Folder in Directory staicumihai Word VBA 2 10-28-2016 03:01 AM
Open directory in word using macro How To Apply A VBA Macro to All Subfolders in a Directory of a docx. Extension jc491 Word VBA 8 09-11-2015 08:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft