How to insert an Excel landscape document into a portrait Word doc
I have a Word document in portrait style and need to insert an Excel
Spreadsheet which is in landscape. Is that possible?
Landscape and Portrait are simply print orientation in whichever document is
Are you inserting a complete workbook into Word?
Are you inserting a range from a worksheet into Word?
Maybe you need two separate print jobs?
Gord Dibben MS Excel MVP
On Tue, 11 May 2010 15:57:01 -0700, Heidi <Heidi@discussions.microsoft.com>
>I have a Word document in portrait style and need to insert an Excel
>Spr...Adding hyperlinks with parameters
I have a batch file which needs to be run from an excel sheet with a
parameter, like this:
But when i try to run the Hyperlink, the Excel shows an error message
saying it can't open the specified file (probably because the is a
space between the file and the parameter)
is there any known way to run the link from the excel?
On Mar 2, 12:45=A0pm, Pasha <pavel_v...@mailto.mod.gov.il> wrote:
> Hey everybody
> I have a batch file which needs to be run from an excel sheet with a
> parameter, like this:
> c:\1.bat myParameter
> But when i ...Adding Blank Rows after the last Detail of the Report
I've used this code from Dwayne:
Private Sub Report_Page()
Dim intNumLines As Integer
Dim intLineNumber As Integer
Dim intTopMargin As Integer
Dim ctl As Control
Dim intLineHeight As Integer
intNumLines = 12
intTopMargin = Me.Section(3).Height
intLineHeight = Me.Section(0).Height
For Each ctl In Me.Section(0).Controls
For intLineNumber = 0 To intNumLines - 1
Me.Line (ctl.Left, intTopMargin + _
(intLineNumber * intLineHeight)) - _
Step(ctl.Width, intLineHeight), , B
My report needs to print blank rows (at least...excel formulas #2
Can someone help me with how to create a formula that looks at one cell and
based upon the number in that cell (if statement) then gives me another
If cell c4 contains the number 1; then how can I have cell a8 look at cell
c4 and give me the number 1 (other than a link) / then have cell a9 look at
cell c4 if it contains the number 2 to then give me the number
I need a formula to look at a cell that will contain a number from 1 to 5 or
above and then accoridingly give me a coresponding number to reflect if that
number is 1,2,3,4 or 5. Each cel...Charting Time Samples
I have a spread sheet with a time value in hours:minutes:seconds in
column A and another on column B with a value in hours:minutes:seconds.
In column C is the difference betwen the two. (=TEXT(B1-A1,"h:mm:ss")
with a results like this....
How do I chart these time samp...Looking for a charting control
I am looking for a professional quality charting control. Current
requirements are Bar charts and Pie Charts, but this might change in the
near feature to include more complex data types using Line charts (smooth
and normal), area charts (stacked), point or radar charts. I haven't been
able to find a good one yet.
I found this put the documentation is not adequite.
I've used a system called ProEssentials5. I built a thin C++ wrapper around their types
and I've done a number of g...Button Control calling CFormView #2
I Have a CFormview (FormB) that has a button. When this button is click, It
will call another CFormView (FormA).
How to do it? I am using VC++ 6.0.
Newbie & Noobie wrote:
> hi everyone,
> I Have a CFormview (FormB) that has a button. When this button is click, It
> will call another CFormView (FormA).
> How to do it? I am using VC++ 6.0.
I assume you have created your project with the aid of the class wizard
from the IDE.
if you double click your button in the resource editor class wizard
should suggest a click handler method for your button. Within...A Word Macro to VLookup a Range in Excel
With a combination of VLOOKUP and MATCH formulas in Excel I'm able to grab a
cell's value from a multi-row, multi-column range. But I can do this only
from within Excel. The formulas look like these:
=IF(H4="",0,(VLOOKUP(H4,$A$1:$E$50,MATCH("REG",$A$1:$E$1,0),0)-VLOOKUP(H4,$A$1:$E$50,MATCH(IF(I4="","REG",I4),$A$1:$E$1,0),0))*IF(J4="","1",J4...Access an excel file through FTP without write protection
I placed a question yesterday - approximately 28 hours ago - nobody have
reacted on it - please tell me if you don't understand my question because
my English is to bad.
...Simple Template excel for Books
I need free Excel Template for my list of reading Books, Thanks
"=?Utf-8?B?c2FtLWM=?=" <firstname.lastname@example.org> wrote in
> I need free Excel Template for my list of reading Books, Thanks
Have a look here:
It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)
...Reports only Show 10 Records
I notice that when you run a lot of the reports (eg Account Overview) there
is only a maximum of ten records returned. This appears to be hardcoded as
the report also states the fact in the footer.
Any way around this? If the filter used on the report actually referred to,
for instance, 25 Accounts how would you get all 25 reports? Maybe I am
export that report to its rdl file and take a look through the reports
source code which might tell you. Also make sure you also export any of its
Microsof...outlook vcard, ad integration user properties
my boss is trying to get hix fax# in his vcard.
he is using his address from the global address list
I have modified his profile in active directory users and computers: I go
into AD users and computers, double click on his user, go to the telephones
tab, and enter his fax #. but when I did this his fax # is still not being
pulled up in his outlook vcard. Does anyone know where outlook is trying to
get this field from / how i can get this field into his vcard?
I'm having trouble getting data sorted for an entire
year's worth of data. If I highlight the entire year, it
won't sort. A box pops up saying "this operation requires
the merged cells to be identically sized." What is
Don't use merged cells in the sort.
I strongly recommend never to use merged cells, you
can basically get the same layout in most cases and
down the road you will avoid headaches
"EJ" <email@example.com> wrote in message
>...Line & Double Stacked Charts
Good day. I am trying to get a Double stacked chart to show a line. I can get
the line by creating a secondary Axis however the line isnt where I want it.
It is at the top of the tallest bar. Is there any way to get the line down to
a value I want it at.
Basically I am trying to create a capacity chart with two products running
on one machine by month. I need the line to be at a value that is straight
accross being the maximum machine capacity.
Any help would be greatly appreciated.
> Good day. I am trying to get a Double stacked chart to show a line...Is there a way to insert photos into excel at a specific size?
I need to insert multiple photos into an excel spreadsheet and would like to
know if there is a fast way to resize the photos to the same size. Can it be
inserted at a predesignated size to prevent from having to size each
Maybe you could start with this:
(watch out for line wrap in the first response--it's discussed in the later
> I need to insert multiple photos into an excel spreadsheet and would like to
> know if there is a fast way to resize the photos to t...A2007 Export to Excel
I have the following code....which works perfectly in A2003, and works if Im
opening a A2003 in A2007...but if I try to run it in a pure A2007 database it
Here is the code:
Dim xlApp As Excel.Application
Dim xlSheet As Excel.Worksheet
Dim xlWorkbook As Excel.Workbook
Dim objRST As Recordset
Dim strQueryName As String
Dim strSheetName As String
strQueryName = "ExcelStatus"
strSheetName = Me.Status
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set xlWorkbook = xlApp.Workbooks.Add
Dim db As DAO.Database
Dim qdf As DAO...ADDING A NUMBER
how do i add a number to a range of cells? I need to add 11.27 to a number
of different cells each with a different number in them
Put 11.27 in an empty cell, format it the same way as the numbers you want
to add to,
copy it, then select the numbers you want to add to and do edit>paste
special and select add.
"Helpme" <Helpme@discussions.microsoft.com> wrote in message
> how do i add a number to a range of cells? I need to add 11.27 to a
> of different cells e...adding new records
I am totally new to CRM, so I hope this is really easy question:
This concerns permissions.. I have a "sales" group, and with one of those
people i need to be able to let them add new records on behalf of other
"sales" people. Is there like a standard permission setting for it?
(obviously every "sales" person can add new records if they select them selfs
as the owner)
By default the person who creates the record will be the owner. After record
creation the person could reassign the record (manually) to another user.
If all rec...Area chart Disappears
i've a created graph with a combination of Line Chart & Area Chart.
Everything is fine, but when I post it in my company's intranet server and
somebody tries to open it, the Area Chart simply disappears and they only see
the Line chart in that graph!! I tried to open from several different
computers but still the same. As I mentioned, if I open it from my computer
it works fine.
If you are using a PDF program to post the charts, check to make sur
your title bars aren't even close to the chart area. There has to b
space between them.
Hope this helps
T...Linking to a Password Protected Document in Excel 2000
I have a document that is password protected. I also have a file that
references the protected files for many of the its formulas. Each time I open
the file and update the links I am prompted multiple times (once for each
cell reference to the protected file) for the password. Is there any setting
so that a user is only prompted once for the password to a reference file
that is protected?
I know that one option is just to copy the tabs from my referencing file
into the protected file, but it would be nice to keep the documents separate.
One option might be to disable th...When adding attachments...
....in Outlook the following errors comes up:
"Out of memory or system resources, please close some
programs and try again"
Quotas are fine. I have deinstalled/reinstalled Office,
cleaned 'temp' areas, and many other tidbits. Any other
This might help as i had this problem with Outlook 98.
Is the file you are trying to copy to attach nested in sub folders? if so try and copy the attachment to a root drive like c:\
Ignore previous email. wrong spellin
if the attachment is nested in sub folders(this means you have to open different folders to get to ...Excel file size increased 3 times after saving!!!!
I have a very strange situation with my Excel workbook. I created Excel
workbook with conditional formulas (no other formulas) which total size is 3
Mb. After I put simple data for calculation and saved the workbook the size
increased to 10Mb! The data itself is just about 70Kb. I use Excel 2002 at
work. I should put this workbook on our company server, but our network is
not very good and people can't open it because of the 10MB.
I have never seen this before!
Can somebody help please?
Thank you in advance!
I don't claim to be an expert on Excel by any...How do I create a mail merge document in Excel? Is it possible?
I have a form I would like to add mail merge fields to. Does anyone know how
to do that?
Plbowles, I would use word for the merge,
For help on Word mail merge using Excel as the data source have a look here
A training tutorial for creating envelopes and labels.
Always backup your data before trying something new
Please post any re...Classes within a control
can anyone help me out here. I have used an activex (SSUltraGridControl)
control on a dialog and I then added a member variable of type
CSSUltraGridControl. At this point I selected the classes within the
control that I required.
I now wish to utalise the CSSSelected class (which was not originally
chosen) within the control and I do not know how to get it into my project.
I have tried creating another project and included the entire
CSSUltraGridControl classes in it and then copy the SSSelected.h and
SSSelected.cpp files into my working direcotry etc by I get an error saying
...Inbox doesn't show new emails in Outlook 2007
When I am looking in the Inbox and new emails arrive they don't appear
although the number of unread emails in the Inbox increases.
I have to select another folder and then return to the Inbox to see
the new emails.
Peter Saxton from London
What kind of email account? Do you have any anti-virus Outlook plugin
disabled, especially AVG's?
"firstname.lastname@example.org" <email@example.com> wrote in message
> When I am looking in the Inbo...