Importing a text document via macro button

[Clarkit]

Hello Everyone,

Thanks for help up front.

I have the programming done that allows me to click the macro button and select a text file to import. It all works wonderfully. However, I want to ask a question about programming the directory that opens in the dialogue box when you click the button.

This template will potentially be used by other people, so when I point the command to C:\Users\"Clarkit's"\Documents (the user of the computer, and documents, location the text file will always be in), will excel automatically use the current user of the template, or will it come up with and error and say "file directory doesnt exist"?

My question is, is there a way to define the "current user", or the account that the template is being used under?

So instead of this:
ChDir "C:\Users\Clarkit\Documents"
fName = Application.GetOpenFilename()

Excel will automatically fill in the blank with the correct user?
ChDir "C:\Users\ _______\Documents"
fName = Application.GetOpenFilename()


This is a tricky one!

Thanks!

[Marc L]

Hi,

very easy level !

Please Login or Register  to view this content.

[Clarkit]

Thanks for the reply, and from Paris! Cool. Greetings from the States

Do I just input your code like this?

Please Login or Register  to view this content.

[Clarkit]

Thanks for the reply, and from Paris! Cool. Greetings from the States

I think this code only tells me what the current users path to the documents folder is. I want the Application.GetOpenFilename() command to go directly to the correct path without any navigation.

Thanks!

Please Login or Register  to view this content.

[Sean Thomas]

i think theres an easier way, but cant remember at the moment

Please Login or Register  to view this content.

[Sean Thomas]

try this one

Please Login or Register  to view this content.

[Marc L]

Please Login or Register  to view this content.

[Sean Thomas]

Sorry, i didnt read the question properly
you can use the following to get various folder paths

Please Login or Register  to view this content.

[Clarkit]

Hello Marc,

That did the trick! Thank you!

[Clarkit]

Thanks for the input Sean!

[Marc L]

Please Login or Register  to view this content.

My easy way works only in standard user session
but in case of relocation of user folders the better is to follow Sean's code :

Please Login or Register  to view this content.

Any chance to see my reputation growing …

[Clarkit]

Any chance to see my reputation growing …

I grew it twice

I changed your suggestion to :

Please Login or Register  to view this content.

Thanks guys!