Excel issue saving files to hexadecimal filenames on terminal server...
I have a customer who has an issue with Excel. He has people connecting to
a terminal server where the spreadsheets and excel is installed and they
open the sheet, make changes, and then save/close the sheet. The issue is
that sometimes the saved sheet ends up with an 8 digit hexadecimal filename.
The users do not get an error and we don't see anything in an eventlog. Any
We read something about excel and the way it saves files. First to the hex
name, then it deletes the original file, then it renames the hex name to the
normal name. I have to assume something is m...Locating file://<filename>
My program needs to get the following file "file://<filename>.
Can someone advise where is actually located?
Is it the default folder, the root folder, the IIS folder.
Anyhow I couldn't locate the file .
> My program needs to get the following file "file://<filename>.
> Can someone advise where is actually located?
> Is it the default folder, the root folder, the IIS folder.
> Anyhow I couldn't locate the file .
Each process has a current directory. I would expect the above url to access
that directory. You can get it by ...Re: Unable to open Excel/XLS files with very long paths/filenames.
No one knows? :(
On 2/11/2010 1:29 PM PT, Phillip Pi typed:
> Does Office 2007's Excel have a problem in not being able to open very
> long paths/filenames? Excel says it could not find that file. I tested
> several scenarios:
> = 219 characters failed.
> D:\Users-Phillip-Pi-whatever-whatever.whatever.what1234-phillip-piSomething...Filename cannot be accessed
I am using Excel 97 with Windows 98. I am able to open,
edit and save Word 97 and PowerPoint 97 documents.
However, everytime I try to open ANY Excel 97 document, I
receive a message stating, "Filename cannot be accessed.
the file may be read only or you may be trying to access
a read only location or the server the document is stored
on may not be responding." I then have to save it
locally and work on it there. However, if I put it back
on the network, the same issue exists. Any ideas?
One possible cause.......
Excel stores in Windows\Temp(win98) fold...missing filenames in Excel 2000
All of a sudden, when I open workbooks in Excel 2000, I
can no longer see the name of the file that I am looking
at in the upper left hand corner of the display. The
bottom of the screen, containing the left/right scroll
arrows runs off the page as well. I have no idea why this
is the case all of the sudden but it is driving me crazy.
Anyone ever see this before and/or know how to fix this
prob? When I have several versions of the same
spreadsheet open in different windows I need to see the
filename so I know which version I am looking at. I no
longer have that luxury. Please h...how do i display the "path" and filename?
whats the function where it shows the location of the file?
Message posted from http://www.ExcelForum.com
try the following:
File path and file name:
File path only
File name only
> whats the function where it shows the location of ...Outlook 2003 hangs when receiving attachments with non-Western (Simplified Chinese) characters in the filename
We have a problem with Outlook 2003 hanging / locking up when receiving
certain emails. We have narrowed it down to emails with attachments
containing non-Western characters in the attachment's filename;
specifically, Simplified Chinese characters. I should also note if you
rename the attachment to remove the non-Western characters before
attaching/sending, there is no lock up.
If we use Task Manager to kill Outlook and relaunch, everything is fine
(meaning, the "suspect" emails are visible and they can be opened / read /
replied to / etc). The type of attachment appea...1 appended to Excel filenames
When I open a spreadsheet, a 1 is being appended to the end. For example,
when I open test.xls it is opening as test1.xls. When I hit Save I get a Save
As dialog box, as the file name does not exist yet.
see your other post
"Excel user" <Daniel Druff@discussions.microsoft.com> schrieb im
> Good day.
> When I open a spreadsheet, a 1 is being appended to the end. For
> when I open test.xls it is opening as test...Filename field path display with mapped drive
How do I get MS Word to display the complete path when I use the filename
field. When I check the box to include the path, it displays the mapped
drive letter and abbreviated path, not the complete path.
For example, MS Word 2007 now displays the path as
instead of the full path \\svr05\Documents\mfg\tooling guide.doc
I did not have this problem in Office 2003.
I'm now running Office 2007 and Windows 7
Quote from June 2009:
The registry setting described in
still seems to function in ...Automated way to Replace a filename link with a new filename
I have an Excel file that is a summary file of select pieces of dat
from 40-60 other Excel subsidiary files. Every month we add a few ne
files that need to be added on to this summary tab.
The thought process I was using was to do a macro that takes a row o
data linked to a template, copy & paste the row, then replace the link
on the new row from the template file to the newly created file.
I am trying to figure out a simple (BY SIMPLE I MEAN VERY SIMPLE) wa
for people in my group to be able to replace this link. I have create
a macro that does all of the steps (including an input box...Automatic filename generation template
Is it possible to make a template that will create a workbook with the
current date as filename if it doesn't exists, or just opens the file if it
Astrodude shared this with us in microsoft.public.excel.misc:
> Is it possible to make a template that will create a workbook with
> the current date as filename if it doesn't exists, or just opens the
> file if it does?
This is how I do it weekly: (and I'm too lazy to edit the code for
-----CODE STARTS HERE-----
Private Const mstrInitialen As String = "AVG"
Private C...Displaying Filename and File Path, best way to deploy to organisation Excel2K ?
What's the best and easiest way to deploy the ability to insert the Filename
and Filepath to our organisation ?
any help would be greatly appreciated.
Try a formula =CELL("filename",a1). This displays the file
name and path the next time the file is saved. Also see
help for the cell worksheet function. I don't think a1 is
critical, it just has to be a cell in the worksheet.
Hope this helps.
>What's the best and easiest way to deploy the ability to
insert the Filename
>and Filepath ...Filename length in Excel limited to 92 characters
Is the filename length in Excel (office XP) limited to 92 characters? I have
found this limitation today and do not no whether it is a bug or not.
Just tried this, I can easily go beyond 100 as the file name. Could be a
specific set-up on you ur machine.
Out of curiosity how does one end up finding that out? Are gonna save a
filename with more than 100 letters? if so why...what would the file be
called. (Totally curious here)
> Is the filename length in Excel (office XP) limited to 92 characters? I have
> found this limitation today and do not no whe...WaitForMultipleObjects, file change notification, filename
How do you get the filename that has changed on a FindNextChangeNotification
or am I using the wrong function?
I have done this before but lost the code. The examples I found using google
used ReadDirectoryChangesW, but I don't remember using that, I remembered
getting the changenotification giving me the filename.
I am using Visual C++ 6.0.
"amccombs" <firstname.lastname@example.org> wrote in message
> How do you get the filename that has changed on a
> or am I u...using excel to change filenames
i have several hundred files on my HD for a certain
program i use and i would like to change all of their
filenames, is it possible to import them into a
spreadsheet, manipulate the file names with some formulas
ans use the manipulated names to rename the files?
It's fairly easy to do it in DOS, but it would mean doing it one directory
at a time. Is that any use?
"spence" <email@example.com> wrote in message
> i have several hundred files on my HD for a certain
> program i use and i would like ...Macro for automatically adding filename without .doc
I have a document that I would like to embed the filename into the
The first page of the document has a blank header & the second page has
the same header as the remainder of the document.
I initially inserted the field [file name] with Uppercase but it
included the ".doc" at the end which I would like to remove. I looked
online and most sites say this can't be done. (Plus the field must be
updated to take effect)
Instead is it possible to insert a macro that upon saving the file
would create a text box in both headers with the filename and the last
4 lett...save as filename
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
I am using the above code to save on a click. However, I am pulling th
file from a toolbar on Attachmate EXTRA!. I have to open excel vi
c:\microsoft excel, but I want it to save to J:\agency.
No matter what I try, it keeps wanting to save to C:\My Documents.
Can anyone show me how to have this save to J:\agency?
Thanks in advance. Vat
Message posted from http://www.ExcelForum.com
Would this work?
Private Sub Worksheet_SelectionChange(ByVal Tar...How do I make the filename in a link variable based on a cell valu
Please bear with me - I am a long term excel user but I am new to Questions
and I may not have phrased this very well.. I am using Excel 2000 on a work
computer. I apologise if this has already been answered - I did see some
similar questions but none which explained how to do this.
I have made an application form spreadsheet to send out to new teachers.
When they are sent back they are saved in the same folder under teachers'
name, ie JohnSmith.xls, AnnabelleGreen.xls etc. Their data is compiled from
the form in a single column in a hidden sheet called Data in each workbook....Using Date in Filename
Can anyone tell me how I can use a date in a filename in an Excel Macro
I keep getting a problem with the "/" in the date and cannot see how to get around it.
Your help would be appreciated.
"Phil Amey" <firstname.lastname@example.org> wrote in message
> Can anyone tell me how I can use a date in a filename in an Excel Macro
> I keep getting a problem with the "/" in the date and cannot see how to
get around it.
> Your help would be appreciated.
> Philip Amey
Try a different ...Access 2007 Filename Length
In Access 2007, trying to import a legit dbf file which has a file
name greater than 8 characters produces an error.
Going to External Data, Import, More, dBASE file if you select a legit
dbf file with a file name greater than 8 characters, it gives you an
error "The Microsoft Access database engine could not find the object
'zeroreserves05q5'. Make sure the object exists and that you spell
its name and the path correctly." The error code is 503011. If that
exact same dbf file is simply renamed to 8 or fewer characters, it
I have not been able to find ...attachment filename "cut off" when printing
Is there any way to adjust the space allowed for email
attachments (icons and filenames) when printing? Most of
my attachment filenames get truncated followed by "..."
Is there any way when printing in memo style to print the
whole filename (upto X characters)--and even loose the
Thanks for any help--
...Problem with long filename in Win 98 while reading the filename from command line using function ParseCommandLine()
I am developing an MDI application using MFC. I am facing a problem
related to long file name in Windows 98. When I drags a file with
longer name of 8 characters (say abcdefghijk.txt), on the icon of my
application on the desktop. My application opens the file with modified
filename, eg. abcdef~2,txt.
This problem does not exist on Win2K.
Is their any solution to this problem ?
This is not really a problem. MS-DOS does not know if the target can handle l...Checking FileName
I want to have a macro that is utilised when my workbook is opened. What I
need it to do is, look at the current filename, if it is still the same as
the template filename, then bring up a message box that will have the option
of going to the save as.. function, or clicking cancel will just open the
book as normal.
If however, the name has changed from the original title, then it will just
load up without having a message box.
Any help will be greatly appreciated.
If you're really using an Excel template (saved as a template -- xlt file
extension), you won't need to do ...Retrieve filename question, again...
In an other topic I asked about how to retrieve the filename from an
Many solutions followed.
I tested many of them at home but, when i got to work they didn't work
When i use the function =cell("filename") and i type this into the
function wizard, it gives "volatile" as result.
When i continue and enter this in a cell, it shows.. nothing...
Does this have anything to do with the fact that the title of the
spreadsheet is generated by a database program?
We get these excel files from within a Lotus Notes environment.
Let's say i have this spre...What does the [Group] designation mean, next to my filename?
I cannot find why this [Group] designation appears next my filename? Seems
to be disallownig me to change print areas, and other settings??
You have more than one sheet selected. Right click any sheet, and if
available, select the "Ungroup sheets" option.
Juan Pablo Gonz�lez
"email@example.com" <firstname.lastname@example.org@discussions.microsoft.com> wrote in message
> I cannot find why this [Group] designation appears next my filename?
> to be disallownig me to change print areas, and other sett...