Pre formated workbook. Can it be done?
I have several Access databases and I was infomed for a quick and direty way
I can make a pre formatted workbook then use the transfer spreadsheet for my
report. I dont want the spreadsheet to lose its formatting everytime a user
runs a report. Is anyoen familiar with this process? I can do the trangfer
from Access and use the recorded macro on Excel's end but is there anything
else I need to do?
Thanks in advance
you need to save your transfer workbook as a template delete all the info out
of it and then save it again.when you open a template you open a copy,not the
template itse...Can we share Outlook Contacts on a network
Is there a way to share and/or synchronize "Outlook" contacts on a network
not natively, within outlook
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exc...Can you drag/drop rows w/o using Cut/Paste
Can you drag/drop rows (or columns) in Excel without using the Cut/Paste
keystrokes. What I would like to do is be able to highlight a row, click the
Ctrl button, and then drop it on another row where it would be moved to?
If you select the row and click on the border and drag it, you'll move it.
Experiment a little.
try selecting and dragging.
try selecting and dragging while holding the shift key
try selecting and dragging while holding the ctrl key
Heck, select a cell and rightclick and drag it where you want. When you let go,
you'll see lots of options.
...Getting data from an open file
I need to be able to run a summary file when the files
that the links are coming from are in use.
...Missing OUTLLIB.DLL File
I have installed Outlook 2003 and receive error message, "Can't open
application because the OUTLLIB.DLL is not found. I have re-installed but
didn't fix my problem.
Nan <Nan@discussions.microsoft.com> wrote:
> I have installed Outlook 2003 and receive error message, "Can't open
> application because the OUTLLIB.DLL is not found. I have
> re-installed but didn't fix my problem.
> Any suggestions?
See your previous thread. No need to post more that once.
...Attaching Help File to a User Defined Function
I wrote some functions in VBA for Excel and I would like to attach
help file to each function.
One solution was to attach the help file in the VBA project properties
but I am allowed to attach just one file per project. As I have 4
functions in that project (they all have to reamain in the same VB
project)... I have to find another solution.
What would the solution be?
maca's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2489
View this thread: http://w...Large xml file
I'd like to know what's typically considered a large xml file? Are we
talking about a file that's measured in kilobytes or megabytes and
beyond? Where do we begin to consider an xml file to be a "large" file?
Also, for small xml files and assuming that you want to perform an xsl
transformation, is it justifiable to use the DOM or is it better to use
the various xml readers and writers to do the job (although it may
require more code to do the transformation)?
Thank you for your input. Already I'd been considering the tradeoff ...Exchange mail is pulled completely into an inaccessible ost file
When I look into my mailbox in outlook, I don't see my emails; however I
notice an ost file that is large in size.
As a test, I sent myself an email from another account and I noticed it in
my outlook mailbox briefly before it disappears and subsequently the ost file
How do I stop this complete offloading into an ost file? How do I
synchronise an ost file with exchange that I can't even see in outlook but is
connected and doing work in the backroom?
is it offloading into an ost file or into a pst file somewhere?
Diane Poremsky [MVP...greeting cards pdf continued
JoAnn: I have just received your reply to the earlier thread........
I am going to install PrimoPDF as discussed earlier, BUT:
Will my current pdf files be compatible with PrimoPDF?
Will I need to Delete MS Add-in software?
Yes and no.
Your first .pdf file can be made with the add-in and the rest Primo. It
doesn't make any difference.
I don't use the add-in at all. *My* reasoning is that I don't need to "save"
Office files as a .pdf and "print" any other files as a .pdf. I try to keep
it simple and use one technique. That'...Mapping Leads to Account after Account has been converted
Okay, so I have a field in Leads in which now I am to create the same
field in Acccounts and map the two over. So I have completed that and
I have mapped the field from Leads to Accounts. It works great once I
convert the lead to account, it maps everything properly. However, my
problem is that if I look at Accounts that have already been converted
from a Lead there is nothing in this new field?? The field is mapped
properly but how do I get all of the history from this field that was
in Leads into Accounts? I am using 1.2. There is an originating lead
field under accounts that will...HELP��my computer crushes when I open the same EXCEL file again
If I open another EXCEL file same name as anyone I have opened, my computer
hangs and all freeze. I have to shut down and switch on again. I can not
stand it because I have to work on many EXCEL files at a time, and computer
may freeze if I open the same file again carelessly and I may lose my work
data. Other things are all ok.
My OS is WINXP PRO SP2, and OFFICE XP (EXCEL 2003). Who can tell me why?
I'm not sure why your pc freezes, but excel only allows one open workbook per
name (in the same session).
> If I open another EXCEL file same name as anyone ...Can't reprint packing slips
For some reason, nothing comes out when I try to reprint packing slips. I go
to Transactions>Sales>Print Sales Documents, then fill in all the appropriate
information - including checking the Reprint Previously Printed box. I get
the print dialog asking for the print destination, but when I click on 'OK',
What am I missing?
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Currently supporting: GP 9.0, SP2
This may be a dumb question but......when in the process are you attempting
this? If the order has been in...CONVERT PDF TO JPEG
I would like to convert a pdf file to a jpeg if possible.
need answers fast please
I was able to do it. I have Adobe Acrobat 6.0. In fact it converted a 20
page newsletter to 20 jpg files. Just used "save as".
Bob Miller 727-343-4436
"Lisa" <Lisa@discussions.microsoft.com> wrote in message
> I would like to convert a pdf file to a jpeg if possible.
> need answers fast please
> I would like to convert a pdf file to a jpeg if possible.
>...Can't open in safe mode
My outlook is freezing on opening. I went to open using
Run and adding '/safe' to the command line. I get a
message saying it can't find the command. I tried in and
outside the quotes, as well as other /switches. Same
message. Will open without /switch, but that won't help
me fix the freeze problem.What to do next?
You're probably quoting it wrong then. It should look like this;
"C:\Program Files\Microsoft Office\Office11\Outlook.exe" /safe
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Create an Office XP...Excel opening *.doc & *.txt files
I'm stumped, I've installed WinXP PRO SP1 and Office XP PRO SP3 when I
try to open a *.txt or *.doc file (by double clicking in file
explorer) Excel opens up and gives me the error that the file is in
the wrong format. I've right clicked the files chosen "open with"
"choose program" chosen Word and checked the "always use" but it
eventually defaults back to attempting to open with Excel. Now that I
think about it when I open Word and do a file open it says all of my
*.doc files are in the wrong format and refuses to open *.doc files
created at work o...How can I disable outgoing email being sent as attachments?
When I send email I am being told from the person receiving it that it has
been sent as an attachment that they have to open to read. How do I disable
JERMAINE <JERMAINE @discussions.microsoft.com> wrote:
> When I send email I am being told from the person receiving it that
> it has been sent as an attachment that they have to open to read. How
> do I disable that feature?
Try sending your message in plain text.
If the high contrast setting is turned on you won't see the fill colour.
There's information in the following MSKB article:
OFF: Changes to Fill Colour and Fill Pattern Are Not Displayed
Excel FAQ, Tips & Book List
I'll hazard a guess.......more info would have been nice.
If this is a problem with all files with coloured cells, the Windows OS high
contrast setting may be turned on. There is information in the
following MSKB article:
OFF: Cha...where can I find file cp561401.cab?
I am trying to install Office 2003 into a new laptop and it is looking fo
rfile CP 561401.CAB. I can't seem to find it on line. Where can I get it?
Cab files are on your Offoce CD.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"rutt" <firstname.lastname@example.org> wrote in message
>I am trying to install Office 2003 into a new laptop and it is looking fo
> rfile CP 561401.CAB. I can't seem to find it on line. Where can I g...Can't logon after IP change
After an migration to a new ip subnet We can't logon to CRM with any user
After Authentication and display of the web interface we get a generic error
When using the deployment manager we get a specific message that
mscrmdervices is not responding and it shows the old IP address.
Is there a configuration file some where that tells the apps what IP the
MSCRMService is listening on?
I already checked the IIS site bindings and they are on the new IP.
If you are changing the server name/ip that CRM is on you also need to
update the registry of ...Upload/Update files on a server
(sorry for the cross post as my post in WindowForm gets no reply yet).
I'm not sure if this is the right group to ask. Please let me know
where this question should go to.
I have a window program in which I would like my users to be able to
upload files to a centralized folder risde on a server. One way to do
this is to make that centralized folder a shared folder and grant
users rights to access their files on the server. However, my network
administrator would prefer my program to logon to the server with a
separate credential (local account to the server) to upda...The file artgal50.mmc is in use by another application
I keep getting "The file artgal50.mmc is in use by another application"
message when it is not being used by anything else. Any help?
> I keep getting "The file artgal50.mmc is in use by another
> application" message when it is not being used by anything else. Any
What is the name and version of
the program you are running?
If you go to the MS Knowledge Base
And search for: Artgal50.mmc
You will find several articles that
may be useful.
John Inz...File Sharing Problem with Publisher
Publisher 2000 and Windows XP
I have a peer-to-peer network using Windows XP machines.
Any time I create a publisher file, when someone else tries to open it up,
they receive a message stating that they cannot open the file due to file
sharing violations. If I save the file to their workstation, then they can
open it up.
I only encounter this in Publisher. Any thoughts?
Jeff Bendert wrote:
> Publisher 2000 and Windows XP
> I have a peer-to-peer network using Windows XP machines.
> Any time I create a publisher file, when someone else t...why i can't see menu bar?
why I can't see menu bar in office 2007 specially (Access 2007)
Because there isn't one? Office 2007 uses a ribbon rather than menus.
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"a" <email@example.com> wrote in message
> Thank you
> why I can't see menu bar in office 2007 specially (Access 2007)
...'insert file' missing file types (not all showed)
I'm facing a puzzling Outlook 2003 problem so I'm trying the forum to see if
anyone encountered similar behaviour and/or found a solution.
On 'a couple' of workstations in the company there is a problem when users
try to attach files in their e-mails. Not all file types are displayed in
the 'insert file' dialog box (yes, *.* selected). For instance .zip files
are not displayed.
There is no problem receiving these kind of attachments! There is only a
problem when trying to select these files as attachment using the 'insert
We use ...Outlook 2002
One of my remote location users is experiencing a problem
with Outlook 2002. While he's our most pc illiterate
user - he's also the boss:)
He is reporting that he can not send emails in Outlook, I
had him do a Test Account Settings and he received the
Sending mail: "Specified server found but no response
from the server"
Any suggestions, help or tips?
Same problem here with Outlook 2003 and my ISP is Yahoo
been waiting since 6/28 for them to reply to my query.
>One of my remote location users is...