Hyperlink has changed on file re-opening
[Excel 2002, Win XP Pro]
i have cells in a sheet whose cell contents are hyperlinked to wor
documents. the hyperlink is generated using VBA. part of the fil
name includes the '[' and ']' characters (square brackets)
when the macro is run, everything works fine (click in one of the cell
and the appropriate word file opens) BUT when the workbook is closed an
re-opened, the '[' & ']' is changed to '%5b' and '%5d' respectivel
(which i guess is some srt of charatcer code for those symbols)
if the hyperlink macro is re-run, it 're...Using Publisher for long reports
I write long reports (50 pages) in which layout and style are very important.
I'm thinking of switching from Word to Publisher since Word's management of
pictures and layout drives me wild.
Can anyone advise me if Publisher might be the right choice?
Does anyone have some long document templates they could show me?
It sounds like Publisher would be perfect for you since you indication that
the layout is important. I can't help with a sample tho because (1) the
longest I've done is about 24 pages and (2) my newsletters contain personal
contact information and...how do I create qif files from Excel for import into Quicken?
Want to import a bunch of financial data that's in Excel into Quicken.
Can I create a QIF file from Excel?
You'll need a converter utility for this. Here's a google search that might
> Want to import a bunch of financial data that's in Excel into Quicken.
> Can I create a QIF file from Excel?
See if http://xl2qif.chez.tiscali.fr/xl2qif_en.php
suits your purpose. Don't forget to back up the folde...How can I use my calendar and other features wo using Outlook emai
I have Windows7 OS.
I upgraded to MSO 2007.
I cannot access the calendar, etc. without setting up an email profile which
my ISP will not allow using the email address.
How can I use my calendar and other features without using Outlook email? I
could use the calendar on previous versions without setting up an email
Why can't you use Outlook w/o a mail profile? What happens when you try?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft....Can I delete OE and just use Microsoft Outlook 2002
I would like to delete Outlook Express is this advisable?
I am going to be using Microsoft Outlook 2002 which I
recieved w/Toshiba PDA and already have it set up on the
same PC as OE. Can I use Microsoft Outlook for multiple e-
Differences Between Outlook and Outlook Express
With Outlook, you can integrate and manage e-mail from multiple e-mail
accounts, personal and group calendars, contacts, and tasks.
"Delia Marlowe" <email@example.com> wrote in message
news:780901c4025...How do I open doc's from Publisher 2000 when I am using Pub 2003?
I recently purchased Publisher 2003 and can't seem to edit any document from
a previous version.
Are you running Norton AV? Try disabling NAV Script Blocking
Click Options. If a menu appears when you click Options, then click
NortonAntiVirus. The Norton AntiVirus Options
dialog box appears.
Click Script Blocking.
Uncheck Enable Script Blocking (recommended).
Restart the computer if prompted to do so.
MVP Microsoft [Publisher]
"GAR" <GAR@discussions.microsoft.com> wrote in message
news:01222D01-7A00-4...Contacts File Link?
I have several computers on a home network and WLM does a fine job of
keeping the contacts in sync on all the computer. I am giving one of the
systems to a friend. What is the best way to un-sync the contacts file on
the system that I am giving away so they can have there own contacts file?
Uninstall WL and reinstall with a new WL ID or Passport?
Create a new Windows user.
Remove the old user.
MS MVP- Windows Live Mail
"Ken" <firstname.lastname@example.org> wrote in message
> I have several...Export to Text Files Based on Field Value
I have an Access table with personal information (e.g., first name, last name,
birth date, etc.) for thousands of people. The table is sorted by state. I
want to be able to run a macro on that table that will create separate pipe
delimited text files for each state with all fields included.
Any help would be appreciated?
Message posted via AccessMonster.com
Instead of exporting the table, export a query based on the table. You will
have to have some code that loops through the states and modifies the quer...Referencing .NET 2.0 but end result uses .NET 3.5
I'm using DevStudio 2005 and I have a project that references
System.dll ver 2.0.50727 and I accidentally compiled code that used an
overload that only exists in version 3.5 because my intellisense
I tried to compile it on another machine that never had the .NET 3.5
install and it wouldn't compile and the intellisense had that version
of the overload yet both references looked identical; looking at ver
2.0 of System.dll
The method in question was WaitHandle.WaitOne.
WaitOne...How to import Eudora files into Outlook
I've searched the forum, and everyone seems to have already been able to
bring their old Eudora files into Outlook. I am now trying to do this
but cannot figure out how. I'm not even sure exactly where to find my
Eudora files, much less get them over to Outlook 2007.
Can someone help me here. My hard drive crashed last Friday and I have
rebuilt a new one except for my email program. I have been using
Thunderbird temporarily, but I really don't like it. My Eudora files
are saved to a hard drive and Thunderbird imported them with no
problem. But I can't for the life of me figur...Is there a way to extract files from the Off line files cache
I have a laptop that used to be a member of a SBS 2003 domain and was
utilizing folder redirection of My Documents. The laptop was never
reconfigured to remove it from the domain and the user continued to use the
Since that time (about a year ago), the computer and user were removed from
the SBS domain.
So far so good, the user on the laptop was happy..
Today, the laptop was worked on and was removed from the domain. Now, the
question is, where are the files that used to be in My documents? I
beleive they are cached in the Offline files folder (C:\wind...File Stuck In Outbox
I have a 6 MB file that can not be sent or deleted from my inbox. I followed
the "Assistance" suggestions on the MS web site but had no luck.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-tips.net/...How to delete a .mny file...
I'm new to Money 2003. I imported Quicken 2002 data, and
for some reason, one or two accounts did not completely
I repeated the import and opened a new Money file (with a
new name.) This time it went smoothly. Simple question:
can I just delete the old Money file I first created? Is
it as simple as going to "my computer" and deleting the
appropriate .mny file?
Thanks for any response.
In microsoft.public.money, EL wrote:
>I'm new to Money 2003. I imported Quicken 2002 data, and
>for some reason, one or two accounts did not completely
>...Using a drop down box to select all results
I have a summary page which pulls data together from several sheets an
displays summary statistics etc.
I want to be able to use a drop down list to select particular product
and only show data relating to those products
- so far so good.
But ..... having put in my drop down and referenced it in my formulae
now cannot show the summary data for ALL products.
Is there a wildcard that can be used in drop downs to select all
Message posted from http://www.ExcelForum.com
You could add (All) to your list of products, and check for that
selection in the formula. For example:
=IF(A2=...using interop to create document word 2007
I am using c# and word interop to open a mailmerge document fill it in and
then display it to the user. Once i display it the c# app has nothing more to
do with the word document. The user can edit it as needed and then save it as
a pdf and that is fine.
The issue is I would like to set the default path for the document and it
could be a network drive or sharepoint and will change every time also it
will never be where the original document was opened.
...Can I use Free Excel Viewer 97/2000 in Windows XP?
Microsoft downloads doesn't list the free excel viewer compatible with
Windows XP. Is there a free download to view and print excel spreadsheets,
that's compatible with Windows XP?
The Viewer for Office 97/2000 works fine under Windows XP.
Gord Dibben Excel MVP
On Fri, 22 Oct 2004 15:11:01 -0700, "Linda" <Linda@discussions.microsoft.com>
>Microsoft downloads doesn't list the free excel viewer compatible with
>Windows XP. Is there a free download to view and print excel spreadsheets,
>that's compatible with Windows XP?
An...using excel from dotnet
I'm working on a new app in vbexpress 2008 using acad com interop
Also need to write extracted data to excel.
At home(laptop) i have excel 10. At the office excel 12.
(both seem to have excel5 listed in refs.)
I need to work at both locations.
can i reference both 10 and 12 in the same vbproj (i think not)
can i just reference 5 and is that just an older version with common (but
not the latest) interface?
i guess i can just have 2 vbproj files (one on laptop one at work) and just
copy the .vb class files that are being edited back and forth, not cop...convert or open .pub file
I have recieved a file with a .pub extention. I do not have publisher, any ideas on how to open it, and readers that I can download. No trial is offered for this program to download? I tried acrobat distiller (microsoft said it would work) but it dosent work
> I have recieved a file with a .pub extention. I
> do not have publisher, any ideas on how to
> open it, and readers that I can download.
Best bet would be open it in the Publisher version
that created it. There are no Publisher viewers.
Here's some info you ma...creating a program that uses data from a sensor....
I want to create an MFC program that uses parameter values passed to it
from a meter (specifically the resistance in ohms of resisters in an
electronic circuit). What are the hardware components that would be
needed? And what MFC class(es) would I use to accomplish this?
On 21 Oct 2006 08:10:50 -0700, "RAB" <email@example.com> wrote:
>I want to create an MFC program that uses parameter values passed to it
>from a meter (specifically the resistance in ohms of resisters in an
>electronic circuit). What are the ha...how to use outlook w/o exchange server?
Trying to use outlook and cannot send/receive email. error msg 0x8004010F. I
work from home, have no employess, no need to share address book. Just
trying to use it w/ a new PDA I have. The exchange server appears to be a
fee based service - I don't know. I just want to use Outlook to schedule my
appts, keep contacts and use email.
SMScott <SMScott@discussions.microsoft.com> wrote:
> Trying to use outlook and cannot send/receive email. error msg
> 0x8004010F. I work from home, have no employess, no need to share
> address book. Just trying to use it w/ a new PDA ...how do i ignore a number when using MODE function?
I have a list of numbers that I want to find the MODE in:
But I want to be able to ignore the Zeros
How do i go about doing this so the mode function gives me the #2 only
Dev4me's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29709
View this thread: http://www.excelforum.com/showthread.php?threadid=498091
which is an array formula, so commit with Ctrl-Shift-Enter
(remove nothere from the...Unable to run excel macro after changing file name
After changing the filename in an excel macro, receiving Error number 5 -
Invalid procedure call or argument when users with excel 2000 run the macro.
Users with excel 2003 are not having this issue
Post the line of code that is causing the error.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"merf" <firstname.lastname@example.org> wrote in message
> After changing the filename in an excel macro, receiving Error
> number 5 -
> Invalid procedure cal...Using VBA to find a value and select a range
I am trying to write a macro that will let me find a specific vale in a
specific column, then select part of the row that the value is in, beginnign
with a column 31 cells away from the column that the specific value is in.
Someone suggested to me that I use an IF statement, but this is all I know
IF [value in column B] is “Grand Total” Then select from column AF to the
end of the array in that row and copy it and paste a transpose of the values
starting in cell I9 of worksheet X.
What is the best way for me to accomplish this goal?
Does this macro do what you...Using TEXT and &TEXT
I'm familiar with the TEXT function, but sometimes a number will display
incorrectly when I format numbers to display with a comma if 4 digits or
more. For example, TEXT(F1,"0,0") will display 10 thru 999 correctly and
displays 1000 correctly as 1,000, but displays 1 thru 9 as 01, 02, etc.
Also wondering how to format part of a TEXT formula to underline, and bold
or color selected words.
Maybe you want:
If this doesn't help, maybe you could post the values and what you want to see
for a few exa...Help with Links to Files
I have a file in Word 97-2003 compatibility mode. When I select the Office
Button / Prepare I see an option to Edit Links to Files. If I convert the
file to 2007 format the option for Edit Links to Files is no longer there.
Where did they go?
This is strange. The Edit Links to Files option should be available even if
you save in Word 2007 format. Are you sure you didn't inadvertently break
the link to the automation object?
You could press Alt+F9 to see that the field code for the object is still
intact. (Note that you can only see the field co...