• Status: Solved
  • Priority: High
  • Security: Private
  • Views: 23
  • Last Modified:

how can i modify this code that instead of prompting from ChDir FolderPath it shows the C drive

I had this question after viewing Help needed on vba modification on earlier solution.

this line of code promprs from the same folder as "thisworkbook"

how to change this to starts from C drive not from the this workbook path


FolderPath = Application.ThisWorkbook.Path
ChDir FolderPath

Open in new window

0
Flora
Asked:
Flora
  • 2
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try
ChDir "c:\"

Open in new window

Regards
0
 
FloraAuthor Commented:
Thank you very much.
0
 
FloraAuthor Commented:
this was so simple . how did i miss it :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now