I have created a template in word which I call through a VB script from
excel. The excel data is populated in the word every time I run this script.
Everything works fine and the data get populated.
I have a header in the template which is represents one of the fields in the
excel sheet. The header shows the correct linked value for the first 10 pages
but then on shows the variable name instead of the value. I have no idea why
it does that?
can someone help
The code is as follows:
For iCurrentRow = 1 To iLastRow
If ActiveSheet.Range("B" & iCurrentRow...Can Outlook emails be stored as a .eml file??
I'm wondering how does Outlook store emails when it is
used as a mail client over the internet. Are the emails
stored in .eml files as with outlook express?
Outlook stores everything in a single .PST file - you can save individual
messages as .msg or .txt etc, but not .eml
Not sure what you mean by "used as a mail client over the internet" and how
it pertains to file formats....
> I'm wondering how does Outlook store emails when it is
> used as a mail client over the internet. Are the emails
> stored in .eml files as...Auto Search When File Opens
Is there a way to configure a spreadsheet so it automatically comes up with
the FIND tool as soon as the sheet opens?
Is there a specific group of text that you want to find? A macro could be
written to find it. Otherwise, try CONTROL F.
> Is there a way to configure a spreadsheet so it automatically comes up with
> the FIND tool as soon as the sheet opens?
You can have a macro run each time that the workbook opens:
Worksheets("sheet1").Select 'open to...Outlook issues after Exchange migration
We recently migrated Exchange 5.5 mailboxes to Exchange
2003 on a new domain. This was performed with the exmerge
utility in a 2 step process. Now there are 2 issues with
1) When a user types a recipient name into the address
field, the name autocompletes as normal. But when the mail
is sent, a message returns saying it is undeliverable.
However, if the user goes into the Contacts folder and
from there selects the same user to send a message to, it
2) If a user shares a calendar, specifying the user with
whom to share and the level of permissions, all users in ...Taskbar issue
I'm hoping someone can help me with this long-standing problem with both XP
and Vista on separate laptops and every computer I've had (except I think
Win98). I'm thinking there may be no solution, but what it's worth a try.
With both of my machines, I have the taskbar (as well as other toolbars) set
out to maximum size - typically half the screen - and to auto hide. (This
makes a great program and file launcher)
The issue is that the operating system decides it wants open the taskbar on
its own from time to time on its own. Various things prompt this, ma...DST issue
I entered the catalog item:
<Feature Name="Item" CatalogItemId="Item:MS:sysgen_timesvc_dst" />
and confirmed that the device has the registry key:
HKLM\Software\Microsoft\Clock\AutoDST = 1
But the device still does not automatically adjust for DST. I set the
timezone to Pacific, set the time to 3/14/2010 at 1:59AM, waited for one
minute...and the time changed to 2:00AM instead of 3:00AM.
What am I missing?
which OS version are you using? have you updated it with the relevant qfes
which deal with the changing in DST starting day?
-...Outlook/EX Email Issue
I'm running Windows XP with XP Professional. I cannot send email but I can
recieve it using Outlook. There error says that Outlook was unable to access
the SMTP server. I cannot access my email at HOME through the web email. What
I can do is send/recieve email using Outlook Express AND I can access my
email through my web email client outside my home. My ISP (SBC) says its not
them and I'm somewhat inclined to agree with them? They say I could have a
corrupted kernel32.dll file. I have turned off my Norton, deleted my account
and set up a new one and re-installed XP professiona...hello everybody.. question about .CSV files.. 05-13-10
i have a excel .CSV file that Gmail generated for me with my contacts in..
what i want to do is function that go over all the contacts emails one by
one and deletes all missformated addresses that cannot be use to send email
for them.. somthing like :
if (the cell's text is not an valid email address)
delete the cell ;
to be honest i dont know much about excel so i need somthing from
thank you all very much..
The trick being.............how will Excel know the cell's text is not a
valid email address.
Did you have some format in mind that...Possible Report Issue
Hi. I'm working on a database for a safety audit. The auditors would like to
be able to use some of the tables and subtables as a sort of checklist for
the audits. The table/subtable structure is as follows:
I decided to create a report that will output that data. However, the report
is only outputting information if there are ProgramRequirements already
entered for a given ProgramArea. Is there a way to get it to output the
ProgramArea and ProgramRequirement even if blank? Or am I going about th..."file in Use"
Has anyone found a way to delete a file that is supposedly "locked for editing" by the only user on the computer? This usually seems to happen after a "page error" hangs the pc, and then the file (and its directory.... oops sorry "folder") can't be deleted - even in DOS
I'm using Excel 200 under Win 98
go to the temp directory and delete all files there
This should free it up.
"Kev" <email@example.com> wrote in message
> Ha...Extender Install Issues
GP 8.0 Extender install - I'm encountering the following:
*Login to GP brings up screen: "Great Plains Extender needs to finish
installing. This may take a few minutes". It has an OK button and clicking
on this gets you into GP but it comes up everytime. How can we stop this
from popping up all the time.
*When creating a new Extender Window and I get select the Form, I get the
following error: "A remove range operation on table
'PT_User_Defined_Window_Keys' failed accessing SQL data." Procedure or
function zDP_EXT40101L_1 has too many arguments spec...MacDolt file
I am taking a college class and need to prepare a problem using a MacDolt
file. I have searched my excel to see if I have this file and can not find it.
Can you please tell me how to find it for XP or how to download it from
Thank you for any help from anyone.
We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are
unable to send documents to PDF from GP - the PDF option remains grayed out.
We have folowed the KB articles that are available, no success. Do we need to
install Adobe 9.0 due to running Windows 7? Is GP 9.0 compatible with Adobe
9? Thank you for any assistance..
I have a client using Adobe 9 on Windows 7. However, they are on GP 10.0
It is working succesfully.
> We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are ...Deleting files
When using explore and I want to delete files from my 'c" drive I sometimes
get the error code that I do not have access to the file. The system will
not let me delete or even open the file. What can I do? Thanks
Depends on what and where that file is.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Jane M." <Jane M.@discussions.microsoft.com> wrote in message
> When using explore and I want to delete files from my 'c&q...Issue with formula is Pivot table
I have the following formula in a pivot table:
First to the issues that I am experiencing. First, the formula wa
originally added as the one below but then updated to the formula abov
to correctly reflect what I was trying to accomplish.
This issue is the original formula appears in the very first cell o
the pivot table and then periodically through out the column. So, yo
see ...Outlook Web Access OWA Issue - Login Prompt for Images
Dear Outlook 2003 / Exchange 2003 Users,
Starting over the last two weeks (possibly after an update on the
Exchange server), all of my users are starting to encounter the same
issue when using Outlook Web Access (using IE6 on XP Pro systems). We
have images in our signature block, and now when someone replies using
Webmail to an e-mail originally sent via Outlook 2003, a login prompt
appears for each image in the e-mail. Every time you cancel the login
box, a red x image box appears, until all of the images that should be
there are represented by the red x boxes. For the record, this has
w...Hyperlink Issue #2
I have an issue with hyperlinks. When you click on the hyperlink on a
webpage it returns an error stating that the the "item could not be
created". Outlook 2000/Windows 2000
...Show a CHM file
Is is possible to get a CHM file displayed inside a CHtmlView? When I do
Navigate2("filename"), the window shows 'page not found' and opens the file
download standard dialog. If I press 'open' the correct file opens, but in
an external window! I want to show the CHM file inside my application in the
window I have created for the job - is CHtmlView the wrong class to use?
...How do I use a server name in an Excel chart file path?
Currently, I have a chart in my open workbook that was copied from an
external workbook and I have changed all the file locations to match where
the data is coming from in the original workbook. However, the source file
is on a shared network drive on a server that is mapped under different names
on each machine on the network. I have tried changing the links to the
standard '\\server\drive\directory' format as shown below, but to no avail.
The chart 'source data' dialog boxes do not allow this and say the "Reference
is not valid. Reference must be to an open wo...Update Issues
Has anyone experienced any problems with XP Pro updates sent in Feb.? My
Lenovo T61p has performed flawlessly for 2+years but suddenly started turning
off and now stays on but freezes-up. I can’t detect a virus and seems like
the Feb. updates are all that has changed.
I plan to uninstall them….between freeze-ups, unless someone has a better
>Has anyone experienced any problems with XP Pro updates sent in Feb.? My
>Lenovo T61p has performed flawlessly for 2+years but suddenly started turning
>off and now stays on but freezes-up. I can�t detect a ...How to block Zip files
I just noticed that outlook is letting users accept any file as long as it
is in a zip file . I want to now block Zip files. How do I do this?
You can do this by installing the admpack.exe available in the Office
Resource Kit. Other options might be available on your corporate firewall or
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and Restore
-Create an Office XP CD slipstreamed with Service Pack 3
"AlanM" <firstname.lastname@example.org> wrote in message
>I just noti...Excel file is opened twice
I have Excel 97-SR2(m)on a Windows NT4 Sp6a workstation.
Everytime I open an specific workbook this is opened twice.
This file is located in a network folder. No macros in the
Any idea about why this behaviour?.
If one has :1 at the end and the other has :2 at the end, then what has happened is that either
intentionally or unintentionally, someone has used the feature Window / New Window which will
allow you to see two copies of the same workbook at the same time (Can be very useful sometimes as
you can tile the windows). When a file is saved in this mode it wil...unprotect file: response to Truman's no help
I have password protected a file, and now that the
untrustworthy employee is gone, need to unprotect it. When
I click on 'Tools', then 'Protection', it doesn't offer
the choice of 'unprotect...' as promised in HELP. The
response to Truman's issue (posted 7/25 7:45 pm) was too
complicated - I'm not an IT person.
Any suggestions? Thank you!
If you protected the file, you can save it again, without a password:
1. Open the file, entering the password when prompted.
2. Choose File>Save As
3. From the Tools menu, choose General Options.
4. Delete the ...Shared file keeps losing connection
I have a shared workbook, and sometimes when I work on it, it seems to lose
connection with the shared file.
(as it happens, its a 2003 file operating on both 2003 and 2007, but I don't
think that's related to the problem)
The workbook has VBA modules in, nothing very complicated though.
and I get the following message:
'You are no longer connected to this file. Another user may have removed
you, or saved over it.'
The file is always still there, and we haven't been removed. It is
infuriating for everyone involved. Is there a way of getting it to
automa....csv with double quotes
Worker in office has been "saving as" a csv file for well over a year.
Suddenly when I save it now it creates a csv file that does NOT hav
the quotes around each field as it had before. Not much information o
Google about this.
Even tried saving with CSV for Windows and CSV for Dos and both wit
and without the Worksheet.
SWMagic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2666
View this thread: http://www.excelforum.com/showthread.php?threadi...