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...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...Office X 10.1.6 Update: Fonts missing?
> 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="US-ASCII"
After updating to 10.1.6, some fonts are missing (KidPrint, Lucida
Content-type: text/html; charset="US-ASCII"
<TITLE>Office X 10.1.6 Update: Fonts missing?</TITLE>
<FON...Need VB code to edit cell values
I need some VB to do the following please (My VB is not good enough yet)
Starting from the active cell (call it the StartCell)
In the cell to the left..
ThreeChars = Value.right(3) (the last three chars)
Value = Value - last three characters (assume value is text & at least 3
value = ThreeChars (as text, overwrite any contents of StartCell)
move active cell one down from StartCell
Examples of before/after
Microsoft MVP Excel
"Stephen Ford" <Stephen_Ford_no@spam_uwclub....Advanced find
In advance find a customer wishes to know how many of each product an account
has ordered. The Order lines, Quote Lines, Invoice Lines are not available
as output entities. Therefore no reporting on advanced find is avaiable.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message...office 2004 for mac pro edition
i'm in the market to purchase a new laptop and am
thinking of getting the powerbook. i need to buy it soon
(this weekend) and being that i have pc's in my office, i
am also thinking of buying office 2004 for mac. i
understand the pro version isn't out yet. if i were to
purchase the standard version now and wanted to upgrade
it once the pro version came out, would i need to pay the
full amount for the upgrade? or would microsoft give me
a break and either give me a discount on the upgrade or
even provide me with a free copy? thanks.
In article <5f0c01c4822d$2354dd8...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...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...Problem persisting toolbar state
I'm trying to use SaveBarState("BarState") and LoadBarState("BarState")
to remember the state of my toolbars. This works fine for all my toolbars
except 2. Checking the registry reveals that the 2 bars are not listed (at
is no matching BarID entry). When I show them from my view menu the first
(IDR_MAINFRAME) shows up docked to the right side, not where I left it. And
second toolbar (IDR_SECOND_TOOLBAR) toolbar shows up on the correct row,
i.e. I moved it down to form a second row, but has moved back to its
horizontal position wh...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/...Close "X" missing
I have a user who's Excel window displays without the usual Minimize,
Restore Down, and Close symbols in the upper right corner. That's the
Underscore, the Box and the X. I thought his screen was set too wide but I
checked that and the symbols are just not there. Is there a way to turn
these on and off in Excel?
I have two guesses...
Could it be...
xl: close button is dimmed after groupwise is installed
But my money is on that the workbook is protected:
in that d...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
>...problem customizing toolbars
I'm trying to customize my outlook toolbars (in the new
message area). When I click View > Toolbars > the
customize option is greyed out. Not sure why. All I want
to do is add and remove some buttons to the toolbars.
I'm using Outlook 2000.
Any ideas greatly appreciated.
Place your cursor in the message first; not in the Header lines.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Helen" <anonym...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...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" <email@example.com> wrote in message
> After changing the filename in an excel macro, receiving Error
> number 5 -
> Invalid procedure cal...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...Seam-Excel error when exporting file
When I export an excel file from a website the file exports with the file
name of 'seam-excel' and I can't format the cells or create a pivot table
without saving and re-naming the file. How can I get my file to not export
with that file name? Is it a security setting?
Have never heard of this problem being generated through Excel alone.
I would suggest the source would be at the website from which you are
Can you post a URL?
I'd like to have a look just out of curiosity.
Gord Dibben MS Excel MVP
On Fri, 12 Feb 2010 12:41:01 -0800, fallou...Comparing two excel files
I work with large data in excel. Most of the time I need
to match two different worksheets. Both worksheets always
have two columns that contains same data (name & ID). What
would be the best way to match names and ID to obtain a
new file with data that couldn't match? if Excel good to
do that or should I use other software like Access? please
Look at Chip Pearson's page on working with Duplicates and Uniques
Alexandra <firstname.lastname@example.org> wrote in message
news:1091601c3f335$a...Flat files to XML
How can I convert unstructured flat files into structured XML? Are
there any scientific articles and tools that handles this subject?
creating custom XmlReaders is a nice way to deal with with CSV or Fixe
width files, although don't know exactly what you mean by unstructure
Posted via http://www.mcse.m
View this thread: http://www.mcse.ms/message1165932.htm
...Transfer file from Access to Server
I work with Access 2007 as a front end to a SQL Server backend. I would like
to be able to select a file from my local desktop, then, through VBA/SQL
transfer the file to a folder on my server.
Or, store the file in a varBinary(MAX) column in a table, but then use a
SPROC to take the file out of the table and place it in a folder on the
How can I do this?
The built-in VBA sub FileCopy() will allow you to copy a file from one
folder to another.
If you want to provide a dialog that allows a user to select the file then
have a look here:
http://www.mv...How can I convert an Excel file to an address book?
How can I convert an Excel file to an address book to
import into email?
...Toolbars in Excel 2003
I have a custom Toolbar which is now not required. Despite deleting it using
View Toolbars Customize Delete and then saving the file when I close Excel
and re-open the file it was located in the Toolbar reappears.
What am I maissing
You may want to check to see if there's an addin that adds the toolbar.
keep track of the ones you toggle off/on when you're testing.
Or maybe you have an addin in your XLStart folder that's doing the work.
Close excel and windows start button|search
Move files out of that folder and test to see if you can find the probl...Create a flat file in Excel
I need to create a flat file in Excel using the pipe delimiter | as element,
and carriage return line feed as line delimiter.
How do I do this?
You could change the windows list separator (in the regional settings applet in
the control panel) to the vertical bar (just temporarily).
Then save the file as a delimited file.
Or maybe you could create a formula in another cell:
And drag down.
Then copy that column and paste into notepad and save the file from notepad.
> I need to create a...