Transferring toolbars and macros to other computers
Is there an easy way to transfer a toolbar setup and all macros from one
computer to another?
Macros can be in any workbook. They would travel with the workbook.
Also in Personal.xls for global macros.
Also could be in any add-in(s) *.xla you created.
Toolbar and Menu customizations are stored in your xxxxxx.XLB file where
xxxxxx is version-dependent name.
Note: there may be other customizations you want to transfer at the same time.
Before reading further.......
Transferr...Opening/linking .xlsx files
I have had trouble linking new .xlsx files to my existing .xls files. Excel
would shut down. So I started saving all my files in the old .xls format.
I recently created a new file using .xlsx, but when I try to reopen it,
Excel shuts down.
Are you able to open Excel 2007?
Try to create a new file and reopen it. If this does not work then try...
Close Excel first and On the Windows Taskbar
1) Start->Run-> excel.exe /unregserver ->OK.
2) Start->Run-> excel.exe /regserver ->OK.
See the space between exe and /regserver
You might have to design...List of files
All I want to do is get a list of files in a directory so
they can be deleted. How do I get this list ?
> All I want to do is get a list of files in a directory so
> they can be deleted. How do I get this list ?
You can use FindFirstFile/ FindNextFile/FindClose API functions for
If you want to remove directory with its content take a look at
SHFileOperation in MSDN.
Kobi Ben Tzvi
"John" <email@example.com> wrote in message
> All I want to do is get a list of files in...Transfer Files Using VBA
I'd like to transfer files from several drives on my pc to one cetnral
My routine now is the following
1) Copy the files from drives: A, B, and C; and then
2) Paste the filesto the D drive
3) Delete the files permanently from drives A, B, and C.
As you see this is a tedious routine, which I'd liket o avoid by using
VBA. Can someone start me off with some code on how to accomplish
this. Thanks so much in advance!
You could create a batch file (from the olden days) using XCOPY and desired
bel...Do I have to put my files on a server to hyperlink in Publisher?
For a class project, we need to make a website. However I do not want to go
live with the site (publish the site) for security purposes.
Is there a way I can just make the hyperlinks for my files open without
having to be on a server? The instructor wants a working but not live site.
If you are using Pub 2003, the built-in navigation bar uses relative links
that will work on your local machine. Under Help type "navigation" for more
Assuming you use the default setting, when you Publish to the Web, you can
direct the html output to a folder on your computer. T...Importing QFX files
One of the financial institutions that I deal with provides downloads only
in QFX format, not OFX. Is there anyway to import QFX into Money 2005 Standard?
On 2005-04-29, firstname.lastname@example.org <email@example.com> wrote:
> One of the financial institutions that I deal with provides
> downloads only in QFX format, not OFX. Is there anyway to import
> QFX into Money 2005 Standard?
I don't know the answer to this question, but this guy seems to
think that it doesn't really matter. According to him, QFX is OFX
with Quicken extensions. I don't know whether Money will ...How do I get focus back on an Excel file?
When automating Excel, if there is a picture (graphic) on the worksheet, when
the file is opened, the picture has the focus and mouse-clicks anywhere on
the Excel window are lost. Is there a way to get the focus back so that
other cells can be editted?
Insert this line of code into the macro:
You could also rework the code to avoid selecting the shape in the first
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
"Stumpiana" <Stumpiana...Exchange no longer available
Courtesy of Katrina, my brother-in-law's job and Exchange server are no
more. He knows he has personal folders and contacts on his laptop,
but Outlook choles on not connecting to Exchange and won't let him see
the local stuff either.
How does one tell Outlook not to try to connect to Exchange and instead
use the local pst file?
It might be easier to create a new profile and then use File Open to access
the personal folder file, you create a new profile in Control Panel || Mail
<firstname.lastname@example.org> wrote in message
...Clearing Log Files
What is the method for clearing exchange log files. These
file take up more space than the database.
I suspect the files you are talking about are the Transaction Log files.
These are important files and need to be managed correctly. Performing an
online backup will truncate these logs. Or if you don't require backups
then turn on circular logging.
Here's some more info..
"Bill" <email@example.com> wr...'Recently used file' list.
When I open Excel nine filenames appear on the RHS as 'recently
used files' (this number was set via Tools/Options/General, of
course). In the middle of this list are 3 no-longer-used files.
Though the files themselves have been deleted their names remain in
Is there an easy way to remove those entries from that list,
There is an entry in the help file "Display or hide recently used workbooks
on the File menu" which says uncheck the 'recently used files' checkbox, the
click OK. Then, basically, start again.
"DB.&...How to use excel file created in version earlier than 4.0a in 4.0
Thanks to whomever answered my query but when I opened the email the screen
was blank. My laptop is sick. My question was and still is, how can I use my
Excel files created in a recent version on my laptop in my PC which is loaded
only with Excel 4.0a . Please and thanks.
You can't, the file format changes twice since version 4. You need a newer
Excel version, a compatible spreadsheet program, or simply a viewer if all
you want to do is view / print the file.
HTH. Best wishes Harald
"ajimmo" <firstname.lastname@example.org> skrev i m...Money 2004 Standar can't convert Money 2000 Delux File
I just installed Money 2004 Standar on XP. I just buy It.
I used to have a Money 2000 Delux version.
When I try to convert my data file (from Money 200), the
program makes a copy of the
file with the extension "MN8" and then stops with the
"Money cannot covert the file. The older varsion is not
Is there any way I can convert my Money 2000 Delux file
into a Money 2004 Standar file?
...How can I convert Outlook 2007 Rules files (.rwz) to something editable?
I want to manage the rules a little simpler than with the built-in rules
wizard. I can export the rules to a .rwz file.
- Is there a description someplace of the .rwz file?
- Is there a simple script or tool to convert to a .rwz file to a
.csv or some other format? A perl script, VB, etc. would be fine.
AllBackJack's Profile: http://forums.techarena.in/members/160330.htm
View this thread: http://forums.techarena.in/ms-office-support/1277903.htm
...Long File Path
Operating System: Mac OS X 10.5 (Leopard)
Hello, <br><br>When I try to save my Excel worksheet files somewhere on the HD, Excel comes back with an error message saying "The file path you entered is too long". I do not want Excel to tell where to save my files! Anybody can help? <br><br>Thanks! <br>
Excel is most likely telling you nothing of the sort -- OS X is.
Make sure you have Office & OS X fully updated then run Disk Utility -
Repair Disk Permissions. If you continue to have a problem you...XLSX Files Will Not Open
Using Windows 7 / Excel 2007. I can open old xls files using Excel 2007 but
can not open any xlsx files. When I select an xlsx file to open, a new blank
worksheet opens instead of the selected file. The "ignore other
applications" box is unchecked as recommended in other posts and I have
re-installed Office. Neither solved the problem. Please help. Kind regards,
...Help, how do I get an exe file with outlook 2002.
is there a way to turn off the GD stupid F#@$ing level
one interecept "feature" in outlook?
I am so angry with this stupid program@!
I need to download an exe file and cannot with this
Maybe if you washed your mouth out with soap, someone would be willing to
help you. This is a technical forum -- not a place for ranting fools.
"Sean" <email@example.com> wrote in message
> is there a way to turn off the GD stupid F#@$ing level
> one interecept "feature" in outlook?
> I am so angr...Can I move the data files?
I just installed Money 2005. I let it take most of the defaults, It
choose to store the data files in \My Documents. I would like to move
all of them to \My Documents\My Money.
Is there a way to do that?
Simplest way is to use My Computer or Windows Explorer. Navigate to your
..mny file, click on it, click on edit > copy, navigate to where you want the
..mny file to live and click on edit > paste.
When the file is in it's new home, double click on the file name. This will
call up Money and this will then remember where it found the file.
Now go back to the original locati...File Conversion Question
backup.pst Outlook 2003 version
Can this be converted to be restored into Outlook 2002?
What other possible solutions could be employed?
firstname.lastname@example.org <email@example.com> wrote:
> backup.pst Outlook 2003 version
> Can this be converted to be restored into Outlook 2002?
Only by using Outlook 2003 to create a 2002-format PST and then copying or
exporting the data to the 2002-format PST.
>...How do I reduce the size of an exel file?
I am currently up to 80mb and am using Excel 2002. The file has multiple
users with pivot tables. It would be a huge endeavor to reset all the pivot
tables. Is there any other trick that will help reduce the size of the file?
> I am currently up to 80mb and am using Excel 2002. The file has multiple
> users with pivot tables. It would be a huge endeavor to reset all the pivot
> tables. Is there any other trick that will help reduce the size of the file?
What does the file contain and what do you mean by "multiple users with
Inter...File Hiearchy.Any Tips?
I have taken possession of a new XP machine
and things seem a little different from my last XP
that crashed and burned.
I am trying to organise my file hierarchy with something like
500,000 images in say 1000 folders.
I have them in My Documents, but oft times windows explorer
ends up in a mirror folder tree under C:\ drive
It feels awkward and troubling,
any ideas how to set up a stable file tree in xp please?
Should I move these files to the root drive C:\ only?
Thanks very much in advance.
> Links etc?
> I have taken possession...Spreadsheet File Size
I have a Spreadsheet that has 10 tabs at the bottom. Each of thes
sheets cross reference dataand thee are many complex calculation
throughout. Many of the formulas are nested IF functions which I kno
take up a lot of space. The unfortunate thing is the file size is 7
MB, which is hard for others in the office to work with.
I would appreciate any ideas as to how I could reduce the file size.
- Is there a way or someone who could look at this and kind of audi
it to see if there are ways to reduce size?
- Should I break it up into seperate files (shich would be harder fo
other ...Translation: .123 file extension to Excel 2003?
I received a file with this extension - more familiar with.wk_, extensions-
can't translate to Excel. Please advise me - Thanks
...Trying to get a type of video file format to open and run on my we
I created a video using Windows Movie maker and saved as .wmp file. I saved
it to my computer and then inserted on my web page under Front Page 2003.
Nothing! I then converted the file to avi format - still nothing! I then
tried mpeg4 still nothing. The manual is next to useless on this subject.
Anyone tell me what I need to do so that when a user opens up the page the
video plays automatically.
Save as a .wmv and insert a suitable player into the page.
For IE only,
Insert->Web Component->Advanced Controls->ActiveX Control
Choose Window...can not open lib file
if a try to compile a porgramm i get always
the rror : LINK : fatal error LNK1104:
Datei "TranslationController.lib" kann nicht geoeffnet
werden --> can not open the lib ....waht do i hier wrong
You need to locate the .lib file, and make sure msdev is looking for it in
the right place by looking in Tools->Options + Directories tab.
"Marc" <firstname.lastname@example.org> wrote in message
> if a try to compile a porgramm i get always
> the rror : LINK : fatal error LNK1104:...Using Jet to read excel file returns blank for last cell
With VB6 I am opening an Excel file to query the contents using ADO. I am
then using the contents of the worksheet to create a format file that is used
for a bulk insert into SQL Server. We designed the program this way so that
users can use a spreadsheet to import data in any format they want and
process the data based on values set in the spreadsheet. This keeps us from
having to design new tables and format files for new record layouts which
come down pretty often. Everything works fine usually. There is just one
perculiarity that is happening with the Excel file. Sometimes, th...