Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Copy of file Results

I have a text file created and wish to create a MS-Excel spreadsheet
w/columns the 1st column should be static while the row could have
variable data to append. Any ideas/scripts to share will be
appreciated.

Sample File:
Client: PSHBGMCGAPP01
Backup ID: PSHBGMCGAPP01_1101705374
Policy: McGregorServersDailyBackup
Policy Type: MS-Windows-NT
Sched Label: MonthlyFull
Schedule Type: Full Backup
Retention Level: 6 months (6)
Backup Time: 11/29/2004 00:16:14
Elapsed Time: 000:36:58
Expiration Time: 06/03/2005 01:16:14
Compressed: no
Encrypted: no
Kilobytes: 11845986
Number of Files: 26292
Primary Copy: 1
Image Type: 0 (Regular)
Keyword: (none specified)
Ext Security Info: no
File Restore Raw: no
Image Dump Level: 0
File System Only: no
Object Descriptor: (none specified)
Multiplexed: no
TIR Available: no
Backup Copy: Standard (0)

Client: PSHBGMCGAPP01
Backup ID: PSHBGMCGAPP01_1101531734
Policy: McGregorServersDailyBackup
Policy Type: MS-Windows-NT
Sched Label: DailyIncremental
Schedule Type: Differential Incremental Backup
Retention Level: 6 weeks (2)
Backup Time: 11/27/2004 00:02:14
Elapsed Time: 000:11:15
Expiration Time: 01/08/2005 00:02:14
Compressed: no
Encrypted: no
Kilobytes: 369501
Number of Files: 2202
Primary Copy: 1
Image Type: 0 (Regular)
Keyword: (none specified)
Ext Security Info: no
File Restore Raw: no
Image Dump Level: 0
File System Only: no
Object Descriptor: (none specified)
Multiplexed: no
TIR Available: no
Backup Copy: Standard (0)

Required output:
================================================== ==============================
Col 1 Col 2
Client: PSHBGMCGAPP01 PSHBGMCGAPP088
Backup ID: PSHBGMCGAPP01_1101705374
PHSNSNNNS01_1919
Policy: McGregorServersDailyBackup XXXX
Policy Type: MS-Windows-NT XXXX
Sched Label: MonthlyFull XXXX
Schedule Type: Full Backup XXXX
Retention Level: 6 months (6)
Backup Time: 11/29/2004 00:16:14
Elapsed Time: 000:36:58
Expiration Time: 06/03/2005 01:16:14
Compressed: no
Encrypted: no
Kilobytes: 11845986
Number of Files: 26292
Primary Copy: 1
Image Type: 0 (Regular)
Keyword: (none specified)
Ext Security Info: no
File Restore Raw: no
Image Dump Level: 0
File System Only: no
Object Descriptor: (none specified)
Multiplexed: no
TIR Available: no
Backup Copy: Standard (0)

Periodically, I need to extract data from one of my email inboxes. To
do so, I open Excel. From that, I open the desired inbox from my email
program. Excel opens it just like it would any other text file -
sometimes.

Here's my question. The process works flawlessly from my laptop which
has Excel 2000 v.9.

However, from my desktop, which has the same email program version, but
a newer version of Excel (Excel 2002 10.xxx SP-1), it doesn't work. I
copied the inbox file that opens fine on my laptop to my desktop. When
I try to open it from my desktop (with the newer version of Excel), I
always get an error message which says, "(Name of file) is not a valid
Web Archive."

I don't know what Web Archives have to do with any of this and all of
the available Excel converters which come with Microsoft Office have
been installed on the machine.

Any idea how I can get Excel 2002 to stop creating these error messages
and actually open the file?

Thanks

--
orutulsa
------------------------------------------------------------------------
orutulsa's Profile: http://www.excelforum.com/member.php...o&userid=32454
View this thread: http://www.excelforum.com/showthread...hreadid=522277

Howdy.

I'm trying to figure out the best way that I can have Excel
automatically insert a new worksheet when I enter data on another
sheet -- be it a worksheet function, macro or something else. This is
really two questions:

1. I have a "master" sheet in the document called ProjectList, and
then a bunch of sheets called Project_# with incrementing numbers for
projects as they are created. I'd like to be able to make it so that
as I enter text for new projects in the ProjectList sheet, a new
Project_# sheet (with the appropriate # as I entered it on the
ProjectList sheet) be created from a template. Excel probably isn't
the best tool for this, but I'm trying to work within constraints that
say Excel is the tool of choice.

2. I've figured out how to use macros to insert blank sheets, but I
haven't figured out how to get it to insert a sheet from a template
file. If I can't do it from a template, I can have a sheet in the
workbook that I leave unmolested, such that I can have the
macro/function make a copy of it -- if that's doable and working from
a template isn't.

The ideal solution would have it so I can have a user enter data in
the master sheet, and new sheets based on a template be created
automatically. If that's not workable, then I'd settle for a macro
button that would insert sheets using a template as the basis. If the
latter is the most workable solution, then the user should be asked
for the number of the project, such that the sheet would be named with
Project_ and that number.

Thanks for any suggestions you may offer about this. I have a fair
solution doing it manually right now, but I'd like to make it even
simpler for others to use.

Thanks.
Mark

Hello
Sometimes when I open my file do my work and then close it, a read only copy
of the same file has opend. During the time I have the file open this read
only copy does not sho up on the task bar or in the task list. How can I
find out what is opening this file?
Thanks!

Is there a way to copy a file automatically on opening it, before any changes
are made to it (to be used as a failsafe in case the user does not save it
before opening it or before they open and change it, and then want to use it
again)? That is, I want to email a file to someone and, when they open the
file, I want a copy of it to be made automatically, so they will have it to
use again at another time. (I don’t know if it would make any difference, but
a macro is contained in this file.)
--
Dolores

Hi All,

Lot of excellent help here - I am almost there - Please help me
connect the dots...

OK - what's the problem: * I will try to keep a version control of a
template I develop on an ongoing basis. The version number I will try
and use to provide an easy way to upgrade any file based on an older
version of the template by simply copying values that reside in cells
that I see on a list of named ranges into a file that is a copy of the
new template.*
- Does this make any sense...

How do I do this - I am not sure - I need help - here are my
thoughts...

My idea of an answer is this:
1: I will use the version control suggested by Tom Ogilvy in
http://www.excelforum.com/showthread.php?t=479156
And keep the version number in a property named "Version".

2: I have a hidden sheet named "config" in which i have an ongoing list
of cells holding the names of all the ranges that must be copied. The
list of named ranges is right below the cell named
"Config_values_to_copy", so
range("Config_values_to_copy").offset(1,0).value could be
"Priority_Column" in which case there is a column off values there,
that must be copied to the new template and placed in the same named
range.

3: I will keep the newest version of the xls-file (template) - not as a
xlt file, just xls for now somewhere - on the LAN in a specific folder
and always have the name of the latest version being: "Risc and issue
documentation Template, latest version.xls" (If possible I will
manually include the version number into the file name instead, and
make sure that there is only one file in the particular folder.) For
this help let's just say that the folder is local
"C:latest-version-template" I think that this can somehow be done
based in parts on the answer Ron de Bruin gives to this topic
http://www.excelforum.com/showthread.php?t=564858 - but I am not sure
that it is all there...

4: When a user opens a workbook based on the template a control button
named something like "check for new template version" should be
accessible - alternatively I will hide the code and do this when the
user opens the file.

5: Now here goes: The code must somehow check current version from step
(1) against the version found in the folder with the latest-greatest
version of this template. If the template available in that folder is
newer than the template that this current file is based upon, then
prompt the user if he wants to upgrade. If YES then I must somehow
iterate throught the named ranges and copy all the values onto a copy
of the new template and afterwards save this intelligently on the users
harddrive.

I imagine using this kind of iteration to go through the named ranges -
this code is altered a bit from elsewhere in the file:

i=1
While Len(Range("Config_values_to_copy").Offset(i, 0).Value) > 1
' As long as I am in this loop, then I have values that must be
copied to the new workbook.
[new workbook!] Range(Range("Config_values_to_copy").Offset(i,
0).Value).Value = Range(Range("Config_values_to_copy").Offset(i,
0).Value).Value
i = i + 1
Wend

Can I do this - how do I copy a version of the newer template and paste
the values (by value) into the identical named ranges? Probably the line

[new workbook!] Range(Range("Config_values_to_copy").Offset(i,
0).Value).Value = Range(Range("Config_values_to_copy").Offset(i,
0).Value).Value

needs some re-work. I just cannot see precisely what I need to do.

I look forward to some quality help.

Bye from Denmark

Soren

--
handstand
------------------------------------------------------------------------
handstand's Profile: http://www.excelforum.com/member.php...o&userid=37818
View this thread: http://www.excelforum.com/showthread...hreadid=573788

Hi,

Situation: I open Excel 2002 (XP), choose a file to open (eg
"myfile.xls") and work in it.

I save a copy via File / Save as. I name it "mynewfile.xls" and click
OK.

File correctly saved; the original still exists on disk. The filename
appears correctly in the File menu in the list of recently used files.

But: the information in the Excel's title bar didn't change: it still
displays the filename of the first file.

If I understand Excel well, it saves a copy of the original file to a
new one, and keeps working with the new one. So the new filename
should appear in the title bar.

I continue working in the new file; I close Excel, open it and open
the copy (mynewfile.xls), all changes I made after the first "save as"
are well kept and saved, and now, Excel displays the correct filename
in the title bar.

Has anyone an idea how to correct the issue with the title bar
information which isn't changing after a "save as"?

I use Excel XP SP3 English (10.6713.6735) and have full local admin
access on my PC / all xls files are stored locally.

thanks in advance for any reply, information, tip or solution!

Dominic

I am using the following statements to copy a file from one location to
another and getting an error message "subscript out of range" on the FileCopy
command. (Note: I used a bunch of debug.print statements to determine the
offending line).

Dim ofsFileSys As New FileSystemObject

If ofsFileSys.FileExists(SourceFile) Then
FileCopy SourceFile, DestinationFile ' Copy source to
destination
end if

Both the Source and Destination files exist on the same network drive.

The SourceFile is being created by a data acquisition system and is updated
every few seconds. My macro is programmed to copy the latest SourceFile to
the DestinationFile every 20 seconds or so and grab the latest data entry
from the newly created DestinationFile.

For the most part, the macro works fine. But every so often I get the
"Subscript Out of Range" error message associated with the FileCopy command.
I cannot go into the debugger and repeat the error, since it seems to occur
randomly.

I suspect the problem lies with copying the file and the same time it is
being updated, but I don't know enough about how files are handled by
Windows.

Any ideas as to what may be causing the problem or suggestions of what to do
about it would be appreciated.

My operating system is Windows 2000.

Thanks for your help,

Jim

Hi experts,
My program saves a Excel file after some operations. It works well normally.
However, If the file is opened before running the VBA, It fails and provides
such messages like "The file aleady exist, do you want to replace it"?

I think somehow the program is working on a copy of that file if the file is
opened by someone. How can I ignore such annoying message using VBA? I have
to deal with this case since it is normal that the user want to see the file
while the program is running.

Thanks a lot and regards
Shu

I would like to get the text in a cell in one file and
paste that text as comments to a second cell in another
file. Have tried a number of things but no luck!!

Wayne

One thing - make sure that if saving to a network share you have read, write
and delete permissions. If you don't have delete permissions you cannot save.
(Excel creates a temp file first, then saves, then tries to delete the temp
file. If the temp file cannot be delete you won't be able to save)

Steve.

"Dave Peterson" wrote:

> I got nothin' more.
>
> Good luck,
>
>
> Laser wrote:
> >
> > Thanks Dave,
> >
> > No, I don't think that can be it, I can copy the files in question to other
> > computers on the network and they behave the same.
> >
> > Mike
> >
> > "Dave Peterson" > wrote in message
> > ...
> > > We had one person at work who was getting a similar error (although I
> > > don't
> > > recall if it was the same).
> > >
> > > They were saving to the smallest partition on their harddisk and didn't
> > > have
> > > enough space to save larger files.
> > >
> > > Any chance???
> > >
> > > (I got nothin' more!)
> > >
> > > Laser wrote:
> > >>
> > >> Hi Dave
> > >>
> > >> Thanks for the response
> > >>
> > >> Do you see "readonly" in the workbook's title/caption?
> > >> No
> > >>
> > >> Can you do File|SaveAs and save it as a new name?
> > >> No (same message File Not Saved)
> > >>
> > >> Do you have any macros running that could be interfering with the
> > >> process?
> > >> No (Disabled all macros and same result)
> > >>
> > >> What happens if you disable your Antivirus software?
> > >> Same ( Disabled McAfee and same result )
> > >>
> > >> Does this happen with every workbook or just this one/set?
> > >> Some files in the same directory work fine. I have not been able to
> > >> identify why some file can be saved and some can't. The ones I can't
> > >> save
> > >> now I was ably to save fine only last week. They just stopped working for
> > >> some (as of yet) unexplained reason.
> > >>
> > >> Any ideas?
> > >>
> > >> Thanks,
> > >>
> > >> Mike
> > >>
> > >> "Dave Peterson" > wrote in message
> > >> ...
> > >> > Do you see "readonly" in the workbook's title/caption?
> > >> >
> > >> > Can you do File|SaveAs and save it as a new name?
> > >> >
> > >> > Do you have any macros running that could be interfering with the
> > >> > process?
> > >> >
> > >> > What happens if you disable your Antivirus software?
> > >> >
> > >> > Does this happen with every workbook or just this one/set?
> > >> >
> > >> >
> > >> > Laser wrote:
> > >> >>
> > >> >> Hi Frank,
> > >> >>
> > >> >> Thanks for the suggestion but no help.
> > >> >>
> > >> >> Any other ideas?
> > >> >>
> > >> >> Mike
> > >> >>
> > >> >> "Frank Kabel" > wrote in message
> > >> >> ...
> > >> >> > Hi
> > >> >> > one idea: try deleting the temp directory and reboot the computer
> > >> >> >
> > >> >> >
> > >> >> > --
> > >> >> > Regards
> > >> >> > Frank Kabel
> > >> >> > Frankfurt, Germany
> > >> >> >
> > >> >> > "Laser" > schrieb im Newsbeitrag
> > >> >> > ...
> > >> >> >> I am using Office 97 and Win XP Pro SR2. I have a spreadsheet that
> > >> >> >> I
> > >> >> > use to
> > >> >> >> track monthly expenditures. Every month I make a copy of the most
> > >> >> > recent
> > >> >> >> worksheet carry the balance forward and delete the entries from the
> > >> >> > previous
> > >> >> >> month and name the new worksheet according to the current month.
> > >> >> > Therefore I
> > >> >> >> have a workbook that has several worksheets, one for each month as
> > >> >> >> a
> > >> >> > tab on
> > >> >> >> bottom of page.
> > >> >> >>
> > >> >> >> After copying the worksheet for this month, and making the updates,
> > >> >> >> I
> > >> >> >> clicked save and I receive the error message . I've
> > >> >> > tried
> > >> >> >> renaming the file and even copied it to a different directory I can
> > >> >> > open the
> > >> >> >> file but still can't save it.
> > >> >> >>
> > >> >> >> Any suggestions?
> > >> >> >>
> > >> >> >> Thanks,
> > >> >> >>
> > >> >> >> Mike
> > >> >> >>
> > >> >> >>
> > >> >> >
> > >> >
> > >> > --
> > >> >
> > >> > Dave Peterson
> > >
> > > --
> > >
> > > Dave Peterson
>
> --
>
> Dave Peterson
>

I have a project where I'm using VBA to update multiple excel
workbooks and creating custom copies of the workbooks as PDF files.
The custom copies of the workbooks are customized by what sheets and
individual wants to see. I have successfully used PDFwriter to
suppress the "Save as PDF File" dialog by programatically changing the
registry entries for PDFFileName, bExecViewer and bDocInfo and using
the printOut method of excel to get what I need. This works well for
all but two of the workbooks. These two workbooks create the PDF files
as programmed but at the end of the print to PDF before control
returns to the VBA code, the "Save as PDF File" dialog pop's up. I
acts as if either PDFwriter or Excel does not recognize that it had
already output a PDF copy of the workbook.

This is anoying as I have not been able to figure out what is
triggering the dialog box to pop up after the print to PDF is
complete. Has anyone experienced this or have any possible solutions
for this situation? I'm using Excel 2000 and Acrobat 5.0.

A few months ago i created an excel 2007 workbook and saved it in xlsx file
format. This file is only 441kb. I've worked on the file off and on since
creation. I went to work on the file today and everytime i've opened the
file it has froze my computer. Now i've backed up the file to an external
hard drive at various stages and have restored these with different names and
locations all with the same result. I am able to open any other xls or xlsx
file with no problems. I've restarted the computer and checked for updates
and have run Microsoft diagnostics. I am also current on my antivirus and
have scanned for infections. All have been negative.

I was able to get the file opened once, miracously. Once opened i saved to
..xls format under a different file name. In the process it froze again but
for some reason it successfully saved. I copied the file to a thumb drive
and brought upstairs to my other computer. I opened the xls formatted file
successfully with full operation.

Why can i not open the file on the computer that created the file? What
other steps can i take? I'm guessing some kind of corruption has happened
but don't know what or where to look. Thanks for any ideas.

Rob

Hello - might I ask help of the experts here please?

I have a macro in a spreadsheet that references back to a video file (Mfile
= "test.avi")
I want to e-mail the spreadsheet to a friend but in order to do so, she will
have to separately copy the file test.avi to her c drive to make the macro
function. This is inconvenient.
Obviously I can embed the file test.avi into the spreadsheet as an object,
but how can I change the VB code to directly reference it. I'm no VB expert,
so any help would be appreciated

Best

TP

We have 2 Excel files which are titled Copy of Draft Register and Copy of
Copy of Draft Register. When we try to delete it, it says "Access Denied".
If we go to "save" these files it shows they're "Read Only"

I protected my workbook with

File; Save As; Tools; General Options; Password to Modify

I've also protected my worbook with

Tools; Protection; Protect Workbook

But, other users are still able to make changes by creating a copy of the
workbook, or in general, saving it as (Save As) a different file name. Is
there a way to prevent this?

When one of my colleagues took a copy of an excel file and saved it to her
personal network drive, our system converted it to a .xlsm file. The thing
is we don't have excel 2007 and the file was created in 2003. Can anyone
explain why this would have happened?

When I open my worksheet named cardlist.xls, excel opens that file but then
calls is cardlist:1 and then creates a copy cardlist:2, but when I save it
only saves as the original file name... what causes this?

Hello, I was wondering if it is possible to create a copy of an excel file so
that all data is linked ot the original.

I have several trending spreadsheets that i am sending out for review on a
monthly basis, as the files are large i am currently sending out hyperlinks
giving people access to the files, however i don't want people to have access
to the original files.

What i wanted to do was set up a folder and copy a series of linked
spreadsheets into this folder and allow people to have access, is this
possible?

EXCEL: I used to be able to maintain the contents of the clipboard even
thought I closed Excel. That is I could copy. Close the Excel application,
(not just the worksheet) & then reopen the Excel application, open another
worksheet & then paste into it. Now I can't. I loose the contents of the
clipboard when I close the Excel application.
Help please. I need to close the Excel application b/n copy & paste because
of file linkages etc.
Thanks SAGknot


No luck finding an answer? You could always try Google.