Can I embed a clickable link that includes command line arguments?
I 'm familiar with the process of embedding a clickable link to a file
located on a share accessible to the recipient, and do so regularly by
using a UNC formatted path:
\\ServerName\Path\to the \location\of the\file
(Interesting ... the "<" ">" I wrapped the above line in dissappeared as
soon as I entered the close bracket. In Outlook [plain text] I'm not
used to that happening.)
My question: is it possible to do the same thing to launch a .exe (or
..cmd) with command line arguments?
\\UNC Path\Executable /argument1 /a...How can I asign a number value to a text line in Excel?
tI have a Backgammon Club with Internal Club Rankings that are in Text. I
want my members to report their wins - 1st, 2nd, and 3rd place - in
tournaments to my web site . I would like them to imput: their nickname, date
of tournament, tournament Room #, tournament points played for, and host of
the tournament. I would further like the calculation to display any change in
Ranking as a text cell. Additionally, I want to show for the member, how many
more points are needed to get to the next levle and what that (Text)level
is. If there is a "what if" for this please advise.
Ri...Combo Box from data in another tab
Is it possible to create a combo box from data that's in another tab?
I have a combo box that's from data in hidden columns. But now I need to move
all that hidden data to another tab in the same file. But when I go into
properties and go to the ListFillRange option, it won't let me enter another
Message posted via OfficeKB.com
I have called data from another tab with a combo box by doing th
First - name the range of the data on the other tab. This can be don
with the shortcut on the toolbar (l...Adding a new data series to an existing chart
I have a stacked bar chart that shows monthly sales by customer type. I want to add an additional data series to show the monthly forecast, to be displayed as a point or line against the existing stacked-bar data. Any ideas?
Select the data you want to plot. Drag onto the chart. XL will pop up
with a dialog box asking for some information. Provide it and you will
be all set.
MS MVP Excel 2000-2004
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
In article <1418C2D7-4DF6-4945-A08A...Excel 2000
*First off:* I have created a spreadsheet that has a dynamic range an
*Next:* i know i can add options to the 'dynamic range' and my dro
down menu will add the option to its list.
*Problem:* How can I make it so the user can add data into th
validated data list/drop down menu rather than having the user addin
it into the dynamic range?
*Example:*this drop down menu indicates how often a system is updated
weekly, monthly, etc. etc... i don't want to restrict it, so i want t
make it so they can indicate their own time on how often those update
-...Command line execution in Powershell
I've written a script to build parameters to pass to a command that will be
executed via the command line. The trouble I'm having is finding a cmdlet
that I can use to not only execute the .exe but pass the parameters needed
for that .exe to run. For example - I want to execute "postemsg.exe" and use
my p/s script to build the necessary parameters -- here's what the final
command will look like:
postemsg.exe -S <server IP> -r HARMLESS -m maint hostname=<server name>
segment=7 new_mode=m multi=0 Enable_Maintenance Maint
So far I've only ...getting a single line from a file
I was wondering if someone could tell me how to read a single line from a
text file. I tried using getline, but my MFC program does not recognize the
getline function. Nor does it recognize <string> or <string.h> or using
namespace std. So is there another function that I can use in MFC?
Take a look at the CStdioFile MFC class.
Check Abdoul [VC++ MVP]
"R.H." <email@example.com> wrote in message
> I was wondering if someone could tell me ho...Data within a cell
If names are in cells as "last name, first name, middle initial" can a macro
be run to change the order to "first name, middle initial, last name"?
A formula will do
Assuming you have spaces between commas and names,
Then just copy down. If you want this more permanent, copy the cells with
formulas, right click, paste special.
*Remember to click &q...How do I make the x axis data the y axis data?
My graph automatically makes certain data the y axis and other data the x
axis. I need to just reverse it for the graph I am looking for. Any
One option is to reverse the positions of the data on the spreadsheet.
Assuming an XY chart, you would change a setup like this:
If this doesn't work, can you post back to let us know what type of chart
and data you're using?
> My graph automatically makes certain data the y axis ...Prevent auto recoloring of chart when using Pivot Table data
I have crated a Pivot tabel with data I want to show in a Chart. My problem
is when I refresh data the colours of the "data series" changes.
For exaple I want one of my series "OK" always be shown in green colour, but
after a refresh of pivot all colours changes.
This problem is not only colouring. If I have made changes to my chart so
that one series ar plotted on a secondary axis, and I change it to another
chart type (e.g. the secondary should be shown as a line instead of column)
this also changes when refreshing the data. Most irritating!
Anyone that knows how to p...Data entered from list automatically enters number in another cell
I am using Excel 2007 and here is an simplified example of what I need.
Items Column is List for Valid entries in table below
Prices are the numbers I want entered when I enter the Item
If I enter Oranges from Dropdown List in A16 , I want Excel to automatically
enter the number 7.95 3 columns over in D16,or if it is quite a bit easier,
just 1 column over in cell B16
Example of table I want:
My Entries: Excel Enters
...converting plain data to table format
It has been a while since I used excel but I am almost sure there is a way to convert just plain rows and columns of data into a table format. This way I believe that adding rows to this block of data is as simple as tabbing after the last cell and it should just drop down to the next row and insert one??? correct??
Excel should recognize a contiguous range as a table, or list. Include
headings in the first row, and leave at least one blank row and column
between the table and other items on the worksheet.
You can use the built-in data form to add records to the table
(Data>Form). Or,...Data Migration Framework 08-04-04
I am not understanding something pretty fundamental regarding the Data
Migration Framework (DMF). I am looking to migrate a limited number of
records (approx 1K) from Goldmine into MS CRM as Account records.
I understand that the DTS in SQL can be used to load the data into the
CDF database. On page 73 of the Data Migration Framework Guide (v1.2)
it states that you use the Goldmine export utility to extract data
from Goldmine. However, how do you use DTS to load this data into the
CDF database as Goldmine exports it into Excel?
Also, using the export facility in Goldmine you can only e...uninstall from command line using alternate credentials
WinXP SP3. Is there a way to do this? I am trying to find a way for a power
user to uninstall a program using the msiexec + uninstall string from the
registry using admin account credentials.
Alternativly, I have tried to get the user to do a "run as" on the
appwiz.cpl file but I get an error.
UPDATE: also tried making a shortcut and running as admin but there is still
an error with starting the msiexec. It says something like error statring
program, it may be disabled or have no associated programs. I checked the
windows installer service and it is running.
...Changes to requested ship date in SOP should roll down to lines
When changing the requested ship date at the header on open SOP orders you
should have the option to roll this change down to existing SOP lines.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
Can I add line numbers to an excel spreadsheet? If so,
"Ernie" <firstname.lastname@example.org> wrote in message
> Can I add line numbers to an excel spreadsheet? If so,
Use the formula
do you neet the row numbers on your printout? If yes goto 'File -
Pagesetup - Table' and check the option to inlcude row and column
> Can I add line numbers to an excel spreadsheet? If so,
...Line up records (sorting)
I have 2 columns. Column A has values (numbers for the taxlots o
interest) that are not sorted in any order. Column B has the sam
values plus a bunch of extraneous values that do not appear in column
(numbers of other taxlots in the city). Columns C-G have values tha
correspond to the values in column B (Owner information for the taxlo
values in B)
What I need to have happen is either search column B for the values i
column A and delete all the extraneous records (columns B-G), or, alig
the values in column A so that they correspond to the locations of th
same values in column B.
Not sure ...get sql server schema to xml?
How can I get table/column schema of a sql server database? i want to
convert the entire schema into an xml file.
thanks in advance.
You can use a DataReader's GetSchemaTable method
"suzy" <email@example.com> wrote in message
> How can I get table/column schema of a sql server database? i want to
> convert the entire schema into an xml file.
> thanks in advance.
Oops, sorry for not posting the link... you can do it with the Connection
Object as well... here's a ...Public Folder and Virtual Root
Could somebody tell me what the following error means? and how to go about
Event Type: Warning
Event Source: NNTPSVC
Event Category: None
Event ID: 101
Time: 8:47:46 PM
The server was unable to add the virtual root '/' for the directory
'/Internet Newsgroups' due to the following error: The parameter is
incorrect. The data is the error code.
For more information, see Help and Support Center at
0000: 57 00 00 00 W...
Thanks in advance
H...Hpw to serialize boolean to 0/1 into XML?
I can deserialize my Xml that contains 0/1 to bool, but when I again
serialize it, value is true/false. Is there some way to force boolean value
to be serialized as 0 and 1, not true or false?
> I can deserialize my Xml that contains 0/1 to bool, but when I again
> serialize it, value is true/false. Is there some way to force boolean value
> to be serialized as 0 and 1, not true or false?
I suspect it is not possible, looking at
the possible values are 0, 1, true, false but the canonical values are
only tr...What defines an advanced level of Excel?
I was wondering if somebody could help me with this. I was looking at
applying for an office assitant job and it said I needed an advanced level
of Excel. I have been using Excel for some time now, although I recently
decided to do a short course starting from the basics to help identify what
I may be missing in my knowledge.
We didn't delve into complex formulars but covered all our basics and gave
our selves the background knowledge to explor further. I am all over the
place, such as inputing data, retreiving data from sources such as SQL
server, text files and so on. Formatt...Data Range with more than value
I am trying to assign codes to one of my worksheets based on pricing. The
problem that I am running into is that the data that I am taking my
information has a range of pricing Example below
PRICE POINT/RANGE PP
$0.01 TO $1 PP0100
I need to have a formula that looks at "PRICE POINT/RANGE" and compare it to
a column that has pricing (i.e .95). This formula/function should give me
the "PP" code.
Break the range up into two columns (Data - Text to columns). Assuming you
don't have gaps/overlaps in your price range (why would you?) your formula
...Reading an XML 'Field'
I am trying to wean myself off ini files and have managed to
produce the following by modifying the MS XMLReading sample:
It is just a mapping of where I keep things so that programs can
find them, if the locations change I can just update the map
Wha...warning level 4 an MFC
I would like to compile my app with level 4, but getting loads of warnings
from the MFC source, like this:
c:\program files\microsoft visual studio\vc98\include\xmemory(39) : warning
C4100: '_P' : unreferenced formal parameter
Am I doing something wrong?
>I would like to compile my app with level 4, but getting loads of warnings
>from the MFC source, like this:
Which version of VC++ are you using?
"David Lowndes" <DavidL@example.invalid> p�se v diskusn�m pr�spevku
> >I ...I selected row 1 and row 2 to freeze and it is freezing at row 12
I am selecting row 1 and row 2 to freeze and excel keeps freezing at row 12?
Select one row only, if you want 2 rows above where it freezes select row 3,
that will leave row1 and 2 unaffected when you scroll down
"Lori Brooks" <Lori Brooks@discussions.microsoft.com> wrote in message
>I am selecting row 1 and row 2 to freeze and excel keeps freezing at row
To freeze row 1 & 2 select A3 and then Window|Freeze Panes