Getting Excel Cell Address..
How do I get the cell address of an excel sheet from C#?
=Address(4, 5) would return "$E$4"
Not able to find an equivalent function when processing the excel
sheet from C#.
Thanks in advance for all the help.
are you trying to formulate formulas into the spreadsheet?
whatever function you can access via vba, you can access the same way using
office interop regardless vb.net or c#
- if you don`t need the formula in the spreadsheet but just need to display
the value in spreadsheet
or if you are just using your 2 dimensional array to set value into the
spreads...Compiling problem (MSVC6.0)
I have a project that used to compile in a few seconds. It still does
in Debug mode. But in Release mode, now it gets stuck:
And it will generate code her for say 5mins, before moving to the next
file. Why has this suddenly started happening? Might I have a corrupt
> I have a project that used to compile in a few seconds. It still does
> in Debug mode. But in Release mode, now it gets stuck:
> Generating Code...
> And it will generate code her for say 5mins, befor...How to remove all styles from the Quick Style Gallery
Word 2007 SP1
XP Pro SP2
Problem: How to remove all styles from the Quick Style Gallery
I have many styles in the Quick Style Gallery list.
I would like to have only a few listed.
Is there a way to quickly remove all the styles
in the Quick Style Gallery list instead of having to remove
each style individually using the context menu?
Thanks in advance.
To clear all quick styles in the active document, you can run the following
Dim s As Style
For Each s In ActiveDocument.Styles
If s.Type = wdStyleTypeCharacter Or _
I have a listbox on a userform which displays the computers name :
Is there a way to have a command button check this code against a string
within the command button code which will do the following
1) if the code matches, a second userform :Userform2 is shown
2) if the code doesnt match a warning is shown and the command button doesnt
open the second userform
Can anyone help?
The principle is exactly the same as in your other post. Something
along these lines:
Function MayProceed() As Boolean
Const ...Any other formula to add 6mth to a given dates..
I had a column of dates and would like to use a formula to determine th
next dates which is 6 month away. I tried using =workday(A1,C1), wher
A1 to A50 is a series of date and C1 is 180(6mths), but the result giv
me more than 6 mths. I had tried using =date(2006,4+6,15) but i had to
many dates to key that. I understand that Excel function of "workdays
and "Networkingday" refer to 5 days week. Is there any formula o
function that I can use for 6 months for a equipment that is workin
24/7 basis, Excel don't support this
-------------------------------------------...Still getting Macro Security Warning Message after removing Macro
Excel 2002 SP3
Win XP Pro SP2
I had a macro in a spreadsheet which I ended up not needing.
I removed it by going to VB Editor and removing the module containing
However, I am STILL getting the Macro Security Warning when opening up
How do I get rid of the warning? Or Could there be any trace of the
macro left causing this warning?
When going to View Macros (Alt+F8) that is blank/empty.
Go into the VBE once more (Alt-F11) and check if Modules is showing in
the Project Explorer Window. If so, then right-click on the module and
click on Remove M...Removed Information Service
I deleted my personal folder option in the information
service to try and recreate a problem a user had. Does any
one know how to return it short of reinstalling office?
Can't you just click "Add" on the list of services and re-add Personal
What version of Outlook?
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Felix" <email@example.com> wrote in message...How do I remove margin tick marks?
I have these L-shapred "tick marks" for the lack of a better term, appearing
at all four corners of my screen where the margin begins. They are in gray
like gridlines, but I am not sure how to remove them. Can anyone help?
See this article:
Margin marks or crop marks appear on each corner of the page when you open a
document in Word
Microsoft Word MVP
"Susan" <Susan@discussions.microsoft.com> wrote in message
>...Removing time from a date field
There is a date column in my excel spreadsheet. The data in this column
has both date and time. I want to strip off the time part using VBA.
Please let me know if there is an elegant way to do this.
I found the answer. I used the INT function.
Change the format to date
"kulalosai" <firstname.lastname@example.org> wrote in message
> There is a date column in my excel spreadsheet. The data in this column
> has both da...Perhaps another Money alternative?
After years of their saying "what's Windows?" I not that the following
Announcement: GnuCash 2.1.1 Release - 2007-04-28 17:47
GnuCash 2.1.1 released
The GnuCash development team proudly announces GnuCash 2.1.1 aka
"Bug-begone", the second of several unstable 2.1.x releases of the GnuCash
Open Source Accounting Software which will eventually lead to the stable
version 2.2.0. With this new release series, GnuCash is available on
Microsoft Windows for the first time...
I haven't checked into this further just yet, but that will certainly be...Relinking Tables with VBA code
I got this wonderful code from the internet to relink all tables from
a backend database in the same folder.
Unfortunatelly its not working: The code gets me the right folder (see
MsgBox (strPath) but after that it links only the first table but not
Can anybody tell me what's wrong in the code?
Thank you very much!!!
On Error GoTo MyError
Dim db As DAO.Database
Dim strPath As String
Dim i As Integer
Set db = CurrentDb()
strPath = Left(db.Name, Len(db.Name) - Len(Dir(db.Name))) &
"social_performance...How to incorporate voice commands into a VB6 application on XP?
On my new PC, which is running XP, I have been playing around with
How can I get my VB6 program to respond to voice commands? VC works
with, say, Word straight away. I don't have to configure XP or install
anything. I just rand through a couple of the training exercises and
then I could dictate into Word or switch to Voice Command mode and say
things like "file open".
I once experimented with Microsoft DirectSpeech in VB6, but I had to
download a ton of SAPI stuff first.
Ideally, I would not want a user to have to install anything other
than wh...Formula for deleting "
I have imported a CVS file delimited on commas.
I got "" in beging and end along with numeric data in each
cell. Data is in more than 1000 rows with 10 columns.
I want to remove these commas and change the cell format
to numeric without lossing any numerical data.
Thanks in advance.
have you tried 'Edit - Replace' for this operation?.
You may also have a look at:
> I have imported a CVS file delimited on commas.
> I got "&quo...Retrieving data from another workbook (path?)
Please can anyone help. I've done the searches and can't find an
clues...I think maybe my question is just too simple....
I am getting a macro to password protect a worksheet with a password i
a specif cell in another open workbook.
....works perfectly for inputting the password from within the sam
workbook, but I'm blowed if I can find the code for referencing
specific cell in a different open workbook.
Logic tells me it should be
Password:...Excel formula reference book recommendation
If anyone has any recommendations on a good reference book
for excel relating to formulas, please let me know.
If you are reasonably proficient with Excel then look no further than John
Walkenbach's 'Excel Formulas 2002/3'
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
-----------------------...GET FILENAME WITHOUT EXTENSION
i've this macro string for write a filename (that i select) in a cell
without the extension.
In this case the filename remove only the 3 letters of extension. I need a
remove more long extension (filename.
how i can modify this?
Dim FName As Variant
Dim wb As Workbook
Dim MyPath As String
Dim SaveDriveDir As String
Dim filename As String
SaveDriveDir = CurDir
MyPath = "C:\"
FName = Application.GetOpenFilename(filefilter:= _
"Pictures(*.jpg;*.gif;*.bmp), *.jpg;*.gif;*.bmp")...Removing a window's frames does not remove it from the scrollbar
I have a dialog box with a tree control that will automatically holds a
scrollbar. In the dialog's OnInitDialog I load the tree with so much content
that the tree automatically creates a vertical scrollbar. I want to remove
the tree's frame, but when I do the frame is removed from everything except
the scrollbar. It isn't until I move the mouse over the scrollbar (causing
it to highlight) or force the bar to scroll that the frame will disappear.
I have tried invalidating and repainting the tree but that does not help. I
have even dragged the dialog box offscreen and pull...Removing server from routing group
I have an exchange 2003 server that is a part of its own domain and forest,
but this exchange server is in our exchange routing group. I want to
unsintall exchange from this server, but in order to do this i have to turn
the system on, when i turn the box on it creates routing issues within our
routing group. I want to know if its possible to remove this server from the
routing grouo if the server is off line.
...Removing watermarks form Word2003
edI have been through I think all the posted problems and answers and I seem
to a have a new manifestation of a watermark (picture) that refuses to
I inserted a watermark and resection the document. Some how the watermark
down sized itself so is actually of no benefit. I have tried the "remove
watermark" approach in format background but it doesn't actually see it? So
then the no fill approach and searched headers and footers for any marks or
anchors, zilch, nada, nothing. I found some strange achors possibly related
to drawings in the document so re...Usage of CRM 3.0
Is there any obligation by downloading the beta? I mean, I am willing to
download it , but only to play a little bit with it, to understand the
internal (SQL) structures, because I have customers with CRM. But nothing
else (by now).
Any ideas? Thank you for your time (and patience with me)
SQL Server MVP
You can download MSCRM v3.0 for testing purposes. You cannot use this
version for production implementations (key is only valid for 90 days).
In case you do fi...Formula so that response is >value
The same cell has two formulas, IF(D3>0,LOG(C3/F3),IF(D3<1,LOG(C3/10)). For
example, if C3 is 1.0E+06, D3 is 100, then F3 will be 1.0E+03 (due to another
formula), and the response for the first part should read 3.0. If D3 is 0,
F3 will be <10 (due to another formula), and the response should read >5.0,
not simply 5.0.
I'm not sure I follow your formulas as described, but if you're looking to
have your results display the ">" character along with the value, then maybe
this example will lead you in the right direction:
Let's say cell A1 contains ...Formula to format selective part in a text
In MS Excel, in th below formula what additional formula do I add to make
selective text in different formats (ex. bold)?
Ex: ="Mission 1 Start Date: "&text(A1,"DD-MMM-YYYY")
In the result I want only the date part of the result text to be in bold
Thanks in advance.
No can do in a FORMULA. You must convert to a string
Microsoft MVP Excel
"Gladiator" <Gladiator@discussions.microsoft.com> wrote in message
news:7E825FD9-C276-43CF-BFB4-A7F3D6FB932E@microsoft.com.....query returns no records, need to convert to "0"
my query returns no records, but i need it to be a zero value because that
answer is used in a report that totals several items. Without a number (0),
the totals won't work.
If the report is based on a query that returns no records, and you have a
text box in the report footer that is bound to an expression like this:
it displays #Error.
If you want to show a zero instead, change the expression to:
=IIf([Report].[HasData], Sum([Amount]), 0)
Avoid #Error in form/report with no records
-...How do I permanently remove deleted e-mails from my inbox? they h.
I delete messages in my inbox, a line is placed through them, but they never
go away! how do I clear them permanently. I am running Outlook on Office xp.
IMAP connection? Edit-> Purge Deleted Items...
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"bhmdorf" <email@example.com> wrote in message
>I delete messages in my inbox, a line is placed through the...how to get elements of DistributionList by c#
hi all. i want to get elements of DistributionList by C# with Outlook
2007. i had name of DistributionList and i like to get all elements of
DistributionList with that name. what should i do?? thanks for your
"khoick245" <firstname.lastname@example.org> wrote in message
> hi all. i want to get elements of DistributionList by C# with Outlook
> 2007. i had name of DistributionList and i like to get all elements of
> DistributionList with that name. what should i do?? thanks for your