How do I create a Range Name?
I want to create different ranges of cells to capture the content and
duplicate on another sheet or workbook using a macro.
Just select the range of cells, hit Ctrl-F3, and add a name.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Curious" <Curious@discussions.microsoft.com> wrote in message
>I want to create different ranges of cells to capture the content and
> duplicate on another sheet or workbook using a macro.
or, select the cells and name in t...Outlook Connector Beta works with some accounts but others are problems
I just installed the new Microsoft Outlook Connector beta (I'm using it with
Outlook 2007 and BCM)and have had a little success and a little failure.
It works with two of my Microsoft Office Live email accounts (the free ones)
and not with the third (which is also a free one).
I also have a MSN account (firstname.lastname@example.org)that I've had for many years
and I thought that it definitely work with this one, and it does not.
Anyone have a clue how to get the third Office Live account working and most
also my trusty MSN account?
I should point out that I have also been using the Window...IMF: stoped working
IMF was working great, then just stopped, all settings look fine, no error
messages, email is archiving, just not going into client junk email folders.
Any help is greatly appricaited.
Is it still enabled on SMTP VS?
"John" <John@discussions.microsoft.com> wrote in message
> IMF was working great, then just stopped, all settings look fine, no error
> messages, email is archiving, just not going in...Worksheet Problem 01-04-10
So I have a couple of issues.
I go to open up a file today and try to unhide two worksheets that were
hidden, and they are gone. I can still see them in VBA, but cannot open them
and they are not visible at all in excel.
I also am having trouble inserting a new worksheet. All the options are
they, but I am not able to select insert.
Any help would be appreciated.
CHeck to see if workbook protection is activated. That would prevent you from
being able to add new sheets (or unhide). Also, in VBE, check to see if the
missing sheets have a visible status of "xlSheetVe...Working with dates in Excel #2
I have two columns with date (an effective and expiration date), for a pivot table I need to combine these two into one statement "5/1/2003 to 5/1/2004" I created a formula, example (=A1 & " to " & b1), the result is "37742 to 38108
How do I get the # to show as a date
I know that if you add an ' in front of a date it shows as text. I have several thousand records and would need to add it to each field. A way to add the ' to all the records would also be an acceptable way for me to go. I just don't want to have to input the ' in each fiel...CPropertySheet create failing when adding to dialog box
I am having problems with a class that I made that inherits from
CPropertySheet. I need to add this class to a dialog box with the
m_appPropSheet.Create(this, WS_CHILD | WS_VISIBLE, 0);
m_appPropSheet.ModifyStyleEx (0, WS_EX_CONTROLPARENT);
m_appPropSheet.SetWindowPos(NULL, 0, 25, 0, 0,
SWP_NOZORDER | SWP_NOSIZE | SWP_NOACTIVATE);
...what version of capicom do i have installed and graceful failing of createobject
Set capicom = createObject("CAPICOM.Utilities.1")
Running that produces the following error:
Error: ActiveX component can't create object: 'CAPICOM.Utilities.1'
Source: Microsoft VBScript runtime error
My question is two fold. First, why can't I create that object?
states that CAPICOM.Utilities.1 requires you have CAPICOM v2.0 or
later installed. How can I find out what version I have installed?
...Public Folder Permissions Trusted Domains
Setup: We have a 4 separate 2000 active directory domains on the same
network. One of the servers runs exchange 2000 and hosts the mail for
all domains. There are trusts setup between the exchange server
domain and each of the other three domains. Mail works fine, we have
duplicate accounts on the exchange server for the mailboxes.
Here's the problem: There are public folders that we need to add
author permissions to for users that login to the other domains, not
the exchange server domain. A user in any domain can add a public
folder, and then they have the permnissions as owner, b...GetPrivateProfileSectionName won't work in VC++.NET 2002
How do I get GetPrivateProfileSectionName function to work in VC++.NET
2002? It works fine in the 2003 version, but I can't get it to work in
the 2002 version which is what I use at home.
> How do I get GetPrivateProfileSectionName function to work in VC++.NET
> 2002? It works fine in the 2003 version, but I can't get it to work in
> the 2002 version which is what I use at home.
Oh, the error is that it is an undeclared identifier. I am assuming I
need to include some header file, but I don't know which one though I
did ...Problems installingOutlook 2002 on new computer
I just got a new computer at work and I'm trying to
install Outlook 2002 so I can "Active Sync" my Ipaq 3800
w/ this new computer. Outlook 2002 seemed to installed
just fine but when I try to open it, it tells me I need
to create a user profile. I have done this about 10 times
now and the system doesn't recognize any profiles. It
also give a 2nd error message that says that "the server
is not available". I am not trying to hook up to a server
so I'm wondering if there is a setting somewhere that is
incorrect and Outlook is looking for a server. Can
a...Dynamic Named Ranges
I have a chart which displays 30 days worth of data at a time, linked
to another workbook. I am charting a dynamic named range in the source
file however my chart data disappears every time source workbook is
closed (not cool!) need a way around this without using macros..
Apprceiate any help
...Integration Manager--log file name?
Is there any way to know the name of the log file (we're writing our logs to
text file) from within one of the "After" integration events? If we're
successful, we need to send the user an email telling them that the event is
successful. We're currently cycling through the whole folder to find the
latest one, but if there were a variable in the Integration Manager VBScripts
that I could use, that would be much better.
If I recall correctly, IM has a Document Error and Integration Error event
in the integration properties. Rather than looking at the...[Bitmap] problem loading from array
I'm trying to load a bitmap from an array using the following code :
CClientDC dc(this);//CPaintDC dc(this);
CBitmap *pOldbmp = bmDC.SelectObject(&bmp1);
where im_data.width is the width of the image
where im_data.height is the height of the image
where im_data.length is the number of bytes in the image
...Problem using a report from Access2003 to Access2007
I am trying to use a database created with Access 2003 in Access 2007 but
have come up with a problem.
The database contains a report which produces invoices for sales between two
dates. When the report is run the user is asked to input sale date From and
To (this is set up in the Invoice Query), Invoice Date and Invoice Start
Number - these two are set up as text boxes on the report. Invoice Date
conrol source has [Enter Invoice Date] and Invoice Start Number has
[Page]+[Invoice Start Number]-1. This works fine in Access 2003 and the
invoices come out correctly but in 2007 invoice ...Need help with cursor spacing problem
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Content-type: text/plain; charset="ISO-8859-1"
I�m trying to fill in a form that�s MS Word based. I�m using MS Office X on
a Mac G4 with system 10.3.4.
When I type, the cursor seems to have an extra space between the last letter
and the place where I want to put a new one. In other words, I�m unable to
align the cursor exactly where I want it to go. It makes typing almost
imposs...INDEX do not work
I have this cell containing
It stopped working.
It's supposed to fetch the last numer i a column but not the nulls
It shows 0 even though it should say 24 right now..
There's nothing wrong with your formula, although it *doesn't* need the CSE
entry (if that's what the curly brackets signify), AND it could be shortened
I would suspect something's differen...VFW webcam
I'm using Video For Windows to capture images from creative webcam in
my application. This is giving me image in size 640x480. However, i
need image in landscape resolution where width is less than height. I
tried to squeeze the captured image but its distorting it badly. Any
ideas how can we capture images from webcam in desired resolution?
see the amcap sample in DirectShow SDK
Microsoft Most Valuable Professional in Visual C++
news:1160125564.284431....System restore problem
Windows XP Home SP3.
I'm trying to do a system restore, by going to Start | Accessories |
System Tools | System restore.
I select a date, and click next, but nothing happens. I've tried several
different dates with no luck.
Am I screwed or is there a way to manually force a system restore
without using this wizard?
Thanks in advance for any help.
Try SR in Safe Mode.
Why do you want to run SR? Are you having a problem?
"Craig Schiller" <email@example.com> wrote in message
> Win...y-axis problems
When I create a bar chart (in powerpoint or excel) on my PC, the last letter
on the X axis label gets cut off when I rotate the label to run sideways. It
works fine on my laptop, but if I open the file on my PC and click on the
chart area, the last letter disappears.
This is a very common experience. Some uses add "hard-spaces" which is ANSI
0160 - hold ALT down and type 0160 on numeric pad
Other add some nonsense text (three periods) and format it with a color and
background to make invisible.
remove CAPS ...CHtmlEditCtrl
I'm trying to use this class but documentation about it is minimal.
I'd like to know:
1. How shoud I create this control to have edit mode without any margins
like after this:
<body leftmargin="0" topmargin="0" rightmargin="0" style="color: black;
background-color: yellow;" alink="red" link="blue" vlink="navy" >
2. How intercept pressing Enter to make additional operations.
3. How put any text to this control from program (no from file, address.
4. How set caret to the end of line (for instance a...My webpage only works in Internet Explorer
I have no idea why other browsers doesn't like my webpage. It's a simple
design with a background, and only a textbox that changes when you navigate.
Has anyone else experienced the same problems?
Please repost your question in the web group along with which version of
Publisher you are using and the address of your website, and we will help
you there. microsoft.public.publisher.webdesign
"Tine" <Tine@discussions.microsoft.com> wrote in message
>I have no idea why other browsers doesn't lik...Quit Excel problem
Can anyone tell me what's wrong with this macro? Its meant
to save the spreadsheet (which it does), shut down the
worksheet (which it does) and quit excel (which it
I wondered whether it had something to do with the
worksheet containing the macro shuting before excel
executed the quit, but if I take out the
ActiveWorksheet.Close, whilst excel closes I get a
Dr.Watson application error.
' Exit_Save Macro
' This macro saves the current work and quits the
Application.DisplayAlerts = False
FileN...Can anybody tell me how this works?
Set fileObj = CreateObject("scripting.filesystemobject")
fileObj.CopyFile strBackEndName, strBackupName, True
That sets a reference to FSO (File System Object), which is part of VB
Scripting. It then uses FSO's CopyFile method to make a copy of the file.
Now, since I was reading another thread you have going, I'm guessing you
want to use this because it doesn't give you the "File In Use" error you're
getting through other methods. Be aware that just because FSO's CopyFile
method will copy a file that's in use, that doesn't mean it...Problems filtering, spam is killing me
Having both an Exchange 2000 and Exchange 2003 in network.
Filtering was working fine before installation of 2003
Receive this message,even though filtering is applied to
the virtual SMTP server ip address.
"Connection, Recipient, and Sender Filtering must
manually be enabled on
specific SMTP virtual server IP address assignments as
they are not enabled
...Exch 2003/Outlook 2003 inbox sync problem
After several hardware problems on a SBS Server 2003 I can no longer sync my
inbox with Outlook 2003? All other folders sync just fine. After a manual
sync the properties of the inbox show 147 items on the server and 0 items in
the off-line folder.
I have deleted the .ost file and had outlook recreate it -- no change.
I updated to sp1 -- no change.
I logged in on a different box with OL2003sp1 -- no change.
ANY help or pointers are appreciated.