Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-27-2017, 02:22 AM
Cyberseeker Cyberseeker is offline Edit Filename Path? Windows 10 Edit Filename Path? Office 2010 32bit
Advanced Beginner
Edit Filename Path?
 
Join Date: Jun 2016
Posts: 44
Cyberseeker is on a distinguished road
Default Edit Filename Path?


I have a macro that I haven't used for a long time, and I would like to get it up and going again. It comes to a grinding halt where my code reads,
Code:
Workbooks.Open FileName:=fileloc
I receive a message, Run-time error '1004': and it tells me my file could not be found. Yes, Ive changed my file location, and its now up in the sky (onedrive) . Thats where I want it, but my question is: how do I edit my Filename? I dont even know where to find it, what less edit it. Alternatively, is it better to write the path directly into the macro?

Any help appreciated.
Reply With Quote
 

Tags
filename

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word does not show filename during edit es35 Word 5 10-29-2016 12:12 AM
use full path for filename ruggb Word 1 08-21-2015 05:10 AM
Edit Filename Path? How to: Have two templates cross-reference each other independent of filename path HighSierra Word 6 05-06-2015 07:04 PM
Edit Filename Path? Change old path to new path (batch) NobodysPerfect Word VBA 2 08-14-2014 10:09 PM
MarkAsFinal - 'Edit Anyway' edit popup issue GovindRS PowerPoint 1 06-20-2011 06:43 AM

Other Forums: Access Forums

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