Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 06-18-2019, 01:34 PM
DaveP DaveP is offline Input Box Help/Storing Variables in other Macros Windows 10 Input Box Help/Storing Variables in other Macros Office 2010
Novice
Input Box Help/Storing Variables in other Macros
 
Join Date: May 2019
Posts: 11
DaveP is on a distinguished road
Default

Thanks for the response!

I tried this code out, and it opened a file path, but if it's storing the file path in the macro for future use, I'm not seeing it.

The whole goal is to be able to provide access to templates that have not been created yet, as they are created. On the files tab in word, you can click "copy path to clipboard".
My idea is--- the user will be notified that the new file has been created, they locate the file, run the macro, copy path into the input box, and now forever, instead of doing that process or searching for the correct file, there is a button in the application that has stored the file path to be opened for future use. I hope that makes sense. Our filing system is kind of incredibly specific (necessarily specific, though) and, at times, very hard to navigate. If the user has the option to open a document without ever leaving the document they're working on, it will save us loads of time and frustration.


Was I supposed to run this code with my original code in it somewhere, maybe? I created a module to test this idea in within word, so what you sent is just below the original code in the Visual Basic window.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro keyboard commands and storing them swepo Word 7 12-15-2018 11:44 AM
Array to iterate through variables and trap blank variables Marrick13 Word VBA 5 08-04-2015 06:19 AM
Input Box Help/Storing Variables in other Macros Code for storing new word fahmiakbar Word VBA 2 02-13-2015 11:26 AM
can word: make variables, find appropriate pages, fill out pages with variables, print only those 20GT Word VBA 1 10-15-2014 09:48 PM
Creating Wizards with Input Variables marka Excel Programming 1 11-11-2012 09:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:50 AM.


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