I can open and save the Excel file if I use a mapped drive path, but not if i open it using the full path.
e:\sales\file.xls works fine, open, saves, re-opens.
\\server\sales\file.xls opens, saves and is then its corrupt.
I've experimented with this and its a consistent problem on 3 computers with various excel (2002, 2003 Small Buisness, 2003 Standard) versions and xp service packs (SP1, SP2, SP3). I also tried differnet opening methods, double click on the file vs excel>file>open>browse... and the only consistancy seems to be the path name. Has any one ever heard of anything like this?
To add a bit more info, this file starts as a template and our off site salesmen fill it out and e-mail it in. The problem only occurrs with files from one of our 8 salesmen. We've re-installed MS Office and updated all his software, but the problem presists.
Hi, everyone,
Please let me know any tips to reduce the size of an excel file. I'm have a file with several modules which generates an end report. I wanted to reduce the size of the file I remove the modules from the end report though...Is there anything else that I can do apart from this to reduce its size
Hi guys,
I am about to undertake a fairly large spreadsheet development project. One of the key requirements is that the size of the spreadsheet be kept to below 4mb, preferrably below 1mb. This is due to an unavoidable restriction.
Although the spreadsheet will not have large volumes of data, it will contain approximately 30 sheets. There are no graphics embedded in the sheet. I imagine there will be a reasonable amount of VBA and/or forumulas in the sheet. Each sheet will basically be a data-entry form with a number of formulas. No sheet will have more than 100 rows.
Without knowing the full details of the spreadsheet, it is difficult for you to give a definite answer as to the size of the sheet, so I am simply looking for some helpful tips in keeping the size down.
Do formulas take up more space than VBA code? When I format cells, should I format the entire row, or just the range? Do features like sheet and cell protection take up a lot of space?
Any other tips or suggestions?
I have installed an add in called RapNet06 that runs a macro to download diamond prices from an online price list that is periodically updated. Usually I will go to Add-Ins, click Fill in Rap prices and it will insert a column with prices based on the data already in the spreadsheet. However, somehow I have done something that has changed the filepath the macro uses to a network folder that it cannot locate. I have uninstalled the add in and then reinstalled it but it still points to the incorrect network folder.
So, my question is, how can I manually change the file path for an addin in Excel07? When I go to excel options/ Add-Ins the Rapnet06 add in is not listed... Any help is greatly appreciated!
I'm having a littl edifficulty getting Excel to dynamically update from an
XML file. The XML file is generated from a program and I would like the Excel
file to dynamically update.
Problem is that the location of the XML and Excel file can change, that is
they can be anywhere on a hard drive but both are in the same directory. The
mapping of the XML file in Excel appears to be a complete file path
C:/data/report/.... but the location could change. They could be in
C:/data/report/run1 or run2, I don't want to have to re-map each time a
report is generated.
Ideally I would like to remove the directory specific path and use a
directory relative path. This way the XML file and XLS file can exist in any
directory and still update correctly.
Ofcourse, both files will be in the same directory when they are moved.
So my question is, can we change the path to teh XML file?
I'm using Excel 2003 (11.5612.5606) Office Pro.
I just wanted to know how I could obtain the file path for an excel file that is already open.
In Excel 2003 I could see the full path name of my files by using the Web toolbar. It contained a window with the path name in it. I could copy this path and paste to emails as a direct link to shared files.
How can I view the full path name is Excel 2007? I have looked all over the ribbon and in the custom commands with no luck. Please help me out as this has become a fundamental part of my Excel usage. Thank you.
Hello
I am using an excel file (as bill of materials) embedded in many dwg files (Autocad files). This file contains VBA code that export data in another excel file.
I export data from different autocad files to an xls file (on disk).
My problem is: I cannot extract the path for excel embedded files (excel VBA returns ""). I need this path when users work at different jobs with different dwg files in the same time.
Do you know how to extract the path (for excel embedded file or for dwg file that contain an embedded excel file) from excel VBA code?
At this moment I use a lisp routine (for Autocad) that returns the dwg file path when an dwg file is open, but there is a problem when I open another dwg file (returns a new path).
Thanks
Hi Folks
Is there a way of changing the default template in Excel so that it will always put the file name, path and sheet name on in the Header/Footer section or is it necessary to record a macro to do this.
thanks
Shirley Munro
