Environ("TMPDIR") returns empty string

**asiguld1** · 10-01-2021, 05:33 AM

Hi,

I used the following to get a location to be used for temp files

strP = environ("TMPDIR")

unfortunately I get back an empty string only. If I use the variable "TMP" instead of "TMPDIR" it works find. The different between both are the used separator between the several directories.
TMPDIR: c:/DirA/DirB
and
TMP: c:\DirA\DirB

Does someone know why it is not working with "/". Within the description of Environ I couldn't found any restrictions

Thanks in advance

Regards
asiguld

**rorya** · 10-01-2021, 05:41 AM

Do you actually have an environment variable called TMPDIR?

**asiguld1** · 10-01-2021, 05:51 AM

Yes, both variables do exists
2021-10-01 11_52_23-Eingabeaufforderung.png

**Artik** · 10-01-2021, 05:55 AM

asiguld1, referring to rorya's statement, check the results in the Immediate window:

Please Login or Register  to view this content.

Edit:
It does not matter anymore

Artik

**asiguld1** · 10-01-2021, 06:01 AM

Already done. The following may be helpful as addtional information. On my PC (German) no problem, but if the same macro is running on a laptop located in Great Britannien it doesn't. At this PC the function returns nothing even no error.
My question is not to find a solution, I already solved it by using "TMP" instead of "TMPDIR". I want just to understand why it is how it is.

**Artik** · 10-01-2021, 06:18 AM

You have probably "manually" located the TEMPDIR environment variable on your computer. But that doesn't mean that this variable must appear on all computers. It can be added by some application that you have that is not on other computers.

Artik

**rorya** · 10-01-2021, 06:20 AM

When/how was the variable created? If I remember rightly, temporary environment variables are not returned by Environ.

Environ("TMPDIR") returns empty string

LinkBack

Thread Tools

Rate This Thread

Display

Environ("TMPDIR") returns empty string

Re: Environ("TMPDIR") returns empty string

Re: Environ("TMPDIR") returns empty string

Re: Environ("TMPDIR") returns empty string

Re: Environ("TMPDIR") returns empty string

Re: Environ("TMPDIR") returns empty string

Re: Environ("TMPDIR") returns empty string

Thread Information

Users Browsing this Thread

Similar Threads

how to fix IFERROR(VLOOKUP) That returns "0" when reference cell is empty

create text string: "NOT "[b2value]", NOT "[b3value]", ..., NOT "[b600value]"

[SOLVED] Index function returns 0 (zero) instead of ""(empty)

Parse first name & surname from Windows logon name (Environ("UserName")

[SOLVED] IFERROR(VLOOKUP) That returns "0" when reference cell is empty

Difference between Environ("USERNAME") and Environ$("USERNAME")

[SOLVED] For Each Next returns "Empty" when Data in Cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions