Need some advanced help on this one!
I found a sample Access program that takes data from its database to
generate an EDI EDIFACT ORDERS file (OrdersS93a.edi).
Here is the code:
Private Sub Command0_Click()
Dim oEdiDoc As Fredi.ediDocument
Dim oSchema As Fredi.ediSchema
Dim oInterchange As Fredi.ediInterchange
Dim oGroup As Fredi.ediGroup
Dim oTransactionset As Fredi.ediTransactionSet
Dim oSegment As Fredi.ediDataSegment
Dim oConn As ADODB.Connection
Dim oRsInterchange As ADODB.Recordset
Dim oRsGroup As ADODB.Recordset
Dim oRsTransactionSet As ADODB.Reco...File size #11
I have read the other discussions on file sizes but they do not seem to
address my problem.
I have an Excel file that is 12mb large with low-res jpegs in it. This file
also has merged cells to make it look pretty. Does Excel look at these merged
cells as graphics? Is this why they are too big? I have run a macro to make
sure that it goes to the last cell.
How can I get the file smaller?
How big are the graphics? If you remove them from the file, what is the size
of the file and what is the size of the graphic files?
To be sure you do not have extra formatting, if you open the file...Maximum file sizes
Is there a recommended maximum file size for Excel 2000.
PC spec 2Ghz P4 with 256 Mb
Any advice appreciated
Does Not Exist
have a look at
"Deus DNE" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Is there a recommended maximum file size for Excel 2000.
> PC spec 2Ghz P4 with 256 Mb
> Any advice appreciated
> Does Not Exist
...New to excel
I'm new to Excel ( and to this forum :) ) and so I hope somebody may b
able to help me.
I've got 2 questions....
I've got a spreadsheet which takes data from one worksheet and uses i
to calculate data in a second worksheet using the following code
=IF('4th November 2005'!B19="","nothing here dude",IF(B19<'4th Novembe
2005'!B19,"UP",IF(B19='4th November 2005'!B19,"Same",IF(B19>'4t
The problem is, when I create a new worksheet I have...hide a row
I have a worksheet with information in column A and B.
If Column B has no information I want to do nothing, but if there is
something in Column B, I would like to hide the row.
Is this possable in an if statement?
not possible with a formula. This would require VBA
"Bob" <email@example.com> schrieb im Newsbeitrag
> I have a worksheet with information in column A and B.
> If Column B has no information I want to do nothing, but if there is
> something in Column B, ...Auto transfer of row
I have a list of components to be ordered in each row is a cell with
order number entered in it. What I want is to copy the row to anothe
sheet (which is to be displayed at goods) when the order number i
entered in that cell. Is this possible? many thanks for any help
alanled's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3094
View this thread: http://www.excelforum.com/showthread.php?threadid=57297
this could be acheived by using VLOOKUP function.
if you want a perfect soluti...Changing Cells and entering data in them
Thanks for the help again.
Big thanks to Steve you've got me this far.
I went out and bought a book, but it's like reading a
I was informed today that I can't have message boxes come
I need to have the code point at the cells and if they are
blank turn which ever one is blank red or if both are then
both turn red then pause for each cell to be filled in.
Cell F14 "Last Name" then automatically go to Cell
F16 "First Name" on tab or enter.
Basically if Cell F22 or F23 has an X in it, Cells F14 an
F16 turn red and cell F14 has the focus...how to convert lookup values to the "display text"
I'm using an sql code (below) which uses a few lookup fields. Unfortunately
in the datasheet view, I get the "bound values" instead of the "display
values". How can I change the properties for the these lookup fields so I
can see the "display values" from the datasheet view?
UNION ALL SELECT
UNION ALL SELECT
[Funding],[Date],[Description],[C...Need Help, Task Start Date is wrong
I’m using MS Project 2007, have several task linked with finish to start. I
have set date to schedule from, hours per day set to 8 and Working Monday
My schedule shows Task 1 Duration 4 days, start Wed 6/2/10, Finish Mon 6/7/10
Task 2 Duration 3 days, start Mon 6/7/10, Finish Thu 6/10/10
Task 2 should have a Start Date of 6/8/10 not 6/7/10; what is causing this?
Thanks in advance for your help.
...Is anyone an expert with outlook that I can call on the phone?
How do I share calenders between outlook and my MSN Premier account?
Assuming you are using the outlook connector, you need to set the msn
account to be the default message store then outlook will use the msn
calendar as the default.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
You can access this...I need a macro
I would like a macro to do the following:
I would place the the cursor in any cell and this macro would give me the
average of all the entries to the left if the selected cell. EX: I place the
cursor in cell M12.
I want this macro on display in cell M12 the average of all the values from
Col C12 to Col L12. Note that there may NOT be entries in all the cells in
that range. Also the start point would always be col C .Thanks
You can do this easily with a worksheet_selection event in the sheet module
but you would probably want to restrict to a certain range or columns and
rows or it woul...Show date, time & day of week in one cell
Can I show the date, time and day of week in one cell.
09/03/07 8:30 AM
in one cell using the format (Format/Cells/Custom):
[$-409]mm/dd/yy h:mm AM/PM;@
Excel refuses to accept ddd for Mon or dddd Monday at the end of the format
I want it to read:
09/03/07 8:30 AM Monday in 1 cell.
I have Excel 2003.
mm/dd/yy h:mm AM/PM dddd;@
In article <Xns99B8A3CAF9130pencilunlistedcom@18.104.22.168>,
Burp <firstname.lastname@example.orgINVALID> wrote:
> Can I show the date, time and day of week in one cell.
> I have:
> 09/03/07 8:30 AM
> in one cell using the for...how do i increase font size beyond 72
highlighting figure in font size box and trying to put larger number in
myself does not do it. is there another way? thanks
High-light the number, type your number, hit return. It that doesn't work for
you, on the toolbar, format, font.
Mary Sauer MSFT MVP
"Polly Vincent" <Polly Vincent@discussions.microsoft.com> wrote in message
> highlighting figure in font ...default values in a cell
Hello, can you help me please
Cell B1 contains a complex mathematical formula which requires (in several
places) a number from cell A1.
Cell A1 can contain any integer number, but it is usually the same (30).
I would like to be able to leave cell A1 empty, and only enter a number when
it is not 30 ,
ie the default value of A1 is 30, unless specified.
How do I go about this ?
Should I look at conditional formatting, or put lots of IF functions into an
already complex formula?
Thank as always
Use 2 cells
Modify the complex formula to use B1 rather than A1 ( or any other un-u...How to delete a set of rows depending on Value
I have two worksheets
I need Worksheet A to look at each cell in Worksheet B, if a cell exists in
Worksheet A, then I need the row deleted...
Basically I have a list of Grand list of items to do, then a list of items
already completed. I need to now remove all entries in the grand list that
have been completed.
Is this feasible or should I look at using some Unix script.
It sounds like you could use VLOOKUP to find out if the value in B exists on
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel....How do I overlay text to a row without loosing the text in the ba.
I would like to know how to give an entire row (or column) a text overlay
such as "VOID" and still be able to view the text in the underlaying row (or
Thanks in advance.
Use WordArt from the Drawing toolbar. Change the Fill to None.
"Bruce Charles" <Bruce Charles@discussions.microsoft.com> wrote in message
|I would like to know how to give an entire row (or column) a text overlay
| such as "VOID" and still be able to view the text in the underlaying row
| c...Call & Place Graphic Based on Cell Value?
Is there any way to call & place a graphic image based upon a cell value?
Maybe you can look at J.E. McGimpsey's page:
> Is there any way to call & place a graphic image based upon a cell value?
...I need to print a word in PDF from excel.
In my excel Macro, I update several values and then open a word linked
with that excel. Finally what I need to do is to print that word to
PDF. I already have a PDF Printer, so I just need the code to do it.
Can anybody help me?
Thanks in advance.
Habilita la impresora predeterminada como la PDF y ya lo puedes imprimir a
al formato deseado
Tienes alg=FAn codigo para ello?
Desde el panel de impresoras asigno primero la que me interesa y despues
ejecuto mi macro desde el archivo excel asignando la instruccion sig:
midefaultes = a...Can't do adjustment in analytical accounting
I am trying to change an analytical assignmnet through the Edit
Analysis. When I try and change it, I receive an error stating "The
Code of this Transaction Dimension cannot be adjusted". Has anyone
seen this before? I have done similar changes many times, but I don't
know why I can't now. Any insight would be helpful.
What version of Gp are you running? I haveseen this happen in 8 but one of
the service packs fixed it. (I think it was SP 4 or 5)
> I am trying to change an analytical assignmnet through the Edit
>...Can I share entities in migration process?
The entities in CRM have only one owning user. If I want=20
who a user see a entity of another user, the entity must=20
be shared with this user.=20
Well, I want migrate entities who must be shared with some=20
users. Exists a way to do it?
Thank you for pay attention and sorry my bad english.
Vin=EDcius Pitta Lima de Ara=FAjo
...MOVE TO FOLDER... only appears. I need MOVE TO FOLDER
This is very odd and I've found that I've had this problem before with
not finding icons. Some I've found at the office don't appear here
and vice versa, or they act differently. I have Outlook 2000 in both
places! Very odd.
At home, I couldn't find the HIGH IMPORTANCE icon under the list of
items available in the customize. Yet I have it at work. That's the
one where when the HIGH IMPORTANCE is on, it shows a depressed button
state. I really need that in both places.
Anyway, simple (or so I thought) - I ended up just brining the toolbar
from work on a floppy, a...Can validation lists be enlarged
When a validtion list is created can this be enlarged in a spreadsheet which
has been reduced to view.
for a workaround see:
"AC" <AC@discussions.microsoft.com> schrieb im Newsbeitrag
> When a validtion list is created can this be enlarged in a
> has been reduced to view.
...can't open new worksheets in a separate window
I've been trying to open multiple wookbooks in Excel, but they won't open in
a new window. Instead they continue to open in the same window - one on top
of the other. I've tried playing around with the maximize and restore, but
to no avail. I tried right clicking on the Excel button in the taskbar to
cascade the windows, but the pop-up menu is inactive. any advice would be
Running Excel 2003, Windows XP.
This might be it:
Tools - Options - View tab - Show: Windows in taskbar.
"3R's" <3R's@di...How can I change text to proper text in multiple cells.
I need to change names that are all in caps to proper case in 100 cells.
If I click each one individually, it works, but I need to be able to perfomr
this funcion automatically on all the cells. One other post said to be sure
calc is set to automatic and mine is. Any instruction is most appreciated.
Insert a helper column to the right of the column with the names.
Then use a formula like:
and drag down that column
Then select that column
select the original range
And then delete the helper column.
> I...Remote humans can't get email addressed to them from within the do
I call them remote humans because they are not "users" set up on the SBS2003
system. I've set up a local domain, call it domain.local, and the email
domain is domain.org. For all internal users, there is no problem. But
there are two people, out of state, with email addresses email@example.com and
firstname.lastname@example.org. Our email is hosted, and we use the POP3 connector to
bring it into our Exchange server. We do not use POP3 connector for the
remote humans - their Outlook client has the POP3 account set up on it.
These remotes will never connect to the local domain, all th...