plz help me .......[plz].....[i need a help [ :( ] ]
hi , every body;
i want to write an easy program;
if u have time plz write that code for me
i want to write a program that it gets a number from user then save it
i mean to see tahat number ever time that i want at that file
i need a help
On Mar 7, 6:04=A0pm, sahel <nam.nam.baro...@gmail.com> wrote:
> hi , every body;
> i want to write an easy program;
> if u have time plz write that code for me
> i want to write a program that it gets a number from user then save it
> in filestream
> i mean to see tahat number ever time that i want at that f...Charting data as 'boxes'
I have an x-y chart (y is a date axis) and a series of
events happening along the x-axis. The x-axis is the
position along a datum, and I'd like to show a 'box'
starting at one x value through to a second x-value to
define where the event is happening; then the top and
bottom of the box define the start and finish dates.
I can store the data in a table easily enough,
[ID;Startx;Endx;Starty;Endy] but is it then possible to
use it to define the four corners of a box and get it to
draw a series of 'boxes' on a chart ??
Hope this makes sense !
J...Need inserted lines to print in correct position on Excel graphs
The aim lines and trend lines that I inserted into the Excel graph appear in
the correct position on my monitor screen, but when I print the graph they
appear higher than when seen on the screen. How can I get the printed lines
to appear in the correct position?
Did you use shapes to draw the lines? You could try changing the Move and
But the best solution would be to create the lines using dummy series.
Andy Pope, Microsoft MVP - Excel
"Lavonne" <Lavonne@discussions.microsoft.com> wrote in message
news:D4CD...Need rotation schedule with 6 tables of 6 people for all to meet o
I am trying to develop an algorithm for a networking session. I need a
rotation schedule so that everyone will get to meet everyone only once. I
will have 6 tables of 6 people at each table for a total of 36 people. I
have the tables lettered A B C D E F and 1-36 people numbered and want to
rotate everyone through so they all get to talk to each other just once.
On Fri, 13 Apr 2007, in microsoft.public.excel.charting,
sccyclist <email@example.com> said:
>I am trying to develop an algorithm for a networking session. I need a
>rotation schedule so that eve...Transfer form data
In access 2000, how do I transfer form data to MS Word?. I would like to use
something like transferSpreadsheet which I use often to transfer data to
I would prefer not to create an Access report and then use "Publish with MS
Word". This method does NOT faithfully reproduce the report.
> In access 2000, how do I transfer form data to MS Word?. I would like to use
> something like transferSpreadsheet which I use often to transfer data to
> I would prefer not to create an Access report and then us...Links in Excel 2000...need help
Would you happen to know how to switch the setting in
excel so that when I doubleclick on a cell with a link to
another tab (worksheet), it will take me to that tab and
specifically the cell referenced?
Maybe you can use a worksheet formula.
David McRitchie has posted these formulas that he uses.
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
but you meant like what hap...Data Markers
Can I change data markers so that it reflects the conditional formatting on
that cell? For example if the data in column c is being plotted and the
conditional formatting I have on the cells are if column D = "Y" can I have
it so that those markers are plotted with a circle marker and the rest with a
square marker? Thanks!
Have a look at Jon's page for conditional charts.
> Can I change data markers so that it reflects the conditional formatting on
> that cell? For exampl...How can i stop same data being repeated in a column
I have a list of contract numbers relating to application numbers or
payments. they are in the format nnnnnnan or nnnnnnpn. The columns are fixed
to this format only. If they are entered with the a or p in the wrong place
or if they have been left out completely an error message will appear to
alert the user. I want to know how to alert the user if they enter an
application or a payment number that has already been entered.
ie if they enter 022079a4 but that same application has been entered else
where in the column.
Hope you can help
See Chip Pearson's
http://www.cpearson....Problems XSLT Transformation of XML Data to EXCEL 2000
Does Office Excel 2000 support XSLT transformation of data from XML cause am
having problem when the attachment is opened in the client side if the Excels
version is in Office 2000
and also its works fine if the Office Excel Version 2002 and up
when attachment file is open via browser the data is in a single line of
string in the first row of the excel worksheet
Glenn Gomez wrote:
> Does Office Excel 2000 support XSLT transformation of data from XML cause am
> having problem when the attachment is opened in the client side if the Excels
> version is in Office 2000
>...Urgent: Creating a gaprh from two existing polynomial garphs
Please some one let me know the procedure how to draw a graph from two
existing graphs(which are polynomials). Please provide me a URL which
explains the process in detail, if possible.
This is really urgent for me, Thanks in adance
You have two charts, each with a series and a polynomial trendline? Copy one
chart, select the other, and from the Edit menu, use Paste Special and
select the All option. This adds the series from the copied chart to the
other chart, plus any trendline and non-default formatting.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom ...How to read B-LOB data from Oracel DB using Pro*c
I'm trying to read B-LOB data in Oracle Database using Pro*c.
I know how to read it with char mode.
What I want to know is read it with binary mode.
Are there any good person help me?
Let me know if you have a good sample source.
Thanks and have a nice day.
...Migrate data from 1.2 to 3.0
Hi Can i use the data migration framework to migrate data from 1.2 SBS to 3.0
Professional after doing all the required mappings ?
Is there an easier way to have data from 1.2 SBS moved to 3.0 Professional?
Unfortunately you cannot move data between deployments. You can only upgrade
the existing CRM 1.2 deployment to 3.0. There is no 1.2 SBS Edition, so you
may have to redeploy the 1.2 environment to a new place, then upgrade the
MCSE+S, MCT, Microsoft Dynamics Certified Master
> Hi Can i use the data migration framework to migrate d...I need an Excel Genius !!!!!!!!!!!!!!! Headers/Footer Changes
I think I need some work around code. I have two workbooks named QG and
Add-In. Add-In contains all the code to manipulate data in QG. I have two
option buttons in Sheets("QUOTE") in QG. Each option button represents a
company. When an option button is clicked the code below located in Add-In
is called, which changes the Header and Footer to represent that company.
The code works fine, but there is a fault. If the Logo is moved to a
different folder the code fails.
Is there a way to store the two company logos (.jpeg) in one of the
workbooks so that when one...deleting a calendar series needs new option
When you have a series for a meeting appointment and after a year there
is no longer a meeting your first impulse is to delete the meeting
series from your calender.
When you do this it deletes all past, present and future occurrances of
It would be really nice if the delete had an option to say from here
forward so you can preserve history in the calender.
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...Cannot open document in email because it needs excel. How do I d.
I have inbound email that will not open attachment becausse it is on excel.
How do I open this document?
Assuming you do not have Excel installed.
Download and install the Excel Viewer from....
You will be able to view and print Excel worksheets.
Gord Dibben Excel MVP
On Sun, 7 Nov 2004 17:04:04 -0800, "fred" <firstname.lastname@example.org>
>I have inbound email that will not open attachment becausse it is on excel.
>How do I open this document?
> I have inbound email that...#N/A And Data Labels
I created a bar graph, for each month I am displaying
three items. For future months I use the value #N/A so the
graph will ignore it.
My problem is that the data label picks up the #N/A rather
than the correct value for the last month. For example if
my values are Jan=2, Feb=3, Mar=5 and Apr to Dec = #N/A,
the graph prints correctly, but the Data Labels show
Jan=2, Feb=3, Mar=#N/A.
Any thoughts, thanks
The #N/A data labels will all be clustered around the bar with the last
value, in your case Mar. I think you will find Mar data label is there
To get the dat...Need help to sync Outlook with laptop
I am new to Office (2003) Outlook and would like to find a wizard or step by
step instructions on setting up my Vista Laptop to sync with my XP Desktop on
the same network. I need to keep both my Outlook calendar and e-mail in sync on
both computers. I have no idea how to get started. I'd appreciate it if someone
would point me in the right direction. -Bill
A good start is here:
Bill R MVP
"William" <email@example.com> wrote in message
>I am new to Office (2003) Outlook and wo...Migrate data from one CRM server to another
I need to install a portuguese version of microsoft crm, but actually,
we have a english version, and with much data like accounts, contacts,
opportunities, etc... inserted.
I try to use de redeployment tool to install the portuguese version
and import our data, but on the install of microsoft crm portuguese
version, I got a error saying that SQL not match the correct version,
and don=B4t let setup continue the installation.... maybe a bug....
So, what I need to do is export ALL (or almost all) data from the
english version, uninstall crm, reinstall the portuguese version and
import ...Bank One users .. Please read
Are you using the same username and password to access accounts etc through
Bank One web site as well as Direct Link (online access) feature in Money
2004 (or earlier)?
I am unable to use my username/password (8 characters) that works on Bank
One web site, to access account information in Money 2004. This is for Bank
One in Ohio.
Bank One tech support thinks that it should. They think that the same
username/password is used for both functions.
However, MS Money web tech support insists that a different
username/password (4 characters) is needed for the Direct Link feature in
I am ...File Error
After performing an append query on a list containing duplicates, I
exported the new table as a new sheet into a pre-existing Excel file
containing approximately nine other sheets.
When I click on the file to open it, I get an error message stating
File Error: Data May Be Lost. When the file opens, the first worksheet
appears to be fine, but the other nine plus the new one that I exported
from Access are jumbled as if the file had been corrupted.
I tried the "Open and Repair" option but to no avail. Is there
anything I can do to restore the data? I am an intermediate level
us...MailMerge - merge with data in Excel
++Using Word&Excel 2000 on Windows 2000++
If I am doing a mail merge in Word with data in EXCEL, than Word supposes
first Excel-Row to contain the field-names and the following Excel-Rows
contains the data
Can I organize things in the other direction :
- field-names in the first Column instead of Row
- data in the next Columns instead of Rows
My intention is to achieve a better navigation and better view upon the
data, without using a form
Is the impossible possible ?
Thanks in advance - paul
...Have many Visio 5 Drawings that I need to see
How do I open Visio 5 drawings in a newer version! Why is
this product not backward compatible? If I have to redo
drawings everytime an upgrade occurs, can I backbill
Please Help!! Phone support for this product is horrible!
Except for version 1, Visio has always been able to open files created by an
John... Visio MVP
Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
"Rich Farmer" <firstname.lastname@example.org> wr...Initilizing Project Data
I am looking for the best way to backload open project accounting data in
order to build the WIP and deferred revenue so that I can then use the proper
revenue recognition processes in GP when I complete the project.
Can this be done?
Yes, You can use V9.0 Integration Manager with the Project Timesheet object
What you do is create a dummy employee called WIP and then bring in one TS
line per Project with the extended cost equal to the Project WIP to date. Do
not post to payroll. Only to Project.
This will get your projects costed to the cutover WIP with a single
t...Using Data Stored on External Drives in 64 bit computer
I have a 32-bit computer using Windows XP Pro and I have two externaol hard
drives with a lot of important information. When I get a new computer, 64-bit
with Windows 7, will I be able to use the data currently stored on my
external hard drives with the new 64 bit computer using Windows 7?
On 7 Apr., 18:38, moon <m...@discussions.microsoft.com> wrote:
> I have a 32-bit computer using Windows XP Pro and I have two externaol hard
> drives with a lot of important information. When I get a new computer, 64-bit
> with Windows 7, will I be able to use t...Best approach, Editing existing data.
Hi, I have a workbook with 2 sheets in it. One called master the othe
called data. I have created an input userform that takes the data an
puts it into the data sheet. I now need a way to bring up that sam
data to be able to alter it.
All the data for each vendor , with the vendor name first, is on on
line in cells a1, b1, c1 etc...
I have a combobox with the linked cell at c14 on my master page wher
the name of the vendor I want to edit will appear.
I need a way to edit that data. Any Ideas
Message posted from http://www.ExcelForum.com