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...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?
Hi, I hope you are doing well.
I have a file I downloaded from our AS/400 (OS400 operating system). I open
the file as a text file and go thru the wizard for converting the file to
excel format. One of the columns/fields is numeric with some neg and pos
numbers and some blank cell contents. During the wizard conversion the field
is categorized as DOUBLE with no option to change the field. When I finish
the wizard I save the file as an Excel workbook. Then I use the autosum
option to calculate the total of the field/column; however, it only picks up
on the positive #'s. Hence the t...Cut not Copy Appended Data
In this great Macro, created by Micky (MVP), is there a way to cut and paste
the data from all the columns instead of copy and paste? I just want all the
appended data in Column A".
Application.ScreenUpdating = False
LR = ActiveSheet.UsedRange.Rows.Count
LC = ActiveSheet.UsedRange.Columns.Count
Ind = LR + 1
For C = 2 To LC
For R = 1 To LR
If Cells(R, C) <> "" Then
Cells(Ind, 1) = Cells(R, C)
Ind = Ind + 1
Application.ScreenUpdati...Why formula doesn't change on column insertion?
I know I will feel stupid when I hear the answer, but...
If I have a formula ( =average(a1:a5) ), and I insert a new column, the
formula, being relative, changes to ( =average(a1:a6) ). This works fine
in a test. BUT I have a working spreadsheet in which inserting a column does
*not* change the relative formula. Why? I can't see anything different in my
Never mind - resolved.
"Fred Boer" <fredboer1@NOyahooSPAM.com> wrote in message
>...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...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...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 ...Countif with 1+ specifics
I want to add E-mail, Letter and Telephone to the sencond part of
countif. Ii cant just add them with comma's like "Fax", "Email" etc,
how can this be done without having to add up several equations?
Message posted from http://www.ExcelForum.com/
"ianripping >" <<email@example.com> wrote...
>04'!$J$5:$J$1000...Another Outlook Question
Whenever I compose a message the window always is small and I have to
maximize this. Is there a way to have thw window always be large?
Thanks and may God bless you
Do not store up for yourselves treasures on earth,
where moth and rust destroy, and where thieves break
in and steal. But store up for yourselves treasures in heaven,
where moth and rust do not destroy, and where thieves do not
break in and steal (Matt 6:19-20).
"Jeremiah" <firstname.lastname@example.org> wrote in message
> Whenever I compose a message the win...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...Conditional Formating based on Odd vs. Even
If row in column A contains an even number, shade that row in Colum
B-G Yellow, If odd Shade Gray, If blank No Shade. Can this be done i
a formula in Conditional Formatting? If so, how? Help appreciated.
Message posted from http://www.ExcelForum.com
Condition 1: Formula is =Len($A1)=0 (no format)
Condition 2: Formula is =MOD($A1,2)=0 (yellow format)
Condition 3: FOrmula is : =MOD($A1,2)=1 (grey format)
"natei6 >" <<email@example.com> wrote in message
news:natei6.1699y4@excelforum-no...Picture Disappears When Added To Contact In Outlook 2003
Can someone help please.
When I try to attach a picture to a contact in outlook 2003 immediately
I double click the picture to be attached it disappears out of the
outlook contact along with the placement holder in the form. Only when
I right click the mouse and go remove picture do I get the placement
I have looked at all the help menus but they offer no clues.
...write macro to input data
I am new at Excel. I want to write a small macro, four or five columns where
I can go to column 1 and input data, then go to column 2 and input date,
etc., then when I get to the end of the fifth column have it return and go to
add more data in column 1. Any help will be appreciated from the experts
in Excel. Thanks.
one way to do this is to use a worksheet_change event
right click sheet tab>view code>copy/paste this>modify to suit>SAVE
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Row > 5 And Target.Column = 8 Then ActiveCell.Offset(1, ...How do I exclude data using the IIF statement in report builder
I have data in my dataset that I want to exclude in the average calculation
for the final report (those with a key.value of 999). Here is how my
statement is written but it is not returning any value. What am I doing
=iif((Fields!MeasureID.Value = 1 or Fields!MeasureID.Value = 16) and NOT
Fields!Key.Value = 999, round(Avg(Fields!CY_Rate.Value),0),
iif((Fields!MeasureID.Value = 19 or Fields!MeasureID.Value = 20
or Fields!MeasureID.Value = 21 or Fields!MeasureID.Value = 22
or Fields!MeasureID.Value = 23 or Fields!MeasureID.Value = 24) and NOT
Fields!Key.Value = 999, roun...Removing messages based on sender
Has anyone heard of a way to remove messages from the store based on the
sender address? I know exmerge can target subject and attachment, but I'd
like to target the sender address.
Thanks in advance.
Exmerge might have that option. Not possitive though.
MVP for Microsoft Exchange Server
"Bobby Hilliard" <firstname.lastname@example.org> wrote in message
> Has anyone heard of a way to remove messages from the store based on the
> sender address? I know exmerge can ta...Specific Font that be contained within Office 2004 do not appear to Font Box on Mac OS X 10.3(panther). #2
There are "Gulim.ttf" and "Batang.ttf" Within Font Folder in Office 2004
Folder (Application folder or Office 2004 CD)
These fonts are Window True type Font and Hangul font (using Korean)
I have known the font automatically be installed in Font Box when Office
2004 setup. After I had selected these fonts beside All Font in collection
window of font box then used disable button, These fonts disappeared in font
Box. Perhaps it is rightful!. However When I added these fonts repeatedly,
Only The "Batang.ttf" font appeared on Font Box window. unfortunately The
&...In Dialog Based application are you Create View class.
In Dialog Based application are you Create View class.
You should not need a view a MFC Dialog based appliation. If you do,
look at SDI/MDI instead. You can use a CFormView based view which uses
a dialog as a template in Doc/View paradigm.
You can create a view in a dialog:
But I haven't seen that done very often. I tend to just use an SDI or MDI
framework for anything that needs a view class.
"jagadeesh" <email@example.com> wrote in mes...can't change how data on 2nd axis is being displayed
I have created a chart with columns on 1 axis and lines on the other. My
problem is that I want to show the information on the 2nd axis in correlation
to the information that is being displayed on the primary axis. For example,
my data for the primary axis is Revenue by Market Segment by Year and the
data on my secondary axis is Number of Sales Order by Market Segment by Year.
What I am trying to do is so the data point for the Number of Sales order
for a particular year in the same place as the revenue for the particular
year and market segment is being displayed on the primary axis...Adding ActiveX to dialog with wrapper
When I add an ActiveX object to a dialog using the dialog editor -
right click - insert activeX object, the help on the resulting activex
selection tool states that a wrapper will not be added by using this
If you need a wrapper, it suggests using the class view.
This is using Visual Studio 2005.
I'm having some problems with this on an existing project.
To make sure I understand the process, I created a new MFC project,
added a dialog, created a class for that dialog and added a Flexgrid
object using the right click method in the dialog. I then added a
variable for the flexgrid...combination of stacked and clustered column
Any ways to combine two types of chars: sgtacked columns and clustered
If you stagger your data, you can create side-by-side stacked columns.
Bernard Liengme has an example and instructions on his site:
and Jon Peltier has links to other sites with information:
Grigori Margolin wrote:
> Any ways to combine two types of chars: sgtacked columns and clustered
Excel FAQ, Tips & Book List
I have 2 excel worksheets, both are in different formats. Both will
contain the same data but spread across different parts of the
if I have filled in the data for 1 worksheet, how can i automate this
data to be filled into the other worksheet?
In Sheet2 use linking formulas.
Sheet2 H1 formula is =Sheet1!A1
For contiguous areas these can be copied by dragging.
For non-contiguous areas..........manually enter references.
Gord Dibben MS Excel MVP
On Thu, 1 Apr 2010 08:13:17 -0700 (PDT), Lynn <firstname.lastname@example.org>
>I have 2 excel work...Adding alternate columns
I work on a schedule where I record ticket count and ticket sales for
each show, listed chronologically.
Column A = week ending date
Column B = # Tickets sold for April 5 show
Column C = Ticket Revenue for April 5 show
Column D = # Tickets sold for April 9 show
Column E = Ticket Revenue for April 9 show
Column F = # Tickets sold for April 12 show
Column G = Ticket Revenue for April 12 show
Column H = Total # Tickets sold for all shows
Column I = Total Ticket Revenue for all shows
In the Totals columns, the Total Tickets formula is "+B4+D4+F4", and
the Total Revenue f...Validating data in a subform against data in main form
I have a main form with a subform. Each form is bound to its own table but
are linked through a primary key (customerID).
On the main form, I have a customer's date of birth (dob).
On the subform, I have the customrer's date of order (doo).
Basically, I want to validate that the date of order entered by the user is
later than the date of birth.
How can I do this? I tried to do it in the subform's BeforeUpdate event but
it failed. It didn't seem to recognize dob (customer's date of birth).
Perhaps, I was not referring to dob properly.
I'm new to ...