Help: Formula put into entire row creates large file size
I have a spreadsheet where I would like one column to be the
concatenation of two other columns.
For example, in column C I would have =A1&B1.
This excel file will be given to people and they will fill in values
into columns A and B. The trick is, I don't know how many rows there
will be, so I don't know how many rows in column C should have this
If I paste this formula into the entire column C, the excel file blows
up to 3 megabytes. (It's only 15KB without this column).
Are there ways for me to accomplish this more efficiently?
Thanks for any help
Are y...Hyperlink to folder on Save
I'm losing the link to my folder when I save my worksheet having set it up a
hyperlink. I've tried switiching off 'update links on Save' in the Web
Options which seems to work OK but when anyone else opens the file form
another network PC, the link is lost again when they save the document. Is
there anyway I can lock the hyperlink down so the address doesn't get aleter
when its saved on other network PCs?
Try using the HYPERLINK() function instead
Jacob (MVP - Excel)
"F...Save charts as Windows Metafiles
This has undoubtedly been asked before, but:
Is there a method, plug-in tool, VB script or something that enables
you to save Excel graphs as WMF or EMF files? Without first
copy-pasting it into some drawing program and saving it there?
Ideally, one would copy the graph to the clipboard, and then be able
to access a dialogue direclty from/in Excel that lets you save it as a
Thanks for any suggestions you can provide!
...Corrupt Access 2003 File
I was working on this file earlier today, I even just opened it and it was
fine and all of a sudden there is a write delay to the save the file, I
closed it and I try opening it again and it is corrupted. I don't get it. The
message I am getting is below. What does that mean. I just finished making a
lost of update to the file. The last time I backed it up was Tuesday, and I
have done a lot of work to it between then and now. I don't have the time to
go back and redo all that work again. Any help will be appreciated.
"Microsoft Office Access has detected corruption in this ...Want More Cash in a Day then most People Make in a Week?
Be glad you opened this message.
One simple click of your mouse is simply going to fill your wallet.
is a dream for any one trying to market a business.
Because we give you more leads than you can handle and pay you to do
Yes you heard right, we will pay you for getting tons of people
As top marketers we just leveled the playing field.
Now any Average Joe can use our system get paid and become a top
of any company.
When you see are videos and our virtual spokes people you will fall
off your chair.
You are going to get your hands on a system t...Querying MS Access from C# on stored file paths
I'm storing some particulars about file usage in my MS Access
database, incl. the full paths of those files. I tried to query the
database in my C# code. My idea was to retrieve from the database by
means of SQL when a file was used the last time, but I only know the
directory it is in, so in my code I tried to construct a WHERE clause
as follows: String whereClause = "WHERE Filename LIKE '" + dirpath +
Of course I'm working on Windows and I don't want to think of
portability now. Obviously, the variable dirpath contains double...help
I have some texts files, which i want to read in each line, and then
write back each line to a new text file.
So for example, I want to read in the 2 lines below:
I store each line of data in the following vector:
So FileData =3D ""C:\Data\=D3=EA=D2=B9=D0=C7=BF=D5",6,10,3,3,8"
FileData =3D """,0,0,0,318.592,83.04552"
(the data is in the vector correctly)
Then I go to write the data to a new text file...
FILE ...Copying Subtotals?
How do I copy just the subtotal information to a new worksheet?
If you are just copying the information over, just copy it and on the new
worksheet, do a paste special onto it
"Robin Funnell" <Robin Funnell@discussions.microsoft.com> wrote in message
> How do I copy just the subtotal information to a new worksheet?
On your subtotaled page, summarize to the level that you want to copy (by
clicking on the numbers on the upper left).
Select all of the rows. Then select Edit - Go to, hit the ...Converting XLS file to QIF or to OFX
How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
> How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
In Excel, save the file to CSV and ustilise iCreateOFX Basic from:
to convert the saved CSV file to OFX.
...Copying a worksheet and retaining values (not formulas)
I have a comprehensive sales spreadsheet setup which
reads raw data from my PC, collates and calculates, and
displays a summary sheet.
This summary sheet is fine as long as it is on my PC, but
sending it to others who do not share the source data
means all the links are broken.
Rather than give access to the links, I want to create a
file containing the actual calculated values, layout and
formatting, for sending to others.
Can this be done? (and if so, how!)
Right-click on sheet tab, select 'Move or Copy', check 'Create a Copy' and
select 'New book'...execute batch file does not execute all command lines
I am using the following code to execute a batch file which contains
multiple commands, each on a separate line. Each command-line creates a
file. What I am finding is that only some of the files are being created ( 7
out of 11 ).
If I then run the batch file directly ( either by double-clicking, or
pasting its path into cmd.exe window ), all files are created ( 11 out of
private void executeBatchFile(string pathBatchFile,
...Precompiled headers and source files in subdirectory
Hello, I'm using MSVC++ 8.0 SP1 on WinXP Pro and I have a simple,
app-wizard generated MFC application. It was using precompiled headers
to speed up build times (as is the default), but when I tried to move
the c++ source files to a subdirectory "src" to in the project/solution
directory, I can't build the program anymore without disabling
precompiled headers. I get these errors:
error C2859: c:\coding\msvc\toolbar-demo\debug\vc80.pdb is not the pdb
file that was used when this precompiled header was created, recreate
the precompiled header.
error C2859: c:\coding\msvc...What's the name of the file that stores AutoComplete addresses
My Outlook had to be re-installed and I lost my contact list which is very
large. I see several files in the recycle bin. Is one of them by contacts?
Autocomplete cache is an NK2 file, named for your profile, often
Paste the following line in the address bar of windows explorer;
and it will open to the folder where its stored.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
mailto:dailytips-subsc...Opening Text Files and Re-Saving Them
I am trying to write some code which will allow a user to select a folder
and then will open all of the text files in that folder and re-save them as
I have sorted out the code to enable the user to select the folder they wish
to use, but am looking some assistance on the looping to enable each of the
text files to be opened and re-saved.
Can anyone suggest how I might do this.
If the text files are all the same, you could record a macro that Opens, saves
as an excel file, and closes the file.
Then that recorded macro could be modified to open...the system cannot find the file specified outlook 2003 #2
Attachments show up in emails, but when you try to open
them, the messages comes up "the system cannot find the
file specified", but other recipiants on same email can
...how do i forward an e-mail?
I have one new employee, that can not forward a fax from a public fax folder,
but can forward e-mails from his e-mail account? Here is the error I keep
You do not have permission to send to this recipient. For
assistance, contact your system administrator.
What rights do they have in the public folder?
> I have one new employee, that can not forward a fax from a public fax folder,
> but can forward e-mails from his e-mail account? Here is the error I keep
>...Missing Fonts when saved in PDF
On occasion, when I save my publication in PDF form, the fonts will change.
Are there certain fonts which are not allowed? How do I get them?
Not all fonts can be embedded. There's nothing you can do about that except
to use fonts than can be.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"bellarush" <email@example.com> wrote in message
> On occasion, when I save my publication in PDF form, the fonts will
&...ftp server or I can saved from Ecxel? #2
I need to fine out how to save a hml workbook onto my website do I need to
use ftp server or I can saved from Ecxel?
...trouble opening office 2003 excel files
Operating System: Mac OS X 10.6 (Snow Leopard)
I am having difficulty opening Excel files that were created in the 2003 version withthe 2008 version. The files were originally created on a windows XP machine, then imported into a Mac using Office 2003 under system 10.4. The files are rather large, approximately 60 columns by 10,000 rows. I haad no difficulty in working with the files between the Windows and Mac systems. I recently got a new MacBook Pro with an Intel processor and installed Office 2008. When I try to read these large Excel files on my new lap...copy an e-mail
I sent an e-mail to my e-mail office address with the
intention of forwarding it tomorrow morning, I then
realized I forgot to edit a very important part of it.
Is there a way I can edit an e-mail that was sent to me
by myself from another locale then forward to others in
...odd files created
Every time I open and edit an excel spreadsheet on a
network share, small odd files get created. They are
usually no larger than 25-40k and don't have any
extensions to them. Looking at the properties page for
any file, the file description says File. Anyone know
what this is from or how to get rid of them? Permissions
are setup correctly for me, Word files don't have this
Excel 2000 SP3
A file the same size as the workbook would be created
in the same directory as the workbook. The filename
would be nonsensical (or appear to be random) character...Supported File Attachment for Faxes
What are the supported file attachment types for fax activities?
So far I've gotten simple text files and Bitmaps to attach properly,
but Word documents do not work.
Is this completed undocumented or what?
If you are attaching a file under the Notes tab, you need to save your fax
activity first then you can attach the file.
Hope this help,
> Is this completed undocumented or what?
It does'nt work with Word attachments, it only works with .txt files.
But it can't be this is what MS wanted.
Can anyone p...How do I transfer files between computers in OE?
I use two computers to access my mail and there are files
I have on one machine I need on the other. Backing up
does not work Help
Please take a look at Microsoft KB article OLEXP: How to Back Up the
Outlook Express Address Book and Mail Folders Microsoft Knowledge Base
Article - 188854
This article gives you information on how to Backup the OE files and how to
import to your new system...
Please let me know has this helped You...
This posting is provided "AS IS" with no wa...Copying a worksheet into the same workbook
Hi, and thanks in advane for the help!
I would like to know how to copy an existing worksheet and automatically
rename it from a cell within that sheet into the same workbook. I have
searched but not found what I want to do. I think it has to do with the
newsheet event but not sure how to do it.
Try this for the activesheet with the sheet name in B3
On Error Resume Next
ActiveSheet.Name = Range("B3").Value
On Error GoTo 0
Regards Ron de Bruin
"Michael&...Copying a image
Using a form in access 2002
I need to browse to a jpg image and copy that image to a folder. I have a
command button to named browse but I can not get the code correct.
You've provided not much info, so therefore some questions:
Is the jpg file name and location known or does it change every day/hour/week?
Is the destination folder known or does it change too?
Here's what I would do:
1) retrieve the source folder path - that info is either stored somewhere in
your database or use the return value of the open file dialog
2) if the jpg file name is stored somewhere in y...