Is there a way to attach a xslt template to a xsltargumentlist? please help!
in C#, I use the following way to do transform, the I assign my extension
object to the xslArg, so in xsl, I can call functions in the extension
object. Now, I want functions in the extension object to call template in
the xsl, this way I can put some customized code into the template. I think
it is reasonable, but I don;t know how to do it, anyone has some idea on
xslt.Transform(xmlDoc, xslArg, textHTML, null);
> in C#, I use the following way to do transform, the I assign my extension
> object to the xslArg, so in xsl, I can call functions in the extens...FILL CELLS = VARIABLE # OF OTHER CELLS (WITH MACRO)
COL A has variable number of cells...
Want to fill equal number of COL B cells with the number
If COL A has 8 cells, want only 8 cells of COL B with 70.
I don't want CELL 9 thru CELL X to have any values.
NEED THE MACRO CODING PLEASE.
Manually: enter 70 in cell B1, then double click the little square at
the bottom right of the cell.
In code (assuming only column A has any values):
Dim rng As Range
Set rng = ActiveSheet.Cells(1, 1).CurrentRegion.Offset(0, 1)
rng.Value = 70
Jon Peltier, Microsoft Excel MVP
Pelti...creating macro for copying the value from one cell
I m new to macro section. . If i m selecting a2 cell then the value will be
a3 cell r anyother cell i want. I want to know the function. plz guide me.
Try using the Macro Recorder........the following is a simple one that I
recorded to answer this post.......
' Macro recorded 2/2/2007 by CRober
Also, check out this link for help with macros, and post back if you have
Va...CRM requirements, any advice please
2003 Web Edition is mentioned in the requirements for CRM and I was just
wondering how you would go about implementing this. I think its only any use
in the large deployment as far as I can see.
Is it possible to install the medium deployment, SQL & CRM, on a Web Edition
I dont think so.
We are a software reseller only very recently having acheived partner
We are deliberating on a decent server and architecture for our OWN internal
use so that users can have access to CRM at least in a test environm...Microsoft Excel Help
Why are they called arguments when creating an Excel
function? i need to no for a Excel test! what makes them
if you mean the 'parameteres' of a function how would you call them
"martz" <email@example.com> schrieb im Newsbeitrag
> Why are they called arguments when creating an Excel
> function? i need to no for a Excel test! what makes them
...Need help grouping charts
I have identical charts which occur on multiple sheets. Is there any wa
to group them for editing?
When I group the sheets themselves, it seems to deactivate the charts
I tried doing it with a macro as an alternative and then flipping th
sheets one by one and keying the macro, but I get a message box with:
"Run-time error 1004", "Unable to get the ChartObjects property of th
Does anyone have any ideas
Izzy's Profile: http://www.excelforum.com/member.php?action=getin...Help with Now()
I am creating a spreadsheet and I need to have a cell and that record
the date and time each row is entered seperately.
The problem I have at the moment is whenever I add a new row of data i
updates the previous rows time?
does any one have any suggestions on how to stop this happening?
sydolly's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2712
View this thread: http://www.excelforum.com/showthread.php?threadid=46697
Now() is a volatile function and will change ev...DB Mail is is not working. Need help please.
I have try stop and start the db mail by executing the SPs below but no luck.
Does anyone has seem the error below and how to fix it.
Thanks in advance for your advise/help.
EXECute sysmail_help_queue_sp @queue_type = 'Mail';
queue_type length state
----------------------- ------------...Help with Raw Stock Data Collection
Is it possible to have Excel search through 1 minute raw data and be
able to determine if the price moves between a certain boundary for a
certain time then it will be classified as "Type 1". And if it is
increasing for a certain time then it will be "Type 2" and likewise
for when it is decreasing.
I want Excel to be able to automatically search through the raw data
and determine what is the type of state without myself having to
manually pinpoint it on the chart then going back and doing a manual
search and calculation in Excel. Only issue is that the exact number
determi...Third request for help with Payables Error message!
Ok I have posted this for the third time with no response! I need help
to know if there is any kind of issue on the back end of our
environment. If someone could help it would be greatly appreciated!
We are currently running GP 10 SP1 and apparently since version 8 (we
did not upgrade to 9) there has been the following error message
launching a transaction out of Smartlist, when we go to inquiry for
AP documents, and drill down of PMTRX & PMCHK from the JE inquiry
Unhandeled Script Exception:
Index 0 array of 'PM_Transaction_Inquiry_Fill' Script terminated
We ran a ...HELP
I just wrote a check to the IRS, and in the Expense Catagory I indicated
"Taxes : Federal Income Tax". Yet in the Income/Expense report, this
payment is not included in my total federal taxes paid for this month. I
should note that the check was written from an Investment Account. If I
write the check from my checking account, the amount correctly shows up in
the Income/Expense report.
Any ideas as to why it works differently, depending on which account I pay
the tax from?
In microsoft.public.money, Tom wrote:
>I just wrote a check to the IRS, and in the Expense Cat...Setting directory for file save in macro
Thanks to a generous poster I now have a great bit of code to use in a macro
for Excel which saves a text file (I'm no VBA programmer so this was really
Open "Test.txt" For Output As #1
(rest of code)
My problem now is this:
The macro saves test.txt to Excel's current active folder, rather than the
folder that the current workbook is contained in.
For example, if I last saved an Excel workbook to c:\workbooks\, and the
workbook that I have open exists in c:\workbooks\workbook1\, when I run the
macro it saves the text file in c:\workbooks\. If I ...macro recorded in xl2002 leaves a message box
I recorded a macro to move a sheet from an exp file to an xls file.
It works fine, except that it leaves this message when I delete the
sheet .. "Data may exist in the sheets selected for deletion. To
permanently delete the data, press Delete". The relavent code looks
Application.CutCopyMode = False
What must I change to avoid having to press "Delete" at the end of the
As always, your help will be greatly aprreciated.
I have an excel spreadsheet that lists every date in the year, with a
particular code in the next cell.
Monday 3/01/2005 11M 22M 32M
Tuesday 4/01/2005 11T 22T 32T
Wednes 5/01/2005 11W 22W 32W
Thursday 6/01/2005 11H 22H 32H
Friday 7/01/2005 11F 22F 32F
Saturday 8/01/2005 11S 22S 32S
Sunday 9/01/2005 11N 22N 32N
Monday 10/01/2005 11M 21M 33M
Tuesday 11/01/2005 11T 21T 33T
Wednes 12/01/2005 11W 21W 33W
Thursday 13/01/2005 11H 21H 33H
Friday 14/01/2005 11F 21F 33F
What I need is to be able to search by the code eg "33T" and have all the
dates listed for ...Urgent help with CStringArray
i need to return a CStringArray from a class method, but CStringArray (and
CStringList also) doesn't have a copy constructor!
I want avoid memory allocation within the metod because I don't want to
force the class user to deallocate pointers... this is the piece of code:
const CStringArray MyClass::MyMethod()
return StrArray; // this will generate a missing copy constructor
"Gaetano Sferra" <firstname.lastname@example.org> wrote in messag...vlookup help #3
I cant figure out the proper syntax for the attached workbook. Th
first 8 options on worksheet two work perfectly ( ie when checked, the
appear on worksheet 3) I dont know how to apply the formula of th
first 8 options to the rest of the checkboxes.
Can someone please help me figure out how to do this? Thanks i
Attachment filename: start order2.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=46674
Message posted from http://www.ExcelForum.com
Right-click on the sheet tab for the Options worksheet.
Select View ...Bill Pay Help
I just signed up for Bill Pay (I have Money 2005), I'm not sure how to
coordinate Bill Pay with my Bills list and my checking account register. It
makes a separate Bill Pay register, but won't allow me to merge it with my
checking account (as Help suggests). Tech support was completely useless, in
fact it seems they're in a hurry to get us off the phone.
...Just Help Me
Hello All . . .
Please answer the questionary in the following URI
Thanks a lot . . . :D
Post the question here, and we might.
(replace somewhere in email address with gmail if mailing direct)
"CorfuVBProgrammer" <email@example.com> wrote in message
> Hello All . . .
> Please answer the questionary in the following URI
> Thanks a lot . . . :D
...Help revising slow code
I am using the following code to remove all the lines in a worksheet that
have a zero value in Column H. Because there are thousands of rows in the
worksheet, this loop takes forever! Does anyone have any suggestions for
doing this more quickly? Thanks!
Dim Firstrow As Long
Dim LastRow As Long
Dim Lrow As Long
Dim CalcMode As Long
Dim ViewMode As Long
CalcMode = .Calculation
.Calculation = xlCalculationManual
.ScreenUpdating = False
Say i have multiple sheets dated 04/01/10 to 04/30/10, each contain names,
say A, B, C, D, etc... but these name does not appear in the same order in
each sheet. Now data is in time format in front of A, B, C, D, etc.
Eg. in sheet 04/01/10
like this data in other sheet till 04/30/10.
Now in a new sheet i want this data to be collated in time format in front
of the individual sorted in Alphabetical order. Also it should give me the
Sum of the data.
Is it possible and how?
Thanks in advance for the help!...corrupted PST file
I have Outlook 98, running on XP, on a PII 400Mghz Dell
desktop. My PST file is about 1.95GB. It has been
running extremely slow, and has had to be restarted a
bunch of times in the past 2 weeks. Yesterday, it gave an
error that the PST file was corrupted, and that PST file
need to have the Inbox Repair Tool run on the file, and
then the system restarted. I ran the Inbox Repair Tool on
the PST, and it did not work. I am totally unable to use
the file, which has all my critical contacts and emails.
If someone could help out, I would be MOST grateful.... I
pulling my friggin ...Autofilter help
I have 4 columns of data with an auto filter on - all ok
I then reduce my selection so I finally only have one row of data - all ok
Not ok: Problem: Is there an easy way that I can copy the data in the top
row of the filter, to another worksheet page - so if the filter is changed
so top line shows new result - still copies over the data in the top row of
Bearing in mind that the top row could be I.E. Originally Row 8 or 108
depending on the selection.
Autofilter Line = 1 2 3 4
eg Result of A/F a a a a <== copy the result of this line to
dif...Help need for .net assembly in Workflow manager
A simple code (given below) creates a task thro' .net assembly . I invoked
this code via console application & found that it is running fine. It is
creating task in CRM successfully.
The problem is : when I included it in Work flow manager, it displays that
"task completed" in workflow monitor but it is not creating a task in CRM .
/// Summary description for Class1.
public class Class1
// TODO: Add construc...Referring to a FileName in Macro
I have a Macro with the following code
TestQry is the name of the file. Is there anyway that this macro cod
can refer to the activeWorkbook or filename so that if the file i
saved to a new name this macro will still ru
Message posted from http://www.ExcelForum.com
How about just:
"DoctorV <" wrote:
> I have a Macro with the following code
> Application.Run "TestQry!Macro2"
> Application.Run "TestQry!Macro1"
&g...Macro Copy and Paste
I am currently trying to copy from one workbook that has 7 differen
tabs and paste into one worksheet on a separate master workbook. M
problem is that when I set up the macro to copy from one of the tabs i
the workbook and paste to the other work book, I only want the the row
to come in where there is data. Currently I am having to run a macr
that takes every 100 lines, but ideally I only want the informatio
copy and pasted where there is only data.
In addition, once I have copy and pasted everything from the first tab
my next step is to copy and paste information from the second tab t