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...Business Portal Error-SQL server does not exist or access denied
We are running business portal 4.0 for one of our customer. It was running
correctly, however, they have changed the SQL server port (previously it was
set as default 1433). After that the business portal becomes very slow and
while creating a new request (purchase requisition) if we open the item pop
up; it is showing exception
"SQL Server does not exist or access denied...."
Can any body tell me how can I provide the new port number to business
portal connection to the database.
Thanks and Regards,
Thanks for using the newsgroups. I have a...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...chart MAcro to change on activecell
Here is the macro below.. The only problem is that the columns change every
month. so range (columns)keeps widening.... I have sorted it by selecting
range upto column N. so it is provided for all 12 months.
But now the "Grand total" column which is always the last column also gets
included..(.which shouldnt be included in the range for the chart)
Is there a way to modify this macro ?
Dim ThechartObj As ChartObject
Dim Thechart As Chart
Dim Userrow As Long
Dim CatTitles As Range
Dim SrcRange As Range
Dim SourceData As Range
If Sheets("summary").Ch...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?
...crm 3.0 error 03-01-06
I'me getting this error while installing crm3.0 for SBS:
"error writing to file microsoft.mshtml.dll verify that you have access to
That file is in the C:\Program Files\Microsoft.NET\Primary Interop
I (and 'everyone') has full access to that dir.
What can I do about this??
...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...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 ...Error in Outlook Today
Whenever I go to Outlook Today, I get a runtime error,
line: 297 Error: Class Not Registered. Then I get the
error two more times when I click 'Customize Outlook
Today...' and the list 'Show Outlook Today In This Style'
is empty, and the box under it has a broken image icon.
What could be the cause of this?
Sorry...forgot to say...I'm using Outlook 2003 Student
and Teacher Edition on Windows XP.
>Whenever I go to Outlook Today, I get a runtime error,
>line: 297 Error: Class Not Registered. Then I get the
>error two more time...Macro for Sharepoint List and another Table?? Same # records?
I am creating a database which we have a form made up of prepopulated data
(from a sharepoint list) and also data input needed by a user (for example,
I have two tables: one sharepoint list that is linked to sharepoint website
and another table that houses the additional user inputs [table 2]. I have
linked the files based on the primary key. So, every record in my table 2
has a plus sign and it will expand and you will see the linked data from the
Is there a way that I can automatically create a record for every
corresponding record ...Re: 'Uknown Error 0x800CCC97'
I just heard back from the folks with whom I filed this bug. They say the
bug is fixed in cppop 5.4 - request that your ISP upgrade to that.
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeff Stephenson [MSFT]" <firstname.lastname@example.org> wrote in message
> See the attached reply to another similar question. Your ISP's POP3
> has a bug, and they should get a fixed version of the server.
> Jeff Stephenson
> Outlook Development
> This posting...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...How to unlock locked cells by MACRO?!
I have locked Sheet and I need to change particular cells. But when my
macro wants to change it => ERROR :/
Is there any way to unprotect these particulary cells by macro and
change them? - after that action, of course, I want to lock them again.
Please help me, Pedro
Just unprotect the sheet, do the work, and reprotect the sheet. Kind of like:
'your code to change stuff
Petr N�me�ek wrote:
> I have locked Sheet and I need to change particular cells. But when m...stop error defeating me
XP Pro PC. When I start the computer I can start in safe mode but when I try
to start in normal mode it loads to the log on screen. I type the username
and password in then it starts to load but stops after a few moments with a
blue screen. The error is Stop: c000021a (fatal system error)
The windows subsystem system process terminated unexpectedly with a status
of 0xc0000005 (0x7c9106c3 0x0055f36c).
Begininning dump of physical memory.
I have uninstalled AVG, also taken out the graphics card and uninstalled all
the drivers for it. I have also changed the RAM. I have also d...Error in database....
A user posted a batch in payables management. After posting, there was an
error encountered. It displays that the table updating was interrupted, use
batch recovery to continue the posting. But when I used the batch recovery,
it was not successful to continue the update process. When I click the "More
Details" button it displays, A save operation on table 'PM_Transaction_WORK'
caused a sharing error.
How can I resolve this issue?
John, it is a db sharing violation.
Have all users logout
DELETE dynami...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...Macro to seperate data
I seem to be struggling to find a macro that will work in previous threads.
In sheet 1 is a list of data in columns A:N and the number of rows will
vary. It is a list of sales with each sale record ocuppying one row. The
salesperson's name is in column C and each salesperson will have multiple
What I am trying to do is create a seperate summary sheet in the workbook
for each salesperson. Therefore sheets 2 to 20 are templates that already
exist with a different salesperson's name entered into cell C3 on each of
I am trying to find a macro that ...how to make macro work even a sheet is hidden.
I have macro assigned to a button in Sheet 1 which goes to sheet 2.
Press a button to Refresh and then PRINT preview
It does work in normal state.
I do not want the user to see the Sheet 2. I hid sheets from
but the macro is not working when sheet 2 is hidden.
how to overcome this error
"can't execute code in break mode"
the macro code is
Application.Run "'Latest 2009Payslip.xls'!Sheet2.HURows"
...Creating a Macro to Delete Commas #2
I have an excel file that the size will varry. I need a macro that will
check all the fields for a comma. If there is one I would like to get
rid of it. Does anyone have any idea how to do this? I have no idea and
I have been assigned this task.
Message posted from http://www.ExcelForum.com/
No macro required.
ctrl-H for find/replace. find , replace nothing (leave the
replace field blank). You can of course record that within
a macro if you wish.
>I have an excel file that the size will varry. I need a
macro that will
>check ...error 553
The following error occurs when sending email from my
business domain. It does not occur when sending through
my roadrunner account.
The following recipient(s) could not be reached:
on 10/22/2003 2:05 PM
553 sorry, that domain isn't in my list of
allowed rcpthosts (#5.7.1)
What does this mean and how can it be fixed?
...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
> ...Adding a Macro to a VLookup Function
In Excel 2000 -- I would like to create a summary spreadsheet (sheet2).
For each time that "Name" appears in sheet 1, row *, take information from
the same row, but columns 2 and 6 and bring it over to sheet 2 in the
I know that you need to do a "VLookup" function and I got that to work. I
know that you also need a "Loop" statement, so that it will continue to
perform the Vlookup and bring over the information for each time that the
name appears. I don't know how to write the formula so that the VLookup and
the Loop are combined.
Examp...80070005 error #2
I am getting this error when trying to view public folder
property from system manager. My issue is same as what
you can find out from
Anyone has a clue?
...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.