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?
 

xbxh

New Member
Joined
Jan 13, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
O wow that simple! I will give it a shot and let you know. Thanks!
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

xbxh

New Member
Joined
Jan 13, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
Awesome that worked perfectly! Thank you so much for helping this issue was driving me crazy!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
68,339
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,578
Messages
5,770,955
Members
425,653
Latest member
UNSING

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
Top