Editing Text when using Publisher as a web page...
I'm using Publisher to document the status of current taskings in the office.
I'm trying to ger Publisher to allow people that pull up the web-page to add
and edit text on the web page so we can keep everything up to date. Right
now, someone has to come to me and tell me the changes, then I change the
info in the Pub doc, then I have to repost the web-page. Is there a way for
people to edit the text on the web-page when they pull it up. I have text
boxes in there now that people can edit, but the text doesn't update when you
close the page and re-open it. Please Help if you ...cell format #11
Can anyone help?
If i export from Access to Excel i can get the cell in
Excel to look like this:
123 Holly Lane
The cell format is general with wrap text.
Does anyone know how to do this in Excel without
exporting from Access? I've tried wrapping text,
different formats etc but nothing works.
One thing i did notice is that when i right clicked the
cell and chose format cells the content of the cell was
the whole text but with square boxes seperating the parts
Any help appreciated.
If you're trying to type more than...How to format a cell from date to week?
How to format a cell date like "2009-12-10" to year /week format "YYYYWW" =
Also how to determine number of weeks between 2 weeks like from 200950 to
201002 = 5 weeks?
You cannot achieve this with cell formatting. Excel does not support weeks
in a date format.
To change a date to yyyyww, use:
The number of weeks difference between two of these cells, use:
This calculates to 4 weeks, not 5, just as the difference between 201001 and
2010...How to open embedded documents in excel cells?
Operating System: Mac OS X 10.6 (Snow Leopard)
I have an Excel spreadsheet created on a windows machine that contains embedded documents. <br>
When I double-click in the cell I get the following message: 'Cannot start the source application for this object'. <br>
The formula bar for this cell reads =EMBED("Wordpad.Document.1",""). <br>
How can I open the embedded document with TextEdit.app or any other application on my mac? Is there a way to configure this? <br>
Any feedback is apprecia...pasting non-contiguous range of cells to new row, same cell locati
I need a paste macro that will paste a non-contiguous range of cells (ie
to the current row in the same column locations (ie "A5:B5,G5"), assuming
current row is 5th row.
Does anyone have code for this need that you can share?
Range("A1:B1").Copy Cells(ActiveCell.Row, "A")
Range("G1").Copy Cells(ActiveCell.Row, "G")
Regards Ron de Bruin
"Not excelling at macros" <Not excelling at email@example.com> wrote in message
news:349879...SQL Server 2000 Standard Edition vs SQL 2000 Personnel Edition
I am using SQL server 2000 standard Edition sp3 with Gp 9 Sp3, I am planning
to move GP with database to new server different hardware.
can I use sql 2000 personnel edition sp3 or should I use same old version.
I hope u understand my question.
Generally speaking, personal editions are not robust enough to support a
product like GP. I would stay away.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
"MK KSA&quo...editting auto recovery
is it possible to change the auto recovery directory just for one document
and is also possible to ensure that the auto recovery file is not deleted
after the file is closed?
AFAIK this is not possible. But you may consider using the following
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
> is it possible to change the auto recovery directory just for one
> document and is also possible to ensure that the auto recovery file
> ...format a cell as running time
I have a simple question I cannot figure out. I would like to keep a
spreadsheet of my workouts(running) . I have columns "Total Time" and Split
Time(s)" (multiple of these) How would I format a cell as running time?
i.e. 22.20.93 and say one of the splits is 2.28.03 (two minutes etc...)
Thanks for any suggestions,
In article <94D844C9-A8C9-42FC-91DF-BCDD252ACC6E@microsoft.com>,
"Homer" <Homer@discussions.microsoft.com> wrote:
> Hello All,
> I hav...How can I prevent printing if a cell is empty?
Can anyone tell me if it is possible to create a form that cannot b
printed if specified cells are empty? I would really appreciate an
RonC's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1495
View this thread: http://www.excelforum.com/showthread.php?threadid=26587
You can copy this event in the Thisworkbook module for A1 on "sheet1"
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet1" Then
Is there a macro that can be used to round, say to 2 decimal places,
number of highlighted cells, say a column
Message posted from http://www.ExcelForum.com
you may try the following code:
dim rng as range
dim c as range
set rng = selection
for each c in selection
if IsNumeric (c.value) then
c.value = Round(c.value,2)
Highlight your column and invoke this macro
> Is there a macro that can be used to round, say to 2 decimal places,
> number of highlighted cells, say a column?
>...template edit question, add more? edit template?
Operating System: Mac OS X 10.6 (Snow Leopard)
i'm using a resume template and it's beautiful, but only allows four job positions before it moves one the education, etc. <br><br><i>guess theres a way to do it on the pc version, but with mac, how do i insert an addition formatted block? it will only let me work within the template currently.</i> <br><br><i>hope that makes sense, thanks for the help!</i>
Mac or PC makes no difference � it's a matter of how the template is
constructed. With...BOM & Edit List
I created an Assembly transaction and printed it from the Assembly
transaction entry window before posting it.
In the posting journal that prints it does not print the Assemble cost,
extended assemble cost, Unit cost of the components and the extended cost.
But if i post the transaction then the same posting journal is printed with
Why does it not print?
Please let me know
It only pulls posted costs, like other Great Plains edit lists including
items. You will need to modify the report to include costs.
> I created...Clearing unused cells
How can I clear cells that are at the bottom and right of what I use.
The cells are empty of data.
What I want is to get rid of the cells completely, and still have the
option to add columns and rows as needed.
I also want to add a button to clear a worksheet or one cell.
Can't get the "hang"of macros.....yet.
you can't clear these rows/columns. the best you could do is hide them
8but then you may encounter problems adding rows/columns)
> How can I clear cells that are at the bottom and right of wh...Cell grouping
This is the problem. I have 5 columns that are in this order, Date
Req.#, Requestor, Dept. and notes. I need to know how to arrange th
entire row where the departments are grouped together with th
corresponding information. The dates are not important as this repor
is quarterly; I know how to sort a column by itself but not the entir
> I should add that usually Excel is smart enough to know that when you
> one column of information to sort, and it is contiguous with other
> with data in them, to grab them a...How to edit entitys attributes directly?
I messed up with entity mappings and ended up with errror: attribute not found.
How can I manually remove attribute from entity?
Tried export -edit -import but it seems not to be the right way.
You will first need to remove the "bad" mapping that you created. Since it
is referncing the field, you need to do that prior to trying to remove the
field. You also need to remove it from any forms & views that may be
The customization Import will not remove fields (as you have discovered).
That is done as a safety feature to rpevent accidental loss of data (ima...Link To A Cell From Chart
I have a text box in a chart worksheet. Can I link it to an information from
any cell in other worksheet in the same workbook.
Yes. Click the text box icon, then click on the chart sheet to insert the
text box. Click in the formula bar and =Sheet1!A2 (or whatever cell you want
Greeting from the Gulf Coast!
"Salza" <firstname.lastname@example.org> wrote in message news:email@example.com...
> Hi all.
> I have a text box in a chart worksheet. Can I link it to an information
> any cell in other worksheet in...Cells only accept 15 numbers.
Can anyone tell me how to make Excel accept more than 15
numbers in a cell. Every time I enter my Credit Card # in
a cell, it always turns the last numeral to zero,
regardless of what I enter as the last numeral.
I tried creating a custom format of 0000-0000-0000-0000
for the cell but it still turns the last numeral to zero.
Precede the entry with an apostrophe or per-format cell as text
"Michael" <firstname.lastname@example.org> wrote in message
> Can anyone tell me how ...Editing
Could you please tell me how to remove a linked
transaction within the budget planner. For example, I
have a double entry under the debt category.
...editing a drop down #2
that's not one of my choices.
kateweb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16301
View this thread: http://www.excelforum.com/showthread.php?threadid=276931
what do you mean by this .. is it greyed out on the toolbar or shows "any
if you'ld like to tell me where you downloaded it from i can go have a look
"kateweb" <email@example.com> wrote in message
news:kateweb.1fictb@excelfor...Macro to edit details
Hi, i am currently trying to create a macro regarding editing staf
details on a worksheet.......
therefore i recorded a macro and named it editstafflist, i highlighte
my headings...and then went to 'data > form' and then had to close th
form and then stop my macro. It wouldnt allow me to stop my macr
whilst the dialogue box was open. Anyways after stopping the macro
drew out a button and assigned this 'editstafflist' macro to it.
saved my sheet and then clicked on the button, but a error '1004' kep
occuring, can anyone please help me on this as i am rather stuck
...Setting caret in edit control & activating it.
Does anyone have any example code for setting and enabling the caret in an
edit control ?
Take a look at the CEdit::SetSel() member function.
Check Abdoul [VC++ MVP]
"Nicholas Kingsley" <firstname.lastname@example.org> wrote in message
> Does anyone have any example code for setting and enabling the caret in an
> edit control ?
If you are asking how to create & use your own caret in an edit control then
check...Data collection Form Edit
We have a form which will be used almost daily, for data collection, based on
a query. During the test we found a typo in one of the field labels where a
brief description is included. Is there some way to edit the form?
(recreating it with all the custom lables is just too long a task).
Another issue on this topic, every time the form is sent, the messge reverts
to the default "Please fill out the form and retunr it to me". Can this
default message be changed?
Nothing in the help functions. Any advice, or deirection to a learning
resource will be appreciated.
Thanks is adva...saving without prompt within code
I am using this code:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
to save whenever an employee changes this document. Can I have it sav
without prompting the user?
Thanks in advance.
tawnee jamison's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1613
View this thread: http://www.excelforum.com/showthread.php?threadid=27785
Workshee...Getting a filename into VBA and putting it into cells
Basically what I have is a button that creates a new column that should be
full of linked values. When the user hits the button, he is asked to select a
file from his hard-drive; the code then takes the name of that file and
creates a number of links in the new column. So for example:
1) User hits button and selects the closed excel file
2) Excel creates the new column and populates it with formulas that link to
the file; in A1 it enters
='C:\Tempfiles\[Testsheet.xls]Overview'!$A$1 in A2 it enters
='C:\Tempfiles\[Testsheet.xls]Budget'...Counting specific word occurences in a cell
I have some data people put into cells.
For example I had 500 responses. I want to know how many cells have the word
SHRINK in them. Not all 500 people had trouble with Shrink. So in their
paragraph that they typed in the cell they may have mentioned shrink and I
would like to count it.
I tried =countif(A1:A500,"SHRINK") but that didn't work. Is there a way
that Excel can look at a number of words in a cell and just pick out the one.
Shrink is never mentioned more than once in a cell but there are other words
in that cell.