Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
ThisWorkbook.Name returns the name of the file name....but with .xls
Is there a way to only return the file name with the extension? UserName = Environ("USERNAME") CpuName = Environ("COMPUTERNAME") WhatOffice = Environ("USERDOMAIN") MyFullName = ThisWorkbook.FullName Contents:=True, UserInterfaceOnly:=True Open "W:\PL10\PDSRlogs" & "\usage-" & ThisWorkbook.Name & ".log" For Append As #1 Print #1, UserName, WhatOffice, CpuName, Now, MyFullName 'Print #1, Application.UserName, Now Close #1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Writing to a text file | Excel Programming | |||
Writing to a text file | Excel Programming | |||
Writing strings to a text file ? | Excel Programming | |||
Writing to a text file some data | Excel Programming | |||
WRITING TO A TEXT FILE WITH SPECIFIC FORMAT | Excel Programming |