Microsoft Office Forums - View Single Post - Changing Absolute path to Relative in a Macro

Thread: Changing Absolute path to Relative in a Macro

View Single Post

Old

01-24-2019, 09:26 PM

MrKim

MrKim is offline

MrKim uses Windows 10

Windows 10 MrKim uses Office 2019

MrKim uses Office 2019

Office 2019

Novice

The original poster

Join Date: Jan 2019

Posts: 8

MrKim is on a distinguished road

Default

Ken, when I pasted that code into my file and ran it, I got "Compile error. Arguement not optional. - referring to this line: (and see attached screenshot)

ActiveWorkbook.Queries.Add , "x", f

Screenshot1.jpg

Reply With Quote