<?xml version="1.0" encoding="ISO-8859-1"?>

<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/">
	<channel>
		<title>Bytes</title>
		<link>http://bytes.com</link>
		<description>IT and Developer Knowedge Sharing Community.  Business, Information Technology, Software Development.</description>
		<language>en</language>
		<lastBuildDate>Fri, 20 Nov 2009 21:21:12 GMT</lastBuildDate>
		<generator>vBulletin</generator>
		<ttl>60</ttl>
		<image>
			<url>http://bytes.com/images/misc/rss.jpg</url>
			<title>Bytes</title>
			<link>http://bytes.com</link>
		</image>
		<item>
			<title>Trouble with mouseover</title>
			<link>http://bytes.com/topic/javascript/answers/877388-trouble-mouseover</link>
			<pubDate>Fri, 20 Nov 2009 21:19:22 GMT</pubDate>
			<description>I am new to javascript and having a hard time. I have a class assignment that I have been working on for days...what has to happen is when the mouse...</description>
			<content:encoded><![CDATA[<div>I am new to javascript and having a hard time. I have a class assignment that I have been working on for days...what has to happen is when the mouse rolls over the text an image is to appear. The code I have so far is as follows:<br />
<br />
&lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Strict//EN&quot; &quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd&quot;&gt;<br />
&lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;<br />
  &lt;head&gt;<br />
    &lt;title&gt;&lt;/title&gt;<br />
    &lt;script type=&quot;text/javascript&quot; src=&quot;core.js&quot;&gt;&lt;/script&gt;<br />
	&lt;script type=&quot;text/javascript&quot;&gt;<br />
       function showMonkey()<br />
	   {<br />
<br />
	   }<br />
    &lt;/script&gt;<br />
	&lt;style&gt;<br />
	  .hidden{display: none}<br />
	&lt;/style&gt;<br />
  &lt;/head&gt;<br />
  &lt;body&gt;<br />
  &lt;h2&gt;Adding Event Listeners&lt;/h2&gt;<br />
  &lt;div&gt;<br />
    &lt;h2 style=&quot;margin-right:300px&quot;&gt;Mouse Here To See Monkey&lt;/h2&gt;<br />
    &lt;img src=&quot;monkey.jpg&quot; id=&quot;monkey&quot; class=&quot;hidden&quot; /&gt;<br />
  &lt;/div&gt;<br />
  &lt;script type=&quot;text/javascript&quot;&gt;<br />
	<br />
var image = document.getElementById('monkey');<br />
  <br />
	if(document.attachEvent){<br />
		image.attachEvent('mouseover',showMonkey);<br />
	}<br />
	else if(document.removeEventListener) {<br />
		image.addEventListener('mouseover',showMonkey,fals  e);<br />
	}<br />
<br />
 var class = Core.getElementsByClass('hidden');<br />
Core.removeClass(class[0],'hidden');<br />
<br />
	<br />
  &lt;/script&gt;<br />
  &lt;/body&gt;<br />
&lt;/html&gt;<br />
<br />
If you have any questions please let me know..I have no idea what to add in the function.<br />
Thanks in advance!</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/javascript/answers/">answers</category>
			<dc:creator>heapster123</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/javascript/answers/877388-trouble-mouseover</guid>
		</item>
		<item>
			<title>http://bytes.com/topic/php/answers/515554-using-local-php-ini-files</title>
			<link>http://bytes.com/topic/php/answers/877387-http-bytes-com-topic-php-answers-515554-using-local-php-ini-files</link>
			<pubDate>Fri, 20 Nov 2009 21:11:29 GMT</pubDate>
			<description><![CDATA[Hello All. 
I have the same problem like in this post's: 
http://bytes.com/topic/php/answers/515554-using-local-php-ini-files 
the topic is closed....]]></description>
			<content:encoded><![CDATA[<div>Hello All.<br />
I have the same problem like in this post's:<br />
http://bytes.com/topic/php/answers/515554-using-local-php-ini-files<br />
the topic is closed. what should i do?</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/php/answers/">answers</category>
			<dc:creator>blackhowk</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/php/answers/877387-http-bytes-com-topic-php-answers-515554-using-local-php-ini-files</guid>
		</item>
		<item>
			<title>mdi</title>
			<link>http://bytes.com/topic/c-sharp/answers/877384-mdi</link>
			<pubDate>Fri, 20 Nov 2009 19:51:22 GMT</pubDate>
			<description>i wanna create a mdi form. but to make the other form as child of the main i cant find any mdiparent property in the properties list. i  m using vs...</description>
			<content:encoded><![CDATA[<div>i wanna create a mdi form. but to make the other form as child of the main i cant find any mdiparent property in the properties list. i  m using vs 2010. <br />
help plzzz<br />
<br />
leave it <br />
i understood how to do it</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/c-sharp/answers/">answers</category>
			<dc:creator>siddhanta</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/c-sharp/answers/877384-mdi</guid>
		</item>
		<item>
			<title>Confirming deletion of records</title>
			<link>http://bytes.com/topic/php/answers/877383-confirming-deletion-records</link>
			<pubDate>Fri, 20 Nov 2009 18:53:19 GMT</pubDate>
			<description>I have been developing a website over the past couple for my wife who is an artist. During that time I have taught myself PHP and mySQL and developed...</description>
			<content:encoded><![CDATA[<div>I have been developing a website over the past couple for my wife who is an artist. During that time I have taught myself PHP and mySQL and developed a content management system that allows her to upload and edit pictures, and and delete information like links and exhibitions and generally stop hassling me.<br />
<br />
I have now extended it cover a couple of her art groups where she can create and delete new artists and they then have the same control.<br />
<br />
As t has been just a hobby and only for her security hasn't been my greatest concern. However now that others are using it I am a bit concerned about hackers. <br />
<br />
So my question is: How can I intercept a delete artist command and send an email to the person who has administrative rights to confirm that they really want to continue with the deletion as it could mean deleting hundreds of pictures.  I  already have  an &quot;are you really sure&quot; page for accidents.<br />
<br />
Many thanks in advance,<br />
<br />
Simon<br />
<br />
PS Her site is <a href="http://www.spaceformyart.com/artists/Sue%20Fawthrop.php" target="_blank">here</a> and the group site <a href="http://www.spaceformyart.com/art%20groups/art%20group.php?group_id=Wycombe%20Court%20Artists" target="_blank">here </a></div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/php/answers/">answers</category>
			<dc:creator>simonf</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/php/answers/877383-confirming-deletion-records</guid>
		</item>
		<item>
			<title>game of 21, person vs. computer. first closest to 21 without going over wins help fin</title>
			<link>http://bytes.com/topic/c/answers/877382-game-21-person-vs-computer-first-closest-21-without-going-over-wins-help-fin</link>
			<pubDate>Fri, 20 Nov 2009 18:06:52 GMT</pubDate>
			<description>//Specification: This program plays a version of 
//the card game of 21. 
//A human player is pitted against the computer. 
//The player who is the...</description>
			<content:encoded><![CDATA[<div>//Specification: This program plays a version of<br />
//the card game of 21.<br />
//A human player is pitted against the computer.<br />
//The player who is the closest to 21 without<br />
//going over wins the hand. <br />
#include &lt;iostream&gt;<br />
#include &lt;ctime&gt;<br />
#include &lt;string&gt;<br />
<br />
using namespace std;<br />
<br />
//prototypes...<br />
void play21(void);<br />
int dealCards(int, string);<br />
void hit(int &amp;);<br />
void determineWinner(int, int);<br />
int Random(int, int);<br />
<br />
<br />
void main(){<br />
<br />
       char keepPlaying = 'n'; //loop control variable<br />
<br />
       do {<br />
              play21();<br />
          <br />
              //keep playing?<br />
             cout &lt;&lt; &quot;Do you want to play anouther hand (y/n)?&quot;;<br />
             cin &gt;&gt; keepPlaying;<br />
     } while(keepPlaying == 'Y' || keepPlaying == 'y');<br />
}<br />
<br />
void play21(void){<br />
        //play one hand of 21<br />
<br />
        //randomize the cards<br />
        srand((int) time(0));<br />
<br />
       // deal the cards<br />
         int person = dealCards(2, &quot;Your Cards:&quot;);<br />
         cout &lt;&lt; &quot; = &quot; &lt;&lt; person &lt;&lt; endl;<br />
         int house = dealCards(2, &quot;Computers Cards:&quot;);<br />
         cout &lt;&lt; &quot; = &quot; &lt;&lt; house &lt;&lt; endl;<br />
<br />
        // Ask if human wants a hit and keep hitting...<br />
        hit(person);<br />
        cout &lt;&lt; endl;<br />
<br />
       //Determine if computer takes a hit<br />
       while ((house &lt; person) &amp;&amp; (house &lt;= 21) &amp;&amp; (person &lt;= 21)) {<br />
               house += dealCards(1, &quot;The Computer takes a card &quot;);<br />
               cout &lt;&lt; endl;<br />
        }<br />
<br />
       //show who won....<br />
       determineWinner(person, house);<br />
}<br />
<br />
void determineWinner(int humanScore, int houseScore) {<br />
//Compare the scores to see who won<br />
//Both the human and the house score totals are provided as arguments<br />
//Display total scores and indicate winner<br />
//possible outcomes: human wins, computer wins, tie<br />
<br />
}<br />
<br />
int dealCards(int numberOfCards, string message){<br />
//This function deals the cards<br />
//The number of cards to be dealt is provided as an argument<br />
//A message indicating which player is receiving the cards is also<br />
//given as an argument<br />
//The player message and the cards dealt is displayed to the screen<br />
//the total value of the dealt cards  is returned<br />
<br />
}<br />
<br />
void hit(int &amp;playerScore){<br />
//This function asks the human if they want another card -- 'a hit'<br />
//the player's score total is accumulated as they take cards<br />
//the player can continue taking cards until they wish to stop or they exceed 21<br />
//After a card is taken (use the dealCards function) the user's current total is displayed<br />
//If the user goes over 21 'busted' is displayed<br />
<br />
}<br />
<br />
int Random(int lowerLimit, int upperLimit) {<br />
//returns a random number within the given boundary<br />
         return 1 + rand() % (upperLimit - lowerLimit + 1);<br />
}</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/c/answers/">answers</category>
			<dc:creator>mProgramz</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/c/answers/877382-game-21-person-vs-computer-first-closest-21-without-going-over-wins-help-fin</guid>
		</item>
		<item>
			<title>referenceing text in another html file</title>
			<link>http://bytes.com/topic/html-css/answers/877381-referenceing-text-another-html-file</link>
			<pubDate>Fri, 20 Nov 2009 17:54:14 GMT</pubDate>
			<description><![CDATA[am I able to call text from either a text file, or from an html document, to show on my webpage? 
 
I'm eventually going to have 10 versions of a...]]></description>
			<content:encoded><![CDATA[<div>am I able to call text from either a text file, or from an html document, to show on my webpage?<br />
<br />
I'm eventually going to have 10 versions of a webpage running.  All with minor differences.  However, there is text that will be the same on every page and I'd like to be able to update it in one spot and have it update everywhere.<br />
<br />
I can have an image on my site in 10 different spots (all pointing to the same image file) and when I change that image, all 10 become the new image.<br />
<br />
Is this possible to do with text in some way?<br />
<br />
Thanks,<br />
<br />
Andrew</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/html-css/answers/">answers</category>
			<dc:creator>adweaver</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/html-css/answers/877381-referenceing-text-another-html-file</guid>
		</item>
		<item>
			<title><![CDATA[recordsource >= string]]></title>
			<link>http://bytes.com/topic/visual-basic/answers/877378-recordsource-string</link>
			<pubDate>Fri, 20 Nov 2009 16:54:15 GMT</pubDate>
			<description>Hi, 
 
I was wondering if anyone could possibly help me wih this issue. I have an access database. In this database I have a massive table that I...</description>
			<content:encoded><![CDATA[<div>Hi,<br />
<br />
I was wondering if anyone could possibly help me wih this issue. I have an access database. In this database I have a massive table that I have created a query off of in order to be able to edit the data because the actual data is write protected. <br />
<br />
I am trying to search for certain dates in the table that have been input ex. from m/d/yyyy to m/d/yyyy. I would like to run a query that would filter the results for me. <br />
<br />
My basic assumptions would lead me to think that I can run a query as follows; <br />
<br />
data1.recordsource = &quot;Select * from [table] where (value in column) &gt;= &quot; &amp; date1 &amp; &quot; and (value in column) &lt;= &quot; &amp; date2 &amp; &quot;&quot;<br />
data1.refresh <br />
<br />
however, this is not working for me. Any ideas??<br />
<br />
Thanks</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/visual-basic/answers/">answers</category>
			<dc:creator>kbbauman</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/visual-basic/answers/877378-recordsource-string</guid>
		</item>
		<item>
			<title>Reserved Error (-1517) when adding new records to table.</title>
			<link>http://bytes.com/topic/access/answers/877377-reserved-error-1517-when-adding-new-records-table</link>
			<pubDate>Fri, 20 Nov 2009 16:38:22 GMT</pubDate>
			<description>I have a form in which I build a list of employees who have attended a training course, then populate new records in a training table based on the...</description>
			<content:encoded><![CDATA[<div>I have a form in which I build a list of employees who have attended a training course, then populate new records in a training table based on the list. There has never been a problem with this routine, yet this morning I went in to create the list for a training that happenned earlier this week, and when VBA hit the DoCmd.RunSQL statement that inserts the new record into the table, it threw up the message:<br />
<br />
Reserved Error (-1517); There is no message for this error.<br />
<br />
So, I re-built the code to use a recordset instead of the RunSQL function.  I just tried to run it and got the same error as soon as it tried to set the value for the first field after the .AddNew statement.<br />
<br />
I have tried and am able to add a record to the table manually, so it's not an issue with permissions on the back-end.<br />
<br />
Anyone have any experience with this? I tried Googling the error and got zip.</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/access/answers/">answers</category>
			<dc:creator>topher23</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/access/answers/877377-reserved-error-1517-when-adding-new-records-table</guid>
		</item>
		<item>
			<title>Insert new row into middle of array</title>
			<link>http://bytes.com/topic/php/answers/877376-insert-new-row-into-middle-array</link>
			<pubDate>Fri, 20 Nov 2009 16:36:19 GMT</pubDate>
			<description>I have an array which i want to insert a new value into the middle without losing any values. Is there an array function for this? 
 
 
Code:...</description>
			<content:encoded><![CDATA[<div>I have an array which i want to insert a new value into the middle without losing any values. Is there an array function for this?<br />
<br />
<!-- CODE -->
<div id="codeHolder" class="codeHolder" style="width: 500px;">
<div class="codeHeader">
	<span class="codeLink" onclick="Blur(this, this.parentNode.parentNode, getChildren(this),true);">Expand</span><span class="codeDivider">|</span><span class="codeLink" onclick="selectAll(this);">Select</span><span class="codeDivider">|</span><span class="codeLink" onclick="WordWrap(this);">Wrap</span><span class="codeDivider">|</span><span class="codeLink" onclick="LineNumbers(this);">Line Numbers</span>
</div>

<div class="codeContent" style="display: block; width: 500px; white-space: nowrap;">
	<ol START="1" highlight="true">

<li class="codeLI">ARRAY(&nbsp;&nbsp;[1]&nbsp;&nbsp;=&gt;&nbsp;&nbsp;&quot;a&quot;&nbsp;&nbsp;[2]&nbsp;=&gt;&nbsp;&nbsp;&quot;c&quot;&nbsp;&nbsp;&nbsp;[3]&nbsp;=&gt;&nbsp;&nbsp;&quot;d&quot;&nbsp;)</li>
<li class="codeLI">
//I&nbsp;would&nbsp;like&nbsp;to&nbsp;insert&nbsp;&quot;b&quot;&nbsp;at&nbsp;key&nbsp;[2]..&nbsp;&nbsp;creating&nbsp;this:</li>
<li class="codeLI">
ARRAY(&nbsp;&nbsp;[1]&nbsp;&nbsp;=&gt;&nbsp;&nbsp;&quot;a&quot;&nbsp;&nbsp;[2]&nbsp;=&gt;&nbsp;&nbsp;&quot;b&quot;&nbsp;&nbsp;&nbsp;[3]&nbsp;=&gt;&nbsp;&nbsp;&quot;c&quot;&nbsp;&nbsp;[4]&nbsp;=&gt;&nbsp;&nbsp;&quot;d&quot;&nbsp;)</li>

	</ol>
</div>
</div>
<!-- /CODE -->


Thanks!</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/php/answers/">answers</category>
			<dc:creator>bugboy</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/php/answers/877376-insert-new-row-into-middle-array</guid>
		</item>
		<item>
			<title>Checkbox in PERL? How I do this?</title>
			<link>http://bytes.com/topic/perl/answers/877375-checkbox-perl-how-i-do</link>
			<pubDate>Fri, 20 Nov 2009 16:33:23 GMT</pubDate>
			<description>Hi !! 
 
I need a script that show me information about packages captured from a network from PCAP format to a TEXT format. 
 
In a framework the...</description>
			<content:encoded><![CDATA[<div>Hi !!<br />
<br />
I need a script that show me information about packages captured from a network from PCAP format to a TEXT format.<br />
<br />
In a framework the user can select the tab of the fields, the number of fields and what these fields (destination IP, source IP, destination MAC, etc.).<br />
<br />
How I do this?<br />
<br />
Thanks</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/perl/answers/">answers</category>
			<dc:creator>Chocolataria</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/perl/answers/877375-checkbox-perl-how-i-do</guid>
		</item>
		<item>
			<title>what is the sql statement for insert into when using the script editor from ms access</title>
			<link>http://bytes.com/topic/visual-basic/answers/877373-what-sql-statement-insert-into-when-using-script-editor-ms-access</link>
			<pubDate>Fri, 20 Nov 2009 16:13:18 GMT</pubDate>
			<description>I have the database test.mdb with a table named tabel  
The table contains 2 fields: nume and prenume 
 
I have created a data access page that has 2...</description>
			<content:encoded><![CDATA[<div>I have the database test.mdb with a table named tabel <br />
The table contains 2 fields: nume and prenume<br />
<br />
I have created a data access page that has 2 textboxes: text0 and text1 and also a button: command0<br />
 <br />
what is the code that i need in the onclik event from ms script editor so that the values from text0 and text1 to be inserted into fields (nume and prenume)<br />
<br />
sory for my bad english</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/visual-basic/answers/">answers</category>
			<dc:creator>alcoool</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/visual-basic/answers/877373-what-sql-statement-insert-into-when-using-script-editor-ms-access</guid>
		</item>
		<item>
			<title>how to format caracters string to make it compatible whit criteria in a query</title>
			<link>http://bytes.com/topic/access/answers/877372-how-format-caracters-string-make-compatible-whit-criteria-query</link>
			<pubDate>Fri, 20 Nov 2009 16:07:34 GMT</pubDate>
			<description><![CDATA[Good day to every one 
 
Weird question i guest, 
 
I'm using a function as a query criteria, that function simply get the value of a global variable...]]></description>
			<content:encoded><![CDATA[<div>Good day to every one<br />
<br />
Weird question i guest,<br />
<br />
I'm using a function as a query criteria, that function simply get the value of a global variable all this worked of but is seams that ms access does not <br />
understand <br />
<br />
this an example  (it refers to what it beside the quotation marks)<br />
<br />
property = &quot;Between 1 And 98&quot;<br />
<br />
When i type Between 1 And 98 as a criteria in the query design it works OK.<br />
<br />
I can't figure what wrong.<br />
<br />
Thanks for your help.</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/access/answers/">answers</category>
			<dc:creator>atoy</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/access/answers/877372-how-format-caracters-string-make-compatible-whit-criteria-query</guid>
		</item>
		<item>
			<title>Capturing equivalent file size given a String</title>
			<link>http://bytes.com/topic/java/answers/877371-capturing-equivalent-file-size-given-string</link>
			<pubDate>Fri, 20 Nov 2009 15:47:32 GMT</pubDate>
			<description>Is there a way to capture the equivalent file size(text) given a String? 
 
Any ideas? 
 
P.S Except for saving the text into a file first before...</description>
			<content:encoded><![CDATA[<div>Is there a way to capture the equivalent file size(text) given a String?<br />
<br />
Any ideas?<br />
<br />
P.S Except for saving the text into a file first before getting its file size...</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/java/answers/">answers</category>
			<dc:creator>sukatoa</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/java/answers/877371-capturing-equivalent-file-size-given-string</guid>
		</item>
		<item>
			<title>EXCEL - accessing workbook.A.userform  from workbook.B</title>
			<link>http://bytes.com/topic/visual-basic/answers/877370-excel-accessing-workbook-userform-workbook-b</link>
			<pubDate>Fri, 20 Nov 2009 15:38:33 GMT</pubDate>
			<description><![CDATA[Hello 
 
What I want to do is: 
from this workbook (thisWB), I want to access a userform's properties that are in another Workbook (toolWB)   
 
I...]]></description>
			<content:encoded><![CDATA[<div>Hello<br />
<br />
What I want to do is:<br />
from this workbook (thisWB), I want to access a userform's properties that are in another Workbook (toolWB)  <br />
<br />
I can do this for worksheets, but I want to do it as well for the userform<br />
<br />
I have searched the help files, forums and went through all of the properties of workbooks and worksheets to no avail.<br />
<br />
I have a way to go around my problem but not without rewriting a lot of code. <br />
<br />
If someone has any ideas on the subject, please let me know.<br />
<br />
<!-- CODE -->
<div id="codeHolder" class="codeHolder" style="width: 500px;">
<div class="codeHeader">
	<span class="codeLink" onclick="Blur(this, this.parentNode.parentNode, getChildren(this),true);">Expand</span><span class="codeDivider">|</span><span class="codeLink" onclick="selectAll(this);">Select</span><span class="codeDivider">|</span><span class="codeLink" onclick="WordWrap(this);">Wrap</span><span class="codeDivider">|</span><span class="codeLink" onclick="LineNumbers(this);">Line Numbers</span>
</div>

<div class="codeContent" style="display: block; width: 500px; white-space: nowrap;">
	<ol START="1" highlight="true">

<li class="codeLI">Option&nbsp;Explicit&nbsp;'&nbsp;this&nbsp;code&nbsp;is&nbsp;on&nbsp;a&nbsp;thisWB&nbsp;module</li>
<li class="codeLI">
Public&nbsp;toolWB&nbsp;As&nbsp;Workbook</li>
<li class="codeLI">
Public&nbsp;deskSHEET&nbsp;As&nbsp;Worksheet</li>
<li class="codeLI">
Public&nbsp;deskFRM&nbsp;As&nbsp;UserForm</li>
<li class="codeLI">
Sub&nbsp;setToolWB()</li>
<li class="codeLI">
&nbsp;&nbsp;&nbsp;&nbsp;Set&nbsp;toolWB&nbsp;=&nbsp;toolWB</li>
<li class="codeLI">
&nbsp;&nbsp;&nbsp;&nbsp;Set&nbsp;deskSHEET&nbsp;=&nbsp;toolWB.Sheets(&quot;Desk&nbsp;Bureau&quot;)&nbsp;'&nbsp;this&nbsp;works</li>
<li class="codeLI">
&nbsp;&nbsp;&nbsp;&nbsp;Set&nbsp;deskFRM&nbsp;=&nbsp;toolWB.[???]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'&nbsp;HELP!</li>
<li class="codeLI">
End&nbsp;Sub</li>

	</ol>
</div>
</div>
<!-- /CODE -->


Thanks<br />
<br />
<br />
P :oD</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/visual-basic/answers/">answers</category>
			<dc:creator>pod</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/visual-basic/answers/877370-excel-accessing-workbook-userform-workbook-b</guid>
		</item>
		<item>
			<title>How to Export to excel keeping text colour same ?</title>
			<link>http://bytes.com/topic/javascript/answers/877369-how-export-excel-keeping-text-colour-same</link>
			<pubDate>Fri, 20 Nov 2009 15:30:27 GMT</pubDate>
			<description>Hi all, 
 
I have a simple code that exports an HTML table on an ASP page to excel. 
The code works fine, however if the original text in the HTML...</description>
			<content:encoded><![CDATA[<div>Hi all,<br />
<br />
I have a simple code that exports an HTML table on an ASP page to excel.<br />
The code works fine, however if the original text in the HTML table had a particular colour, it is not exported in the same way.The resulting excel file has all text black only.<br />
Pls. suggest how to solve this problem.<br />
<br />
Any help would be greatly appreciated .<br />
<br />
<br />
Here's the code: <br />
<br />
<br />
<br />
<!-- CODE -->
<div id="codeHolder" class="codeHolder" style="width: 500px;">
<div class="codeHeader">
	<span class="codeLink" onclick="Blur(this, this.parentNode.parentNode, getChildren(this),true);">Expand</span><span class="codeDivider">|</span><span class="codeLink" onclick="selectAll(this);">Select</span><span class="codeDivider">|</span><span class="codeLink" onclick="WordWrap(this);">Wrap</span><span class="codeDivider">|</span><span class="codeLink" onclick="LineNumbers(this);">Line Numbers</span>
</div>

<div class="codeContent" style="display: block; width: 500px; white-space: nowrap;">
	<ol START="1" highlight="true">

<li class="codeLI">&lt;html&gt;</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">
&lt;head&gt;</li>
<li class="codeLI">
&lt;script&nbsp;type=&quot;text/javascript&quot;&gt;</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">
function&nbsp;CreateExcelSheet()</li>
<li class="codeLI">
{</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">
var&nbsp;x=myTable.rows</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">
var&nbsp;xls&nbsp;=&nbsp;new&nbsp;ActiveXObject(&quot;Excel.Application&quot;)</li>
<li class="codeLI">
xls.visible&nbsp;=&nbsp;true</li>
<li class="codeLI">
xls.Workbooks.Add</li>
<li class="codeLI">
for&nbsp;(i&nbsp;=&nbsp;0;&nbsp;i&nbsp;&lt;&nbsp;x.length;&nbsp;i++)</li>
<li class="codeLI">
{</li>
<li class="codeLI">
var&nbsp;y&nbsp;=&nbsp;x[i].cells</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">
for&nbsp;(j&nbsp;=&nbsp;0;&nbsp;j&nbsp;&lt;&nbsp;y.length;&nbsp;j++)</li>
<li class="codeLI">
{</li>
<li class="codeLI">
xls.Cells(&nbsp;i+1,&nbsp;j+1).Value&nbsp;=&nbsp;y[j].innerText</li>
<li class="codeLI">
}</li>
<li class="codeLI">
}</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">
}</li>
<li class="codeLI">
&lt;/script&gt;</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">
&lt;/head&gt;</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">
&lt;body&nbsp;marginheight=&quot;0&quot;&nbsp;marginwidth=&quot;0&quot;&gt;</li>
<li class="codeLI">
&lt;form&gt;</li>
<li class="codeLI">
&lt;input&nbsp;type=&quot;button&quot;&nbsp;onclick=&quot;CreateExcelSheet()&quot;&nbsp;value=&quot;Export&nbsp;to&nbsp;Excel&nbsp;!&quot;&gt;</li>
<li class="codeLI">
&lt;/form&gt;</li>
<li class="codeLI">
&lt;table&nbsp;id=&quot;myTable&quot;&nbsp;border=&quot;1&quot;&gt;</li>
<li class="codeLI">
&nbsp;&lt;tr&gt;</li>
<li class="codeLI">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;&lt;font&nbsp;color=&quot;red&quot;&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">
&nbsp;&lt;tr&gt;</li>
<li class="codeLI">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;&nbsp;</li>
<li class="codeLI">
&lt;tr&gt;</li>
<li class="codeLI">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;&nbsp;</li>
<li class="codeLI">
&lt;tr&gt;</li>
<li class="codeLI">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&lt;td&gt;Test&lt;/td&gt;</li>
<li class="codeLI">
&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;</li>
<li class="codeLI">
&lt;/table&gt;</li>
<li class="codeLI">&nbsp;</li>
<li class="codeLI">
&lt;/body&gt;</li>
<li class="codeLI">
&lt;/html&gt;</li>

	</ol>
</div>
</div>
<!-- /CODE -->


</div>

]]></content:encoded>
			<category domain="http://bytes.com/topic/javascript/answers/">answers</category>
			<dc:creator>127mohit</dc:creator>
			<guid isPermaLink="true">http://bytes.com/topic/javascript/answers/877369-how-export-excel-keeping-text-colour-same</guid>
		</item>
	</channel>
</rss>
