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...Opening publisher 97 with a later version
I have publisher 97 on my windows xp and it works fine. However, I had someone refine some work I had done and apparently they used a later version of Publisher because when I loaded their CD, I got the message "Publisher cannot load files from a different version"
What can I do--does this mean I have to buy a later version to match the version he used, or do I have to buy one of those programs that can open other programs. If I do the later, will I be able to use my 97 version to make changes once I get the files open on the later version
http://www.mvps....Clients can open each other's mailboxs
I have exchange 2003. All my clients can access each
others mailboxes. When I look at the mailbox right I see
the everyone group with full access. I am unable to
remove it because it is inheriting permissions. Where can
I change this? What is weird is that my administrator
account use to be able to open everyone's mailbox and now
it can not.
have you looked at permissions at the top level of the Exchange
Organization? Looks like maybe they've been set there...also check the
"security" tab for "send as" right...
"Paul" <email@example.com> wr...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...open two different Access reports
I was wondering if i can get some help here. I have two different reports
that i want to open when a user clicks a button to view the reports for
printing. Is there any way of popping them up at the same time in VBA?
Thank you in advance
>I was wondering if i can get some help here. I have two different reports
>that i want to open when a user clicks a button to view the reports for
>printing. Is there any way of popping them up at the same time in VBA?
>Thank you in advance
Yes. Call the DoCmd.OpenReport command twic...Unable to open Outlook Express after upgrade to Win. XP
I upgraded from windows98 to windows XP Pro. Now when I
try to use OE I get two error messages.
"Outlook Express could not be started. The application
was unable to open the OE message store. Your compter may
be out of memory or your disk is full.....0x800c012e,3"
"OE could not be started because MSOE.DLL could not be
initialized. OE maynot be installd correctly"
I found a similiar problem fix for window2000 which said
to delete OE, rename the old folder, then edit the
registry and reinstall. I did the above but was not
allowed to rename the old folder and th...Is Word in Office:Mac2008 the same as PC version?
Operating System: Mac OS X 10.4 (Tiger)
If I learn how to use Word, will I be able to use the Windows or PC Version if I need to in the future for a job?
The principles are largely the same; however, as of Office 2007
(Windows)/Office 2008 (Mac), there have been significant differences not
only as far as the interface is concerned, but also the functionality in
general. Word 2007 on Windows offers far more features than the Mac version,
and, depending on your needs, this is the version you should get. However,
to give you an adequate answer, we would need to kn...Opening an *.MSG file with it's respective attachment.
The file *.MSG is a message file. This can be viewed by any editor, like
Notepad. However, when there's an attachment to it, we see garbage.
Is there a way to open the attachments present inside the *.MSG files ?
Yes, by opening it with Outlook.
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Create your own fully customized Toolbar
-Creating a Classic View in Outlook 2003
Subscribe to the newsletter to receive news and tips & tricks in your
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?
...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 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...opening .pst archives
I am trying to open an outlook e-mail archive file (pst)
that was made when I had Office 98 and transferred to my
new computer (Office 2003 Pro).
I am looking for an old e-mail that has now become
evidence in a lawsuit.
Can anyone help?
You didn't say if the PST file was on a CDR/RW, hard drive, or network
share. In any case, the PST file must be located on a local/network drive
where you have full access (read, write, modify, delete, .etc) rights. Once
the file is located in said place, you can open the PST file via File | Open
| Outlook Data File. To close the PST file when you ...Office 2003 Service Pack 3--subsequent problems opening Publisher
I run Publisher 2003 on Windows XP. On June 13, I updated my system with
Office 2003 Service Pack 3 so that I could open Word documents with the file
ext docx. Subsequent to the Service Pack 3 installation, whenever I open a
Publisher file (which I created), I get the following message: "Publisher has
detected a problem in the file you are trying to open. If you are certain
that this file came from a trusted source and does not contain harmful
information, click OK." What is causing this and is there a way to stop this
Error message when you...Excel Opens Without Displaying Workbook
I am having issues with opening an Excel file. The file opens, but the workbook is not displayed. I tried the resolution in the article XL97: Excel Opens Without Displaying Workbook (http://support.microsoft.com/default.aspx?scid=kb;en-us;158996&Product=xlw97), but neither of the resolutions fixed the problem. Any suggestions??
Are you using Excel 97?
Fort Collins, CO
>I am having issues with opening an Excel file. The file
opens, but the workbook is not displayed. I tried the
resolution in the article XL97: Excel Opens Without
Di...Opening pub files created with older Publisher versions #2
I have just upgraded to Publisher 2003 from 2000 and am having trouble with pub files sent to me for our chuch newsletter
which is using Publisher 97
The text is not wrapping around graphics boxes. Can I fix this? I really don't want to go back to Pub 200
Richard this is caused by Publisher 97 not been printer independent.
Even if you went back to Publisher 2000, unless you have the identical font
versions and printer driver you would have issues with formatting.
It sounds like the person sending you the file has a garbage HP inkjet
printer. Get them to install the HP5P laser p...Add PowerPoint 2007 to Office Basic
I have Office Basic installed on my laptop and need to add PowerPoint. What
is the most recommended, easiest and least expensive way to do this?
...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...Outlook 2003 Out of Office Reminder RPC over HTTP
I have some remote office users that have Outlook 2003 configured
using RPC over HTTP. They do not get the notice that pops up
reminding them that their Out of Office is on when they open Outlook.
Is there a way to get this to work?
...opening a .docx with word 2004
Operating System: Mac OS X 10.3 (Panther)
How can I open a .docx attachment that has been sent to me with word 2004?? Can I convert it somehow at my end or does it have to be converted from the sender end?
Thanks for any help...
> How can I open a .docx attachment that has been sent to me with word
> 2004?? Can I convert it somehow at my end or does it have to be
> converted from the sender end?
Make sure that Office is up to date (or at least in version 11.5.0 - the
altest version being 11.5.1) and install the XML convertrs you'...Freeze Excel Spreadsheet till template open first then spreadsheet
When I export the data from Access 2002 to excel spreadsheet after
select excel templates. I couldn't open the spreadsheet until i open
the template and then closed the template. I open the spreadsheet
where i get the data from Access 2002. It works.
Here is the area that I have trouble with.
'Hide warnings on the spreadsheet
ExcellApplication.DisplayAlerts = False
'Save the workbook
'Turn spreadsheet warnings back on
ExcellApplication.DisplayAlerts = True
'Make it visible
ExcellApplication.V...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...Effectively stoping open relay.
I have a client who started using exchange 2003 few days back. This client
is having more than 12 subnets starting from 172.27.50.0, 172.16.0.0 to
172.27.0.0 and 10.172.172.0 & 10.172.173.0 subnets in different location in
town which are conneted by DSL. This users are connecting to the Exchange
Most of these users are POP3 users.
I have 2 SMTP Virtual Server running. Default SMTP Virtual server
172.16.5.25 and the second for Externel.
In the Mail connector I have added only the external as the local bridgehead
In the relay properties of the internal I...Can't open 2005 data file after reinstalling Money 2005
I am experiencing a recurring problem. I have had to reinstall Windows XP
and MS Money 2005. I am now unable to open my previously converted 2005 file
or restore any backup version. I consistently get the following error
"Money cannot locate filename or cannot open it, possibly
because it is a read-only file, you do not have
permission to change it, or your disk drive is write-
protected. If you have chosen the correct file and it
cannot be accessed, you will need to click OK and then
Restore your most recent backup file."
Any help or thoughts would be greatly ap...Creating Text Box in Publisher 2007 Crashes the Application
Hello, we have a clean install of Publisher 2007 under Windows XP SP2, and
when we try to create a text box in a document, (both an existing document
and a blank document), publisher crashes. Office is fully patched.
I ran Office Diagnostics from the help menu and no problems were found and
the issue persists. Any thoughts on how to resolve the issue?
See if selecting a different printer as default helps.
How to view error signatures if an Office program experiences a serious error
Mary Sauer MSFT MVP