Close Worksheet and Making Worksheet Invisible
I use this (pardon the variable names...)
infile = "C:\Temp\Garb-Tests\Test1\solTrip.xlsx"
insheet = "Trip"
Set o = Workbooks.Open(infile).Worksheets(insheet)
Reading data from this works. However, this causes the sheet to open, but I
don't want that so I do:
o.Visible = false
When I do this, ths sheet still opens but it opens without any data!
Also, when I try to close this workbook using:
o.Close (false, false)
I get a runtime error 438 - Object does not support...I cant see pictures inserted into word/publisher
On reopening the files I can't see pictures inserted in Word or Publisher.
I'd suggest start by updating your graphics driver.
MVP Microsoft [Publisher]
"Ahsan" <Ahsan@discussions.microsoft.com> wrote in message
> On reopening the files I can't see pictures inserted in Word or Publisher.
...Publishing to the web through Publisher
i've just downloaded a trial version of publisher and love it so far except
it will not publish to my hosting provider, Godaddy.com.
I have completed all of the steps required per directions found at:
Everything is great until I get to the end when I get this message:
Publisher could not save the file to the web. Check your your url or network
connection and try again.
If there is any advice or technical support that someone can give please let
me know. I would love to purchase this product but I don't want to sp...publisher #74
can I repeat an image in publisher? like a line every 1/4 inch for example.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"MargaretK" <MargaretK@discussions.microsoft.com> wrote in message
> can I repeat an image in publisher? like a line every 1/4 inch for
Copy the line, place your cursor where you would like the line to paste,
right-click, paste. It could be helpful to create guides. Or select the line,
press...Installing Publisher 2003 gives an error
I am trying to install Publisher 2003. Even before it comes up with the
Product Key, it gives the message "This patch package could not be opened.
Verify the patch package exists and that you can access it."
I have Office 2003 Basic Edition installed. I uninstalled the Office and
then tried to install it but still it comes up with the same message. Did
some research and used the Windows clean up utility but to no avail.
Any help appreciated.
You receive the "This patch package could not be opened" error message in Office
2003, in Office XP, or in Office 2000
http://...Sending Publisher Files
Just got this software last week with no manual, so Im
kinda flying by the seat of my pants here.
The question is Ive put together some promotional flyers
I need to send to my customers, but I feel confident that
most would not have publisher to read them.
Can I format them another way and still keep the flyer
looking like it should?
Check out the following link on sharing Microsoft
Microsoft Publisher MVP
>Just got this software last week with no ma...Confused as to publishing a web site with Publisher
I apologize for using the "General Questions" forum, but the Web Design area
doesn't seem to get much response to questions (as I have previously posted
there), and this area does and I could really use the help.
Here are the steps I've gone through.
I created a site in Publisher.
I have acquired Yahoo as my web hosting provider.
I attempted to upload my files the way Yahoo, and many other "help" sites
say, by using Publish to Web, but kept getting firewall errors.
Therefore I installed SmartFTP and uploaded my .pub file successfully.
Then I realized I can't...Publisher 2000 #23
After adding a new profile on a Windows 2000 box,
Publisher decides not to work (Publisher has been working
many years previously on this desktop).
I'm getting the message: "This application must be
installed to run. Please run Setup from the location
where you originally installed the application." I tried
the resolution to Article 269276 but that did not work.
If anyone has a suggestion or resolution, it would be
very much apperciated.
...how to make a formula to be "&"s formula
could anybody tell me something about the way to make a formula to be "&"s
i mean that, for instance ,make =D22-G28-D26 to be =D22&" $B!](B "&G28&" $B!](B
for i like the show the detail of the formula,instead of the result.
Dnia Wed, 17 Nov 2004 21:47:43 +0900, EXCEL NEWS napisał(a):
> could anybody tell me something about the way to make a formula to be "&"s
> i mean that, for instance ,make =D22-G28-D26 to be =D22&" − "&G28&&q...how do I open up publisher 2003 files in publisher 2000
I received an e-mail with a pub2003 file and am unable to open it with
pub2000. Please help
Contact the person who created the file and ask them to save it as a Pub
2000 file. There is nothing *you* can do other than to upgrade to Pub 2003.
MVP Microsoft [Publisher]
"jeanrix" <firstname.lastname@example.org> wrote in message
>I received an e-mail with a pub2003 file and am unable to open it with
> pub2000. Please help
Outgoing mail is certified Virus Free.
Checked by AVG anti-viru...Publisher 2003
I recently uninstalled norton, added macafee, did a compression and defrag
and may have deleted a file or two . . . :P Anyway, now when I try to open
Publisher or a Publisher file from explorer, I get the error 1304 message
asking if I have access to program files/microsoft
I have access to this file and can see it from explorer. How do I correct
this issue so I can run Publisher again?
Thanks in advance for helping this noob!
Operating System? Publisher Version?
By the way, left the frying pan (Nortong) and jumped into the fire (McAfee)
"...Make User Date update on 24/7 Great Plains session.
I'm using Great Plains 8. I have a 24/7 SOP Great Plains process running on
the server. The orders imported use the 'User Date" to set the imported
order's 'Order Date' value. The User Date does not increment on it's own.
Can anyone tell me a way to update the User Date on this un-attended Great
How about a GP macro that changes the user date and then add that macro to
run using Windows Scheduled Tasks? Never tried it but should work.
"Kevin R" wrote:
> I'm using Great Plains 8. I have a 24/7 SOP Gr...How do I make a graph ignore zero's in Excel 98
I set up a chart that graphs changes in quantity over time.
It's source data comes from multiple different places in my
spreadsheet, so, to make it easy to graph, I use formulas to set it
out nicely.. namely, two rows, the top with date and the bottom with
Problem is, that everyday I have to copy the quantity grabbing formula
over to the next column.
If I leave the formula pre-copied right across, it skews my trend line
and makes my graph look terrible because it dives down to zero.
If I don't copy the formula, I miss the latest set of data.
Essentially, I just wan...upgrade publisher
I have a similar question to Issac. I want to upgrade my
Office 97 suite to the latest version, but Office XP does
not seem to contain Publisher (?), how can I get my
Publisher version, off of my Office 97 Pro Ed up to date?
I am getting Publisher files from newer eds that I cannot
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from dfran <email@example.com>...
> I have a similar question to Issac. I want to upgrade my
> Office 97 suite to the latest version, but Office XP does
> not seem to contain Publisher (?), how can I get my
...Microsoft Publisher ?
Are you able to insert pictures and tables with it?
I currently use Microsoft Word for a lot of things but one problem I
run into and I hope can explain this correctly. I insert a picture and
want to type next to the picture but text has to be put on line below
picture which takes up space that I need.
Also not the right message board but can you insert pictures in an
excel spreadsheet and put text next to picture?
Thanks in advance for help and suggestions
In Publisher, yes.
MVP Microsoft [Publisher]
"tran" <firstname.lastname@example.org> wrote in message ...Why is publisher newsletter not page wide when sent
When I am working on my email newsletter it is page wide. When I send it it
is about 4" wide. I want it to be page wide when it is sent to a client.
What do I need to do?
What do you call "page wide"? If you had started with the email template,
you would not have width issues.
MVP Microsoft [Publisher]
"Donna McDermed" <DonnaMcDermed@discussions.microsoft.com> wrote in message
> When I am working on my email newsletter it is page wide. When I send it
> is abo...Visual Studio do make Deployment on Windows 7
I have tried to use the Visual studio 2005 deployment project to
deploy my C# program, and the deployment has custom action in the
Installation, but it will fail to install in a windows 7 64 bits OS
and the error code is 2869, and i have read the information from the
Internet and it seems to be the UAC problem, but i have tried to use
ORCA to change the custom action type to 3073 and tried to disable the
UAC function in the windows 7, and also tried to use an empty Install
public override void Install(System.Collections.IDictionary
...How do i make a cell look embossed or raised in excel?
I cant seem to figure out how to make a cell have a raised or lowered
effect...can someone please help me?
You just need to format the borders.
Top and Left with thick light gray
Bottom and Right with thick dark gray
> I cant seem to figure out how to make a cell have a raised or lowered
> effect...can someone please help me?
Andy Pope, Microsoft MVP - Excel
...Help Publishing Custom Form
I have published a custom task form to my Organizational Forms Library
following the instructions here: http://www.outlookcode.com/article.aspx?id=34.
It works great, and now I have 2 quick questions regarding selecting
the published forms:
1. Can I make the forms available by selecting the NEW menu, so I
don't have to choose the form, and then browse to find it? I would
like be able to select New and have it show my custom form there AND
the default task form for that folder.
2. If not, I think I am supposed to be able to highlight the task
folder, then select the ACTION menu and see ...Publisher for MAC
I would like to be able to use some of the publisher features on my MACBOOK
PRO, but have been unable to locate the software, I waited for Office 2008
for Mac and it wasn't there :( when are you going to have it available for we
If you try it you can be sure if you don''t like it, if you don''t try it
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 t...convert Publisher document to Word
I created name tags in Publisher and want to convert them
to a Word document so I and type a different name on each
tag. I did it once and can't remember how - have tried
saving the Publisher file as a Word file, but it only
saves the text, not the formatting. Help!
Hi Paula (email@example.com),
in the Microsoft� newsgroups
|| I created name tags in Publisher and want to convert them
|| to a Word document so I and type a different name on each
|| tag. I did it once and can't remember how - have tried
|| saving the Publisher file as a Word file, but it...How do I get upgarde for publisher 98 to 2000 ?
I have set up the publisher 98 but I have installed in office 2000 on my pc.
My system is run win xp so now microsoft update office 2000 SR-1 ...so what
shall I do then .
>I have set up the publisher 98 but I have installed in
> office 2000 on my pc. My system is run win xp so now
> microsoft update office 2000 SR-1 ...so what shall I do
> then .
If you want Publisher 2000, you'll have to purchase
a copy of the program. You cannot upgrade Pub98
to Pub2000...they are two separate programs.
return e-mail...Publisher 2000 Publish error
I'm working with someone using Publisher 2000 who has added an FTP site and
over a dial up connection tries to publish.
He proceeds and then gets an error as transfer seems to be attempted:
"Publisher could not save the file to the web. Please check URL or network
He is saving as a web page and then trying to upload with appropriate
I've asked that anti-virus (McAfee) and win XP firewall be off as well as a
web accelerator but the error persists.
I've Googled the error and have found scant information.
Any help is appreciated.
Try the fo...2003 publisher w/XP and 2007 publisher w/Vista
I have numerous publisher files in XP that I'm emailing to have opened in
Vista. Although the file can be opened the text is scrambled. Any ideas?
Were the files created with standard fonts? Maybe your recipient doesn't have
the font you used on their computer.
"JULIEW" <JULIEW@discussions.microsoft.com> wrote in message
>I have numerous publisher files in XP that I'm emailing to have opened in
> Vista. Although the file can be opened the text is scrambled. ...Publisher/Adobe PDF
How do I convert a document made in Publisher to an Adobe PDF?
Coni Crone <Coni Crone@discussions.microsoft.com> was very recently
heard to utter:
> How do I convert a document made in Publisher to an Adobe PDF?
For an Adobe PDF, you'll need an Adobe Product. Namely, Adobe Acrobat.
With v7 and later, simply click the button on the Adobe PDF Toolbar. In
older versions, you'll have to select File > Print and select the Adobe PDF
or Acrobat Distiller printer.
For a generic PDF readable by Adobe Reader, there are any number of cheap
and/or free applications you can use...