Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 01-24-2019, 10:04 PM
MrKim MrKim is offline Changing Absolute path to Relative in a Macro Windows 10 Changing Absolute path to Relative in a Macro Office 2019
Novice
Changing Absolute path to Relative in a Macro
 
Join Date: Jan 2019
Posts: 8
MrKim is on a distinguished road
Default

Now I get Runtime error 1004
Application defined or object defined error. And this line highlited:

.ListObject.DisplayName = "x"



Screenshot2.jpg

Also it looks like it's going to open up a new sheet to load the import into, but I wanted it on the same sheet as the user is presented with at the start, and where they trigger the macro.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Absolute path to Relative in a Macro Relative path for hyperlinks wpryan Word 4 01-09-2019 05:15 PM
Changing Absolute path to Relative in a Macro Image absolute position relative to page thuizt Word VBA 4 08-01-2017 07:25 AM
Hyperlinks defaulting to absolute instead of relative!!! wdzambotti Word VBA 1 08-17-2015 09:03 PM
Changing Absolute path to Relative in a Macro PowerPoint VBA: ApplyTemplate & absolute path tinfanide PowerPoint 2 04-05-2013 07:28 AM
Changing Absolute path to Relative in a Macro Relative path to desktop b0x4it Word VBA 4 05-18-2011 11:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:58 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