Special Pasting a work book with many sheets and formulas
I have a workbook with many sheets that all have formulas and links to other
data. I want to save the workbook as another name with all the worksheets
keeping the values only (no links or formulas). Is there a quick way to do
this for everysheet without having to special paste every sheet in the
workbook. So can I save everysheets data values at workbook level.
See this page for a code example
Regards Ron de Bruin
"lex63" <firstname.lastname@example.org> wrote in message news:ED708...backup file won't work!!
OK, now I've really had it! This is my last resort!
Several years ago, while using Money 97, our computer
crashed. We had backed up every time we used money, so I
thought we were OK. However, we could never get the
backup file to pull up after fixing the computer and
everything was lost. I vowed that this would not happen
again, so I tried backing up on a ZIP disk instead, and
then on CDs. I also got on this newsgroup and got the
advice that I needed to first copy the backup file onto
the desktop and open it from there. I tried doing that
with the old program, and it seeme...if cell is text move left one column
ColB is a long list with sections names followed by category codes
I need to move the text into colA leaving colB with codes only (all numbers)
Dim lngRow As Long
For lngRow = 1 To Cells(Rows.Count, "B").End(xlUp).Row
If Not IsNumeric(Range("B" & lngRow)) Then
Range("A" & lngRow).Value = Range("B" & lngRow).Text
Range("B" & lngRow).Value = ""
...How to make Run Integration work in GP 10
Can anyone tell me how to make the Run Integration tool work in GP 10. We
just did our first client upgrade to GP 10 and the client has only 1
integration that they used to be able to run via the RUN INTEGRATION Tool.
Any help would be greatly appreciated.
I have the same probelm...did you get any answers to this?
I have to go into Integration Manager to run it b/c Tools>Run Integration
does nothing. I even checked the ini files to make sure the path is correct.
"Tammy Chavez" wrote:
> Can anyone tell me how to make the Run Integration tool work in...Reference Book
I'm a Win32 programmer, and I'm trying to get into some MFC. I've read a
little about MFC, but the books lack a lot of quality and descriptive text
about the structure of MFC. Can I ask whose book is the Charles Petzold of
I haven't seen a bad MFC book in a long time, but then again, I haven't
bought a new MFC book in many years.
My presonal perference are the MFC books published by Wrox Press
You can't go wrong with the Microsoft Press ones either.
Al...SBS 2003 moving of users files
I run SBS 2003 and due to the amount of data on the users drive it has
become chokers and have installed a new 1tb drive to keep up with demand
I need to move all the data to the new drive but unsure of the process.
Is there an easy way of doing this? As it needs to be done asap
JimmyJames's Profile: http://forums.techarena.in/members/255792.htm
View this thread: http://forums.techarena.in/small-business-server/1357051.htm
You c...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam email@example.com> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...Global distribution List Not Appearing in Outlook Global Selections list
I have created a global list in AD in Server 2003 ( using Exchange 2003) and
assigned my users. For some reason the list is not showing in the Outlook
client global address list. I have compared this list to others i have
created in the past and cannot spot any differences. What am I missing?
1. Have you got it hidden from the GAL?
2. Using cached Exchange mode? Therefore requiring a rebuild of the OAB to
On Fri, 16 Feb 2007 13:24:05 -0500, "rlm" <firstname.lastname@example.org> wrote:
>I have created a global list in AD in Server 2003 ( using Exchange 2003...Moving Exchange #5
I am needing to move my Exchange server off of the SBS box that it is
currently on and move it to another, new server. I cannot keep the servers
the same name as I need the old server to continue to run SQL. Are there
white papers on how to do this?
On Fri, 18 Aug 2006 08:43:40 -0700, scottdog129
>I am needing to move my Exchange server off of the SBS box that it is
>currently on and move it to another, new server. I cannot keep the servers
>the same name as I need the old server to continue to run SQL. Are...Dynamic Range Selection Using VBA
What I'm trying to accomplish is to be able to run a procedure that selects a
range based on a number provided in another cell. For example; if the number
10 is in cell A1, then cells A20:A30 would be selected when I run the macro.
If the number 6 is provided, then cells A20:A26 would be selected. Not sure
where to start, so any help is appreciated.
this may do what you want
"TEK" <TEK@discussions.microsoft.com> wrote in message
I am using the XmlDocument Select Nodes method and it seems to work OK
except that it returns embedded nodes in the collection when I only want the
nodes that are not embedded. For example I have a statement as follows:
nodes = doc.SelectNodes(\\Node1\\Node\\DesiredNode);
It gives me back in the collection all the DesiredNode tags. If I select
retrieve the nth node as follows
node = nodes[n-1];
It gives me the correct node and all DesiredNodes that are embedded within
the nth node. So if I ask for the first node it gives me the first node
which includes about 5 embedded DesiredNode...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...Request Selection
Hi, if we try to assign an activity to an open Request there are all
Requests available (include closed). is there a way to show only open
requests in this select-formular ?
...Numbering in Book Files
I am creating a tech manual where each chapter is its own file. I have
created an outline numbered list and saved the list in a template that I then
use to create the new chapters. However, I am finding that when I go into a
new chapter that the outline numbering does not pick up on the chapter
(Heading 1) number. For example:
Chapter 1: Heading 1 style
1.1: Heading 2 style
1.1.1: Heading 3 style, etc.
But when I start my next chapter, when I update the chapter number to start
at 2, I get this:
Chapter 2: Heading 1 style
1.1: Heading 2 style
1.1.1: Heading 3 style, etc.
...Migrating Exchange servers
We are in the process of migrating to a new exchange server. The issue we are
having is transfering the user's outlook (xp, 2k) address book/contact list
to the new server without manually having to log into everyone's computer and
pointing their address books to the new server.
Is there a way to do this authomatically server-side?
You're moving the mailboxes, right? The user's "address book" is the
Contacts folder in the mailbox. So, there's nothing extra to move.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
...modifying and copying multiply selections
Why when I select multiply objects, including text boxes or when I try to
select them and then drag to a different locations the program just create a
new copy but leaves the old one behind it? It didn't happen when I was
working with other versions of Power Point.
I think http://www.pptfaq.com/FAQ00882.htm will help.
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoice.com/2010.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx
"Slav" <Sl...Data validation list from another worksheet?
Is it possible that the value list for data validation be populated fro
puneetarora_12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1840
View this thread: http://www.excelforum.com/showthread.php?threadid=38572
Sure is! Use a named range as described here:
"punee...Bank One Download is not working
We are trying to download transaction data directly from
Bank One and the file is not being recognized by Money -
i.e. the Bank One website states that the download is
complete, but Money does not recognize it. Note that a
file is being saved on our hard drive but we can't figure
out how to read it. It is entitled mnyimprt.exe-(numerous
numbers and letters follow).
In microsoft.public.money, Miki wrote:
>We are trying to download transaction data directly from
>Bank One and the file is not being recognized by Money -
>i.e. the Bank One website states that the downloa..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
...lost address book and notes in outlook 2003
Hello, I recently had a crash and had to format my C drive on my win xp
computer. I have outlook 2003 and an addon program that regularly backs up
all my data from the program to a second hard drive, or at least I thought
it did. Anyway, after reinstalling everything I found that I had several
empty pst files and a few that had some old email messages. No addresses or
notes. I have saved all of these files just in case there is some way to
salvage them. Is there? If possible, please reply to my email rather than
this group because I can't view this at work. Any help is appreciated.
Thanks...Compact Now feature doesn;t seem to work...
I still have a 600+ MB in-box.
ANyone know hwta might keep it from compacting? I did
empty the trash.
Compacting only works when there is a certain percentage of white space in
the file (I think it's something like 4%)...if there isn't, Outlook doesn't
think there's anything to compact. Also, if you leave Outlook open long
enough, background compaction will be taking place.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
In news:5feb01c474ce$23bb29d0...Cash Receipts and Check book
This is regarding Cash Receipts in Sales Module of GP 10.
The input screen for cash receipt has a field to enter the cheque book id.
However upon posting receipts, the cheque book register does not get updated
with the receipt amount. Surely, the GL account associated with the cheque
book gets the debit, but not the check book register.
Would appreciate advice, comments.
The next step after entering a cash receipt is to deposit it in the Bank Rec
module. Go to Transactions > Financial > Bank Deposits to do this. The
reason for this is that the check...Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?
It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.
Jon Peltier, Microsoft...