Excel 97 VBA Help File
In the MS Excel Visual Basic Reference help file contents page, I click on
Functions and it only offers me functions beginning with the letter S. So, I
have a list of Solver and SQL functions.
But what about all the other functions in VBA, for example for doing
arithmetic and manipulating dates and strings? Why don't they show up?
Are they left out because those functions are all part of Visual Basic
generally, and the Excel VBA help file is specific to the _extra_ functions
in Excel VBA? It's the only explanation I can think of. Am I right, or have
I got a corrupted help file (vbaxl...help need with VC 6.0 IDE and mfc
First let me explain the scenario where i m using this requirement.
We are Using CustomAppWizard and designing a wizard .One of the wizard
pages will Insert Composite controls as many as the user wants .
1.So i should be able to dynamically insert ATL controls without using
Insert Control Dailog.
2. can any one tell me how to dynamically create Template file in
TEMPLATE folder of resource view .
3. I want to include many files created by templet files and add them
to build by editing newproj.inf
Is it possible to do this.
4.I would even like to know if i have 2 ifles in my C drive h...Help, I cannot Save!
I created a document and locked the worksheet to protect the formulars
before creating a template for the document. But now when I open th
document and insert a new sheet using the template I created, th
document will refuse to save.
Once I click on save, office assistant will say "doc not saved". Wha
could I have done wrong? PLease help.
computerfineman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3716
View this thread: http://www.excelforum.c...Help Required
Whenever I open Outlook 2003, I am getting a dialog box which displays the
Microsoft Office Outlook has encountered a problem and needs to close. We
are sorry for the inconvenience
When I click Debug it displays a message box with the following error
"The instruction at "0x3007e993" referenced memory at "0x0000000:. The
memory could not be read"
When I click No it Visual Studio JIT debugger pops up.
I uninstalled and installed several times but still the problem persists.
Is there any regsitry entry that I've to modify/delete?
...HELP Recovering addresses and email from Outlook 2003
I had some serious driver issues that required re-installing XP from
disc. I did use the backup option and have a backup of all the old
data. And of course had to reinstall Office 2003.
Will third party software restore my old email and addresses or am I
out of luck?? Thanks for the help
> I had some serious driver issues that required re-installing XP from
> disc. I did use the backup option and have a backup of all the old
> data. And of course had to reinstall Office 2003.
> Will third party software restore my old email and addresses or am I
> out of lu...shortcut with command line switch probs
I have a shortcut set up which has the target declared as:
"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /
This works fine on my PC. Excel 2000 running on Windows XP.
Unfortunately it doesnt work on someone elses PC, who asked for m
They have the same software set up, and access to the same folde
When they try to run the shortcut, a window opens and closes almos
solotoo's Profile: http://www.excelforum.com/m...Need Help with Deleting Empty Paragraphs in Word 2003
I have written the code below to delete all empty paragraphs at the end of a
document and then place the cursor at the end of the last paragraph.
It works fine as a stand alone sub in a new doc, but fails inside the real
document that contains other code that manipulates several documents.
The failure is that it will delete the last empty para, but then gets stuck
looping inside the While...Wend because subsequent .Delete are not happening.
So, the question is why would this work in one document, but then fail in
n = 0 ...Help me identify my missing permission (Cannot open public folder) -2147217843 (Maybe Authentication Fails?)
The following snippet of code throws an error number -2147217843. When
I googled this error code, I see many references to authentication
failed. I am assuming my problem is some kind of permission related
problem on the "MyNewFolder" public folder.
-- start code ---
Dim objFolder As New CDO.Folder
Dim f As ADODB.Field
'sURL is like: file://./backofficestorage/mydomain.com/Public
objFolder.DataSource.Open sURL, , adModeReadWrite, adFailIfNotExists
--- end code --
I have code that runs before this that actually creates the
"MyNewFolder" publ...Need HELP! for Linking data
Could someone please direct me to where I can learn how to link date in a
work book. i.e., I have individual pages for each subject but I need the
data that is entered in these individual pages to transfer to the Master
without having to manually in put it.........TNX
There are not too many bits about linking worksheets or workbooks that I can
But have a look at the links below, in case they give you the information
I think it is frustratingly one of those things which is very easy when you
know how, or if you can get someone to actually show you, but if you hav...Need to add to current formula
I have this formula that will cause values to change based on the mont
that is referenced in the formula ($L$1). Currently the formul
I need to add August, September, October, November, & December to thi
formula but excel is not allowing me.
Does anyone know how I can get around this? Oh by the way
November thru April =2, May and October=4 and June thr...Help with Registration
Operating System: Mac OS X 10.5 (Leopard)
I've tried to register my copy of Office for Mac through the Mactopia page. I log in successfully, but then it just keeps on loading and doesn't refresh or change.
On 6/16/09 6:35 PM, in article email@example.comR9absDaxw,
"firstname.lastname@example.org" <email@example.com> wrote:
> I've tried to register my copy of Office for Mac through the Mactopia page. I
> log in successfully, but then it just keeps on loading and doesn't refresh or
> ...Create Exchange mailbox from command line
I'm writing a script using dsadd and I was wondering if it's possible to
create an exchange mailbox from the command line.
Maybe not exactly what you want but it may help:
For Exchange news, links, and tips, check:
"Donovan Linton" <DonovanLinton@discussions.microsoft.com> wrote in message
> I'm writing a script using dsadd and I was wondering if it's possible to
> create an ...Help about numeric type field. Thanks.
I created a SQL Server 2005 CE DB ( .sdf, version 3.0) with vs2005. And I
created a table which has 2 fields: fld1 - int, fld2 - numeric(38,25).
But I encounted an error messagebox when I tried to insert a record
The msgbox said Conversion overflows.
The setting for my numeric fld2 is (precision=38,scale=25). So why occur
error when to insert 9000000?
Thanks in advance.
...HELP! Outlook POP3 problem(s)
Hello. I am so lost. I have a few e-mail accounts set up on my computer
which retrieves my mail from a couple of different providers and deposits the
mail into my Outlook Inbox. Up until yesterday, my mail always has worked
fine. For some strange reason, my Outlook is now (Again) retrieving my
messages from all of my accounts I had set up, which are all duplicates of my
messages. There is now nearly 4,000 duplicate messages in my folders. I
can't seem to stop the download of these already retrieved messages. To top
things off, a couple of my email account login windows keep p...Spam Filtering HELP
I recently started a new job, and discovered after day one, that I had
inharited a spam mess. Now the previous admin ad installed a Symantic
Spam Server Prox which in my opinion, was a complete waste of money as
it does not allow for blocking IP addresses.
Now here is the question;
I am running Exchange 2003, and am looking at setting up the Conection
Filter under Message Delivery to block messages based on IP address.
The problem is that when I save the IPs to be blocked, I get a message
stating that the Connection filter "has to be enabled manually through
the specific SMTP virtual serv...Need macro help to close excel
I have created a button in Access2000 that opens an Excel Spreadsheet. What
I need now is assit in closing excel upon completion. I can get an excel
macro to save my file and close the worksheet, but it is not closing excel
entirely. I'm on project with this employer and could use a response today
to fix this before I leave. Thanks much to any and all. My macro is as
' SaveClose Macro
' Macro recorded 9/27/2004 by cdjohnso
' Keyboard Shortcut: Ctrl+Shift+C
ActiveWorkb...Help with simple(?) VBA function
I'm trying to selectively BOLD cells by the use of a User-Defined function.
The VBA Help topics suggest something like this:
Worksheets("Sheet1").Range("A1:A5").Font.Bold = True
When I try to use it the referenced cells are not changed and the function
Can anyone point this VBA neophyte in the right direction?
A function can only return a value.
Macros and Functions (Macros as Opposed to Functions)
If all...If Then Help!!!!
I'm stuck. I have a working macro but it needs a small tweek. The macro
executes a find statement and performs calculations from the find to the end
of the column. The problem is when nothing is found. I need an if statement
or suggestion on how to tell it to skip the calculations if there is nothing
found. This is what I have so far(with no if's):
Cells.Find(What:="RIM", After:=ActiveCell, LookIn:=xlFormulas _
, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
Selection.End(xlToRi...Odd e-mail duplication problem
All e-mails promoted or Tracked in CRM Outlook client are being copied to one
particular Account that is unrelated. The e-mails are copied correctly to the
history of the desired accounts and Contacts but also copy to one particular
Accountl as well.
As anyone seen anything like this and have any ideas what could be wrong?
Darryl - firstname.lastname@example.org -www.mtccrm.com - Only Microsoft CRM
...Integration Transactions Pls help
Can anyone let me know how much time does the integration manager takes to
upload a 10,000 lines(SOP) into GP
There are two methods of importing SOP transactions. One uses the SQL
optimized adapter and one does not. The method used depends upon the data you
would need to map. There are some fields and business logic not available
with the SQL adapter.
But, assuming you are using the SQL adapter, you should be able to import
10,000 transactions in about 60 minutes or less. If you are using the other
one, start it and go home for the night. It will take hours.
If you have some reso...Help! charts disappearing, new charts crashing powerpoint
When i open a presentation the charts vanish...i have restarted, they come
back. I try to edit a chart, and it crashes powerpoint after a few clicks.
What can I do...whole afternoon going crazy!
If you are using v 2007 there is a hotfix which is meant to cure some chart
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> When i open a pres...Column help
I have a seating chart I am trying to design for our graduation ceremony.
Right now I have the report set up using columns. I have a rectange box with
the graduates first, middle and last name in the box. I need 16 columns
across the page for the seats which I have working. My problems are that I
need a bold line going down the middle to divide the 8th and 9th rows. (
Students come in from 2 lines and meet in the middle of each row.) My next
problem is that I need to have another column to the left of the 1st column
and one to the right of the 16th column that will count the row num...Help with percent formula beginner
Hi, have a cell (A1) with $39.99. I want a cell (B1) were I can vary
10%, 20% etc and have that effect (A1). So If I put in 10% A1 would be
$36.00 (percent decrease). Can you please help me out with the formula?
Also it seems like if I type in % in a cell and I delete it and type
another number and I don't want a % in there it gives it to me anyway.
Can I make this stop?
Thanks so much
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("B1")) Is Nothing Then
Wi...difference between 2 lines in a scatter chart
I have created a scatter chart with two lines. The x axis is divided up
into 10 parts and labeled 10, 20, 30, 40, etc. What I want to do is
calculate the distance between the two lines between the x values of 40
and 60. Does anyone know how to to that? Thank you in advance.
prd02003's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25762
View this thread: http://www.excelforum.com/showthread.php?threadid=391727
How did you generate the lines?
Are they from the data directly...Bullet help
How do i insert bullets in between words or groups of words instead of having
them all down one side of the page. like if * was a bullet and i wanted my
text: (residential & commercial moves * office moves * deliverys ect....) How
do I do this thank-you
> How do i insert bullets in between words or groups of words instead of having
> them all down one side of the page. like if * was a bullet and i wanted my
> text: (residential & commercial moves * office moves * deliverys ect....) How
> do I do this thank-you