...Pivot table in Excel 2007
This pivot table has been created automatically in Excel 2007 : see the
In this pivot table, how, you experts, will you replace the row "Grand
total" by a row "Difference" with a formula like Receipts - Expenses.
Thanks for your help!
One way would be to have another column in the source data, called
Expense2 with a formula
=Expenses*-1 (replacing Expenses with the relevant cell reference) and
Replace Expens...Excel 2007: Disable Office Menu control on the fly
I'm looking for a way to disable Office Menu controls such as: New, Save,
SaveAs, etc on the fly. Whenever user opens an excel workbook into my
application, those controls under Office Menu are disable.
In office 2003, I could do something like this when user opens their
workbook in my application:
With objExcel.CommandBars("Worksheet Menu Bar")
.Controls("&File").Controls("&New...").Enabled = False
.Controls("&File").Controls("&Open...").Enabled = False
.Controls("&File").Controls(&qu...Hid a sheet in Excel 2003 Need to unhide it in Excel 2007
I hid a sheet on a workbook created with Excel 2003. Our company upgraded to
Office 2007 and I tried to unhide the sheet in Excel 2007. 2007 doesn't seem
to find the previous sheet.
Right click on any tab and select Unhide.
Does the Unhide pop up window appear or not?
> I hid a sheet on a workbook created with Excel 2003. Our company upgraded to
> Office 2007 and I tried to unhide the sheet in Excel 2007. 2007 doesn't seem
> to find the previous sheet.
...Using an MFC DLL in VB.NET
Are there any instructions online on how to make a DLL control written
in MFC work in VB.Net?
> Are there any instructions online on how to make a DLL control written
> in MFC work in VB.Net?
If its unmanaged MFC DLL, the only way you can use it thru PInvoke
unless its a COM server. An easier way would be to make it managed and
use CLI to expose the functionality.
It's been awhile since I wrote this, and I honestly don't know if it's
managed (probably meaning it isn't). How can I tell if it's managed?
If it's not, are there any step by step instr...In Excel vba how do you Launch code a standalone Module from a Form or other Module ?
I can create stand alone modules in Excel vba by clicking File New Module or
How can I run the code in those stand alone modules from another module or a
Form that has its own code?
Thanks for any help.
If you're talking about "New Project" from the VBA File menu,
this create a new VBA project that is used to create COM Add-Ins,
a discussion of which is beyond the scope of a newsgroup reply.
In general, you want to use the Insert menu to create a new
module in an existing workbook.
In VBA, there is no such thing as a "stand-alone" module; all...COM Writing Problem: Dead COM?
My code has worked in the past, but now it does not.
I can open a COM Port using CreateFile, and the handle is valid.
GetCommState is successful.
SetCommState is successful.
GetCommTimeouts is successful.
SetCommTimeouts is successful.
Next, I try to write to the COM Port using WriteFile, but it returns FALSE
and GetLastError = Error 31: A device attached to the system is not
Is there some way to reset the COM Port? I have tried rebooting as well as
enabling/disabling the COM Port, but nothing seems to work!
Did I damage the COM Port?
This is on a Pocket PC where the...How do I get rid of the 0 place markers on my forms in excel?
Since our hospital updated to Excel 2003 it puts a 0 place marker in the
spaces where I paste a special link and I want to get rid of them, how do I
the cell ( in book2)with this formula will read whatever is in the cell
specified on the sheet specified, in the workbook specified.
> Since our hospital updated to Excel 2003 it puts a 0 place marker in the
> spaces where I paste a special link and I want to get rid of them, how do I
> do it?
...Checkboxes in Excel
I have several checkboxes in a form that I need to have the "True" or "False"
be filled in the database for this form. How do I do this?
I don't think i understand you but with code you can change the
checkboxes like this
'control toolbox controls
For Each obj In ActiveSheet.OLEObjects
If TypeOf obj.Object Is MSForms.CheckBox Then
obj.Object.Value = False
ActiveSheet.CheckBoxes.Value = False
Regards Ron de Bruin
"TotallyConf...hoja de excel
Me podria decir alguien: �Como se copia una hoja de excel en word? Gracias
...Print excel file from DOS command line #2
It's possible to pass a parameter to VB ? (I never use VB)
I need it becase I need to print different workbook with a .bat
despistado's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1629
View this thread: http://www.excelforum.com/showthread.php?threadid=27692
I create a PrintXLS.VBS file and put it in a safe spot.
(I put it in "C:\my documents\scripting\printxls.vbs")
This was in the file:
set objargs = wscr...Excel to PDF taking too long
In excel 2007, I could export data to PDF using 'Save As' which is nice...
but it is taking too long to convert file to PDF.
Currently I have 35 worksheets in a workbook (soon it would be 100) and it
takes 10-15 mins to convert XL to PDF... Now I am worried when I will put
another 65 worksheets it would take ages to convert into PDF...
Can I do anything to reduce my time? Any advise on this would be highly
On 2/23/2010 7:10 AM, Milind Keer wrote:
> In excel 2007, I could export data to PDF using 'Save As' which...Passing Param to GP Forms with VB.net
I am writting a form that when you click on a grid, you open up another form
with more detail (This form is a gp form.) and am trying to figure out how to
pass the info that need the for to open up with.
Casino Queen Inc.
...VS 2005 Com Interop Exception in Web Service
I have a service, that runs perfectly when executed outside of the web
service environment. When called as a web service I get the exception
listed below sporadically. A call to the web method may succeed one time and
not another. I cannot find any reason why it would work one time and not
another. The exception occurs every two or three calls to the web method.
The service utilizes a COM component provided by PeopleSoft called a
Component Interface. That COM object then makes calls into a Java library.
Layers to the max I know but it is all I can work with right now ti...Excel: When printing some cells will not print text in them
Operating System: Mac OS X 10.5 (Leopard)
When I print an Excel 08 spread sheet, two of the cells that have text in them will not print the text in the cell. All the other cells with text prints fine. The text does not even show up on print preview in the print dialogue box.
Any suggestions on how to get it to include the text in these two cells?
...Create Excel file with VBA in Access
Here are 2 examples that I have found to create an Excel file with VBA.
It is great for exporting data to Excel with the format that you want.
Dim MyXL As Object 'Excel Application Object
Dim XL_File As String
Dim SheetName As String
'Dim xlBook As Excel.Workbook
XL_File = "C:\Excel_Documents\test.xls"
SheetName = "New Sheet Name"
'Create the Excel Application Object.
Set MyXL = CreateObject("Excel.Application")
'Create new Excel Workbook
MyXL....datas ms access to excel
I have a certain amount of datas, which I put into MS Access. A part o
those datas should now AUTOMATICALLY forwarded (duplicated) to excel.
IE: In Access there is a row called item, the next is item number. Whe
I put those subjects into Access -the same rows are in Excel- shoul
duplicate it to Excel (item, item number).
What is the most convenient way to do this?
BTW I use MS Office 97.
Message posted from http://www.ExcelForum.com
You have 2 basic alternatives :-
In Access - File/Save As .. Export.
In Excel - Data/Get External Dat
Message posted from http...excel 2000 and excel 2003
All my spreadsheets that have been made in excel 2000 don't print out in
excel 2003 as they do in excel 2000.
The margins are off and the page breaks blend into the next page. I got a
new PC and it has office 2003 and all my excel files from my old PC have this
problem. Is this a known issue when moving from 2000 to 2003?
Are your OS display resolutions on the new PC the same as old PC?
Is the printer and driver on the new PC the same as old PC?
If not, you will probably have problems, but not any fault of Excel's.
Gord Dibben MS Excel MVP
On Wed, 3 Jan 2007 18:07:01 -0800,...Need help with EXCEL?
Try this site: http://TheGoodStuff.cc
...email@example.com autocompletes to firstname.lastname@example.org <email@example.com>
The following continues to happen.
firstname.lastname@example.org autocompletes to email@example.com <firstname.lastname@example.org>
How to stop this?
And what does this have to do with Outlook?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Tom asked:
| The following continues to happen.
| email@example.com autocompletes to firstname.lastname@example.org <email@example.com>
| How to stop this?
Delete the incorrect autocomplete entry by highlighting it and hitting the
...Excel resizing Graphs
When I copy and past a graph, excel resizes it. It does not matter if I say
move and size with cells or move and don't size with cells. I need to make
MANY graphs all of the same size. I created a custom layout, but I then must
manually resize every graph. Is there a way to copy and past as the same
size? Is there a way to LOCK this size as well?
Which version of Excel are you working with?
In all my experience, anytime you copy an object the pasted object is
identical in all respects, including size. While writing this I have been
repeatedly doing so in '03. No matter wha...Excel Reading
Hello to all,
I am trying to find a good book on Excel but a lot of these book
don’t focus on making your spreadsheet more presentable. The
usually focus more on functions and just teach the basic chartin
wizard. Can anyone recommend a good book that focuses more on chartin
in addition to the functions? I am responsible for creating performanc
and financial reports from scratch so my success partially depends o
how presentable I can be. Thank you in advance :
november678x's Profile: http://w...Need macro help to close excel
I have created a button in Access2000 that opens an Excel Spreadsheet. What
I need now is assit in closing excel upon completion. I can get an excel
macro to save my file and close the worksheet, but it is not closing excel
entirely. I'm on project with this employer and could use a response today
to fix this before I leave. Thanks much to any and all. My macro is as
' SaveClose Macro
' Macro recorded 9/27/2004 by cdjohnso
' Keyboard Shortcut: Ctrl+Shift+C
ActiveWorkb...how do you create file folder labels in excel?
"rebecca_vsp" <firstname.lastname@example.org> wrote in message
Please use this BIG WHITE SPACE to provide details of your question that
won't fit in the subject line.
Do you mean labels to stick on the spine of lever-arch files, for example?
Word has built-in Label printing, with many different label formats already
Excel does not have this ability. (AFAIK....)
Excel alone is poorly suited for creating labels.
Do you have Word?
Use Word's mailmerge with Excel or Access ...