Re: Using Text Styles
Front page will not have a Next Edition. AFAIK it is dead. > Ed Bennett wrote: > > Ron Hagley wrote: > >> I have a document with Headings on one line followed by a linespace > >> then on a new line a subheading followed by (on the same line ) a > >> description > >> > >> I wish to use TEXT STYLES as this pattern repeats many times, I have > >> no problem seting up the styles for the headings, but when I do the > >> same for the SUBHEADINGS the text style is applied to the WHOLE line > >> including the description . How can I avoid this other than by using > >> ordinary text formatting or placing the description on a new line. > > > > Unfortunately, Publisher does not support Character Styles (which would > > accomplish what you are looking for), only Paragraph Styles (which > > accomplish what you are seeing). > > > Thanks Ed, > I understand your explanation. I think this is a quite fundamental > omission from the program. Seems strange when Front-Page does support > character AND paragraph styles. > Perhaps it will be in the next edition? > Mac Townsend Adcom Graphics, Fairfield, C A www.adcomgraphics.com Powered by the E-mail PIM - Info Select - www.miclog.com
mactake
publisher
21446 articles. 
6 followers.
3 Replies
1724 Views
Mac Townsend wrote: > Front page will not have a Next Edition. AFAIK it is dead. Only dead in name. Its spirit lives on in the products Expression Web and SharePoint Designer. -- Ed Bennett - MVP Microsoft Publisher http://ed.mvps.org
the_nerdEd Bennett wrote: > Mac Townsend wrote: >> Front page will not have a Next Edition. AFAIK it is dead. > > Only dead in name. Its spirit lives on in the products Expression Web > and SharePoint Designer. > From what I saw of Expression it is better than FP. Not sure if it is quite up to DW standards yet though. I think from what I saw in the time I explored it that the CSS support is better especially - just a shame that IE is not fully compliant with W3C standards - now that would be a breakthrough! Perhaps in version IE X it will be OK
hagley01Ron Hagley wrote: > From what I saw of Expression it is better than FP. Agreed. > Not sure if it is > quite up to DW standards yet though. I think from what > I saw in the time I explored it that the CSS support is better > especially - just a shame that IE is not fully compliant with W3C > standards - now that would be a breakthrough! Perhaps in version IE X it > will be OK IE7 is a big step in the right direction. Not that I use it... -- Ed Bennett - MVP Microsoft Publisher http://ed.mvps.org
Similar Artilces:
Re: How can I search for a ? in Publisher?
I just sent my suggestion to the shredder. <G> -- Don - Vancouver, USA "May your shadow be found in happy places." - Native North American "Don Schmidt" <Don Engineer@PNB.Retired_1987> wrote in message news:... >I see you problem; don't know if your search can be done in Publisher but >here's a way of finding the "?s" in your file. > > Save the file as a PDF and do the search in your PDF viewer program. This > works for me using PDF-XChange to create the file and PDF-XChange Viewer > to do the searching....
Linking Text Boxes
Hello! I am still trying to create a document that has 3 separate text boxes. The one giving me problems is the one that needs to handle text overflow (if any). I have the 3 text boxes on page 1. I need for an unlimited amount of pages to be created (if needed) with these text boxes if there is overflow. Also I need these text boxes to be stationary and not be deleted or moved when I press delete on page 1 or page 2, etc. And for text to flow into the new text box on a new page if there is overflow from the previous page. Thank you in advance, Marsha What about the me...
ACT to MS CRM 3.x Migration using Scribe Insight
Hi, I have installed Scribe Insight and Scribe Adapter for Microsoft CRM (trial version for now). I can't seem to find a nice step by step document to on how to use this software. First of all, does ACT need to be installed on the server where CRM and Scribe are running or can it just use an ACT file? Has anyone used Scribe successfully without having taken the training? Is the training recommended? mscrmuser wrote: > Hi, > > I have installed Scribe Insight and Scribe Adapter for Microsoft CRM > (trial version for now). I can't seem to find a nice step by step > ...
Posting Messages
If I just keep typing as if I was in a word processing application in = the supplied 'Message Box', if appears to scroll me nicely to a new line = whenever required. However as you can see above, after adding my message to the newsgroup, it displays my text as a single long line!! For this particular paragraph, I have entered the Return Key myself to ensure lines of reasonable length. What's the secret to having it done automatically. Thanks, ...
How can i use > in lookup function?
Column B has dates, 1 Jan 05 through 31 Jan 06. Column E has numbers .1,.2, up through 6. I need a lookup function that will find the last value in column E that is greater than .9 and then display the date in same row from column B. This will be on a summary sheet and have a lookup function for each of the sheets that follow. I had this but could not figure out how to use >.9 and the make the formula on another sheet. "=LOOKUP(6,E12:E407,B12:B407)". I want the 6 to be a >.9 instead. Help! Thanks Jim One way: =INDEX(B12:B407,MAX(IF(E12:E407>0.9,ROW(E12:E407)-MIN(ROW...
Daily Importing of External Data using Web Query
Every month I create a spreadsheet from a template by creating one ta for each day of the month named after day of the month/year (010104). then maually enter a Web Query on each tab which downloads dail weather information for an insect life cycle model. This is a very time consuming and tedious task because the onl difference in the links is the expression "20040101" (for January 01 2004) to "20040102" (for January 02,2004) INCLUDED IN THE LINK. Is it possible to use a macro (VBA code) to enter the Web Query addres in cell A1 on each tab when the workbook is created an...
Money 2004 & IE: Why do I have to re-enter my Passport account's password?
I've been using MSN Bill Pay for a couple of months, since purchasing Money 2004 Deluxe. I like it, for the most part. The one thing that is really weird, is the interaction between Money 2004, Microsoft Passport and Internet Explorer. Once I sign into Money using my Passport account, do whatever, and then get out of Money, if I then try to get into Internet Explorer it will not go into MyMSN (http://my.msn.com) without requiring me to log back into my Passport account again. Why is that? Rod ...
Style 401: Request Data Upload
after upgrading RMS 1.3 to RMS Dynamics 2.0 ... I'm facing a seriouse issue in processing work sheets ... all my sheet are processing properly but once it comse into Sheet 401: Request Data Upload, it being stuck after a while and gives me this error: "the connection is aborted du to timeout" I have tried many things to make the timeout longer but without any benefits please anybody could help me in resolving this? dose rms 2.0 sp2 would help or still the same? althoough i'm using a very fast connection .... There were some discussions a while back about this problem. ...
Wrapping of Text in X-Axis 2007 Charts
Hi, I have developed a macro in 2003 that automatically creates charts. The text labels underneath the chart wrap perfectly and the chart is auto sized. I am now using that macro on 2007 and when charts are created the text underneath the chart no longer wraps. Looking at the options in 2007 there is an Alignment tab for formatting the axis but none of the available options seem to be able to set label wrapping. The auto-fit option is greyed out. Any help would be appreciated ...
Microcontroller and PC commnicaiton using USB
Hi I am using a microcontroller. I have to communicate to the microcontroller using the PC. Both the PC and Microcontroller has the devivce driver. I am a new to this and I am not getting any pointer to start the programming. I have to do the programming using VC++ Please let me know if you have any idea on it Mayur... MJ wrote: > Hi > I am using a microcontroller. I have to communicate to the > microcontroller using the PC. Both the PC and Microcontroller has the > devivce driver. I am a new to this and I am not getting any pointer to > start the programming. I have to do t...
how do i use the excel symbol toolbar?
Excel 2003 has a Symbol Toolbar that looks like it is designed to allow the easy insertion of commonly used symbols. The problem is, I can't figure out how to use it. I have tried dragging the symbols from the toolbar onto a worksheet, copying them, double clicking them, etc... Nothing works. Does anyone have any idea how to do this? It's not even in Excel Help. Select the symbol and click insert button Regards, Peo Sjoblom "Gwhizkids" wrote: > Excel 2003 has a Symbol Toolbar that looks like it is designed to allow the > easy insertion of commonly used sy...
Strnage behaviour using personalined section in web.config
According to the possibility of use custom section that must follow a precise schema, I've implemented my own one. The problem is with the compiler, that when start to debug my application hang up on the line of the web.config telling me that the rule aren't stricly followed, but unfortunately it doesn't say me where the error is located. The strange thing is that using the schema in design-time, the schema works fine; for instance I've implemented a multiple-element parameter that is displayed correctly as well as the required or optional ones. For what I know, when a ...
Notes inside formulas using N-function
All, I've used the tip from Bob Umlas' book ("This Isn't Excel - it's Magic!") and added some notes to a few complicated formulas - to give users a clue as to what is going on. For those of you who haven't seen this, it essentially involves adding +N("Text in quotes") at the end of any formula. The problem I have, is that when I copy the formula down to the rows below, I get #VALUE! errors. Is there any way of getting around this? If the original value/formula returns a number, then this should work ok. But if your original value/formula returns te...
using RANK
I know i can rank a column of numbers from largerst to smallest. Can I use rank for smallest to largest? Any help appreciated. Skip Help has a pretty good explanation, look for the order, 0 or omitted is descending and 1 is ascending -- Regards, Peo Sjoblom "Skip" <ssummer@earthlink.net> wrote in message news:27e85c6e-c145-414e-9051-b3adb627f908@a1g2000hsb.googlegroups.com... >I know i can rank a column of numbers from largerst to smallest. > Can I use rank for smallest to largest? Any help appreciated. > Skip ...
text boxes
I have a unbound text box on a form that's not in a query how do i bind that to a report? Can't be done. Tell use what you want to do and perhaps we can tell you how. -- Dave Hargis, Microsoft Access MVP "DJACKSON" wrote: > I have a unbound text box on a form that's not in a query how do i bind that > to a report? I have a label sticker report based on a select query and I would like to add text to the sticker. The add text would change constantly so I would like to enter that on a form through a text box. Is there any hope? Thanks for your help "Kl...
Sum & report contents of table containing text values?
Can excel summate and report in charts text information recorded in a single table. EG Columns entitled Hair, Eyes, Height with values blue brown green auburn blond dark tall short medium. etc -- Neil You could use a pivot table to summarize the data, and create a chart from that. There are instructions and links here: http://www.contextures.com/xlPivot01.html For example, put Hair in the row area and Eyes in the column area. Put Height in the data area, as Count of height. Neil wrote: > Can excel summate and report in charts text information recorded in a single > table. ...
use picture as a button
is it possible to have a picture as a button to take the user to another page? (using a macro)? You could even assign it a hyperlink! ash wrote: > > is it possible to have a picture as a button to take the > user to another page? (using a macro)? -- Dave Peterson ec35720@msn.com Hello Ash This won't turn your picture into a button, someone with more experience can help you with that but below is what I generated with the macro recoreder. HTH Mark (InWales) Sub Picture_Press() ' Picture_Press Macro recorded 14/09/04 'unprotect worksheet it doesn't appear to wo...
Re: how can I convert it from cstring to char
> to All: > I have the function: > myfun(unsigned char * buf) > and I define a cstring variable str: > cstring str; > Question: > how can I convert the variable and after pass it into my function > > here ,I do it but error. > > char * ch=(LPCTSTR)CString > May i use the function : const_cast ? > and how can i use it ? > > appreciated for anyone of reply > > best regards > To stay in a mode similar to what you've tried: char *ch; CString cstr; ch = strdup((LPCSTR)cstr); which will later require you ...
Reorg only using a few roles: thoughts?
All, I would like to lay out two scenarios to you and get your feedback. Scenario 1: We currently have only 1 BU and not much need for data security between users. That being the case, I'm thinking about setting up folks in one of only two different ways, and keeping just the one BU either way: Setup #1: Sys Admin (only maybe 2 or 3 folks who help configure the system) Setup #2: VP of Sales + CSR Mgr (or maybe CEO Biz Mgr? I just want to make sure folks can use both Sales and Service features) I know, I'm wild... please, tell me if I'm headed for disaster. Scenario 2: We ma...
I'm trying to make a XP-Style IE Toolbar. (Please check my source)
I'm trying to make a XP-Style IE Toolbar. source : http://www.zeroscan.co.kr/test/XPstyleBar.zip This source is mine. I have some problems. 1. The ComboBox is not XP-Style 2. ComboBoxEx doesn't have SetFocus Please Help me... ...
How to pass data from excel to SQL database using econnect?
Hi, Can anyone send me code for reading data from excel, validating the needed and passing the data from excel to SQL database using e connect? A quickresponse wud be appreciated. Thanx in advance, Kiran. ...
Search/Extract Data w/in Text File
Hello again! I am searching within a text file for the last row within the file. After I locate the row I need to separate the data and place into multiple cells on my worksheet. The code I have is as follows: Dim TextPath As String Dim DelimSrchChar As String Dim METtime As String Dim DataBuffer As Variant Dim NCData As Variant Dim DelimPos As Integer '=============================================== DelimSrchChar = "," TextPath = "C:\Temp\Formatted_NC_SN1008.txt" Open TextPath For Input As #1 'open text file for SN1008 Do While Not EOF(1) ...
XL "zero-day" flaw used in Attacks
Came across this just this A.M. FYI http://news.zdnet.com/2100-1009_22-6084738.html?tag=nl.e589 -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- RD, Thanks for posting that link. Jim Cone San Francisco, USA "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message news:uvXrR2ikGHA.4368@TK2MSFTNGP03.phx.gbl... Came across this just this A.M. FYI ht...
Using formulas in conditions (SUMIF, AVERAGEIF)
Hi, I want to use formula in condition syntax, but I don't know how to reference the value being tested. Like: SUMIF(A1:A10;">10 AND <20") Or: AVERAGEIF(A1:A10;"ISODD(...)") Thanks for any ideas. Jan For your <<< SUMIF(A1:A10;">10 AND <20") >>> Try: =Sumif(A1:A10,">10")-Sumif(A1:A10,">=20) OR =SUMPRODUCT((A1:A10>10)*(A1:A10<20)*A1:A10) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGro...
100% CPU used by SQL and HQClient
We are seeing both HQ Client and SQL tie up resources at the store servers during connection to HQ. This can slow access to the store database by registers for a long period of time. Anyone else seeing similar performance issues on store servers? This is a multi-part message in MIME format. ------=_NextPart_000_059A_01C7B449.07A22E70 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Rick, Make sure you're running 1.3 or higher. Consider more RAM and processor = speed. Maybe even dedicate a processor core to it. --=20 Regards, Jeff...
I just sent my suggestion to the shredder. <G> -- Don - Vancouver, USA "May your shadow be found in happy places." - Native North American "Don Schmidt" <Don Engineer@PNB.Retired_1987> wrote in message news:... >I see you problem; don't know if your search can be done in Publisher but >here's a way of finding the "?s" in your file. > > Save the file as a PDF and do the search in your PDF viewer program. This > works for me using PDF-XChange to create the file and PDF-XChange Viewer > to do the searching....
Linking Text Boxes
Hello! I am still trying to create a document that has 3 separate text boxes. The one giving me problems is the one that needs to handle text overflow (if any). I have the 3 text boxes on page 1. I need for an unlimited amount of pages to be created (if needed) with these text boxes if there is overflow. Also I need these text boxes to be stationary and not be deleted or moved when I press delete on page 1 or page 2, etc. And for text to flow into the new text box on a new page if there is overflow from the previous page. Thank you in advance, Marsha What about the me...
ACT to MS CRM 3.x Migration using Scribe Insight
Hi, I have installed Scribe Insight and Scribe Adapter for Microsoft CRM (trial version for now). I can't seem to find a nice step by step document to on how to use this software. First of all, does ACT need to be installed on the server where CRM and Scribe are running or can it just use an ACT file? Has anyone used Scribe successfully without having taken the training? Is the training recommended? mscrmuser wrote: > Hi, > > I have installed Scribe Insight and Scribe Adapter for Microsoft CRM > (trial version for now). I can't seem to find a nice step by step > ...
Posting Messages
If I just keep typing as if I was in a word processing application in = the supplied 'Message Box', if appears to scroll me nicely to a new line = whenever required. However as you can see above, after adding my message to the newsgroup, it displays my text as a single long line!! For this particular paragraph, I have entered the Return Key myself to ensure lines of reasonable length. What's the secret to having it done automatically. Thanks, ...
How can i use > in lookup function?
Column B has dates, 1 Jan 05 through 31 Jan 06. Column E has numbers .1,.2, up through 6. I need a lookup function that will find the last value in column E that is greater than .9 and then display the date in same row from column B. This will be on a summary sheet and have a lookup function for each of the sheets that follow. I had this but could not figure out how to use >.9 and the make the formula on another sheet. "=LOOKUP(6,E12:E407,B12:B407)". I want the 6 to be a >.9 instead. Help! Thanks Jim One way: =INDEX(B12:B407,MAX(IF(E12:E407>0.9,ROW(E12:E407)-MIN(ROW...
Daily Importing of External Data using Web Query
Every month I create a spreadsheet from a template by creating one ta for each day of the month named after day of the month/year (010104). then maually enter a Web Query on each tab which downloads dail weather information for an insect life cycle model. This is a very time consuming and tedious task because the onl difference in the links is the expression "20040101" (for January 01 2004) to "20040102" (for January 02,2004) INCLUDED IN THE LINK. Is it possible to use a macro (VBA code) to enter the Web Query addres in cell A1 on each tab when the workbook is created an...
Money 2004 & IE: Why do I have to re-enter my Passport account's password?
I've been using MSN Bill Pay for a couple of months, since purchasing Money 2004 Deluxe. I like it, for the most part. The one thing that is really weird, is the interaction between Money 2004, Microsoft Passport and Internet Explorer. Once I sign into Money using my Passport account, do whatever, and then get out of Money, if I then try to get into Internet Explorer it will not go into MyMSN (http://my.msn.com) without requiring me to log back into my Passport account again. Why is that? Rod ...
Style 401: Request Data Upload
after upgrading RMS 1.3 to RMS Dynamics 2.0 ... I'm facing a seriouse issue in processing work sheets ... all my sheet are processing properly but once it comse into Sheet 401: Request Data Upload, it being stuck after a while and gives me this error: "the connection is aborted du to timeout" I have tried many things to make the timeout longer but without any benefits please anybody could help me in resolving this? dose rms 2.0 sp2 would help or still the same? althoough i'm using a very fast connection .... There were some discussions a while back about this problem. ...
Wrapping of Text in X-Axis 2007 Charts
Hi, I have developed a macro in 2003 that automatically creates charts. The text labels underneath the chart wrap perfectly and the chart is auto sized. I am now using that macro on 2007 and when charts are created the text underneath the chart no longer wraps. Looking at the options in 2007 there is an Alignment tab for formatting the axis but none of the available options seem to be able to set label wrapping. The auto-fit option is greyed out. Any help would be appreciated ...
Microcontroller and PC commnicaiton using USB
Hi I am using a microcontroller. I have to communicate to the microcontroller using the PC. Both the PC and Microcontroller has the devivce driver. I am a new to this and I am not getting any pointer to start the programming. I have to do the programming using VC++ Please let me know if you have any idea on it Mayur... MJ wrote: > Hi > I am using a microcontroller. I have to communicate to the > microcontroller using the PC. Both the PC and Microcontroller has the > devivce driver. I am a new to this and I am not getting any pointer to > start the programming. I have to do t...
how do i use the excel symbol toolbar?
Excel 2003 has a Symbol Toolbar that looks like it is designed to allow the easy insertion of commonly used symbols. The problem is, I can't figure out how to use it. I have tried dragging the symbols from the toolbar onto a worksheet, copying them, double clicking them, etc... Nothing works. Does anyone have any idea how to do this? It's not even in Excel Help. Select the symbol and click insert button Regards, Peo Sjoblom "Gwhizkids" wrote: > Excel 2003 has a Symbol Toolbar that looks like it is designed to allow the > easy insertion of commonly used sy...
Strnage behaviour using personalined section in web.config
According to the possibility of use custom section that must follow a precise schema, I've implemented my own one. The problem is with the compiler, that when start to debug my application hang up on the line of the web.config telling me that the rule aren't stricly followed, but unfortunately it doesn't say me where the error is located. The strange thing is that using the schema in design-time, the schema works fine; for instance I've implemented a multiple-element parameter that is displayed correctly as well as the required or optional ones. For what I know, when a ...
Notes inside formulas using N-function
All, I've used the tip from Bob Umlas' book ("This Isn't Excel - it's Magic!") and added some notes to a few complicated formulas - to give users a clue as to what is going on. For those of you who haven't seen this, it essentially involves adding +N("Text in quotes") at the end of any formula. The problem I have, is that when I copy the formula down to the rows below, I get #VALUE! errors. Is there any way of getting around this? If the original value/formula returns a number, then this should work ok. But if your original value/formula returns te...
using RANK
I know i can rank a column of numbers from largerst to smallest. Can I use rank for smallest to largest? Any help appreciated. Skip Help has a pretty good explanation, look for the order, 0 or omitted is descending and 1 is ascending -- Regards, Peo Sjoblom "Skip" <ssummer@earthlink.net> wrote in message news:27e85c6e-c145-414e-9051-b3adb627f908@a1g2000hsb.googlegroups.com... >I know i can rank a column of numbers from largerst to smallest. > Can I use rank for smallest to largest? Any help appreciated. > Skip ...
text boxes
I have a unbound text box on a form that's not in a query how do i bind that to a report? Can't be done. Tell use what you want to do and perhaps we can tell you how. -- Dave Hargis, Microsoft Access MVP "DJACKSON" wrote: > I have a unbound text box on a form that's not in a query how do i bind that > to a report? I have a label sticker report based on a select query and I would like to add text to the sticker. The add text would change constantly so I would like to enter that on a form through a text box. Is there any hope? Thanks for your help "Kl...
Sum & report contents of table containing text values?
Can excel summate and report in charts text information recorded in a single table. EG Columns entitled Hair, Eyes, Height with values blue brown green auburn blond dark tall short medium. etc -- Neil You could use a pivot table to summarize the data, and create a chart from that. There are instructions and links here: http://www.contextures.com/xlPivot01.html For example, put Hair in the row area and Eyes in the column area. Put Height in the data area, as Count of height. Neil wrote: > Can excel summate and report in charts text information recorded in a single > table. ...
use picture as a button
is it possible to have a picture as a button to take the user to another page? (using a macro)? You could even assign it a hyperlink! ash wrote: > > is it possible to have a picture as a button to take the > user to another page? (using a macro)? -- Dave Peterson ec35720@msn.com Hello Ash This won't turn your picture into a button, someone with more experience can help you with that but below is what I generated with the macro recoreder. HTH Mark (InWales) Sub Picture_Press() ' Picture_Press Macro recorded 14/09/04 'unprotect worksheet it doesn't appear to wo...
Re: how can I convert it from cstring to char
> to All: > I have the function: > myfun(unsigned char * buf) > and I define a cstring variable str: > cstring str; > Question: > how can I convert the variable and after pass it into my function > > here ,I do it but error. > > char * ch=(LPCTSTR)CString > May i use the function : const_cast ? > and how can i use it ? > > appreciated for anyone of reply > > best regards > To stay in a mode similar to what you've tried: char *ch; CString cstr; ch = strdup((LPCSTR)cstr); which will later require you ...
Reorg only using a few roles: thoughts?
All, I would like to lay out two scenarios to you and get your feedback. Scenario 1: We currently have only 1 BU and not much need for data security between users. That being the case, I'm thinking about setting up folks in one of only two different ways, and keeping just the one BU either way: Setup #1: Sys Admin (only maybe 2 or 3 folks who help configure the system) Setup #2: VP of Sales + CSR Mgr (or maybe CEO Biz Mgr? I just want to make sure folks can use both Sales and Service features) I know, I'm wild... please, tell me if I'm headed for disaster. Scenario 2: We ma...
I'm trying to make a XP-Style IE Toolbar. (Please check my source)
I'm trying to make a XP-Style IE Toolbar. source : http://www.zeroscan.co.kr/test/XPstyleBar.zip This source is mine. I have some problems. 1. The ComboBox is not XP-Style 2. ComboBoxEx doesn't have SetFocus Please Help me... ...
How to pass data from excel to SQL database using econnect?
Hi, Can anyone send me code for reading data from excel, validating the needed and passing the data from excel to SQL database using e connect? A quickresponse wud be appreciated. Thanx in advance, Kiran. ...
Search/Extract Data w/in Text File
Hello again! I am searching within a text file for the last row within the file. After I locate the row I need to separate the data and place into multiple cells on my worksheet. The code I have is as follows: Dim TextPath As String Dim DelimSrchChar As String Dim METtime As String Dim DataBuffer As Variant Dim NCData As Variant Dim DelimPos As Integer '=============================================== DelimSrchChar = "," TextPath = "C:\Temp\Formatted_NC_SN1008.txt" Open TextPath For Input As #1 'open text file for SN1008 Do While Not EOF(1) ...
XL "zero-day" flaw used in Attacks
Came across this just this A.M. FYI http://news.zdnet.com/2100-1009_22-6084738.html?tag=nl.e589 -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- RD, Thanks for posting that link. Jim Cone San Francisco, USA "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message news:uvXrR2ikGHA.4368@TK2MSFTNGP03.phx.gbl... Came across this just this A.M. FYI ht...
Using formulas in conditions (SUMIF, AVERAGEIF)
Hi, I want to use formula in condition syntax, but I don't know how to reference the value being tested. Like: SUMIF(A1:A10;">10 AND <20") Or: AVERAGEIF(A1:A10;"ISODD(...)") Thanks for any ideas. Jan For your <<< SUMIF(A1:A10;">10 AND <20") >>> Try: =Sumif(A1:A10,">10")-Sumif(A1:A10,">=20) OR =SUMPRODUCT((A1:A10>10)*(A1:A10<20)*A1:A10) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGro...
100% CPU used by SQL and HQClient
We are seeing both HQ Client and SQL tie up resources at the store servers during connection to HQ. This can slow access to the store database by registers for a long period of time. Anyone else seeing similar performance issues on store servers? This is a multi-part message in MIME format. ------=_NextPart_000_059A_01C7B449.07A22E70 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Rick, Make sure you're running 1.3 or higher. Consider more RAM and processor = speed. Maybe even dedicate a processor core to it. --=20 Regards, Jeff...