Const PATH = question

xbxh

New Member
Joined
Jan 13, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
I have a document that was created by somebody else. I am trying to break down how it works. I need to have this doc save to a mapped network drive but currently it is saving to a location on the local C: From digging through the macros in this report I found this section

Dim globChanged As Boolean
Const SAVE = 0
Const CHECK = 1
Const CHANGED = 2
Const PATH = "C:\Quotations as of 6-1-13\"
Dim globFName As String
Dim globFSuffix As String
Dim globFileList(1000) As String
Dim globFileCount As Integer

So I created a folder on the C: called Quotations as of 6-1-12 just to see if changing that would work. It did. All the macros fired off checked the folder to see if there was a similar file name then saved as a pdf and work book into that new folder. So my next test was changing the Const PATH= to Q:\ which is our mapped network drive. When I ran the macros it saved the document to C:\Users\(User name)\Documents. I am so confused. Any ideas?
 
O wow that simple! I will give it a shot and let you know. Thanks!
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Awesome that worked perfectly! Thank you so much for helping this issue was driving me crazy!
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top