<?xml version="1.0" encoding="ISO-8859-1"?>

<rss version="2.0">
<channel>
	<title>VBA Express Forum</title>
	<link>http://www.vbaexpress.com/forum</link>
	<description><![CDATA[This is a Microsoft Office Visual Basic for Applications Discussion Forum and Code Center]]></description>
	<language>en</language>
	<pubDate>Thu, 09 Sep 2010 03:25:50 GMT</pubDate>
	<generator>vBulletin</generator>
	<ttl>60</ttl>

	<item>
		<title>IF statement equivalent in SQL</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33949&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 23:09:26 GMT</pubDate>
		<description><![CDATA[Hey folks,

I'm not a SQL geek, and I'm having a little trouble coming up with some syntax.  I'm wondering if someone can help me out.
 
I have two tables that I'm working with:

tblBudget_Ops
tblBudget_ForecastEach has identical fields in it:

Account]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=16"><![CDATA[Access Help]]></category>
		<author><![CDATA[example@example.com (Ken Puls)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33949</guid>
	</item>

	<item>
		<title>Excel Concatentate formula...</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33948&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 21:13:23 GMT</pubDate>
		<description><![CDATA[This should be simple right. I found some examples regarding quotes in arrays but I can't seem to get the syntax to work for the lowly concatenate formula.

I need to get the following written into a a cell in excel using VBA.

=CONCATENATE(sizeDesc,&quot; (&quot;,width,&quot; x &quot;,height,&quot; &quot;,bleedVal,&quot;)&quot;,&quot;;...]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=17"><![CDATA[Excel Help]]></category>
		<author><![CDATA[example@example.com (Papadopoulos)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33948</guid>
	</item>

	<item>
		<title>How do I tap into User Level Security with VBA?</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33947&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 20:47:46 GMT</pubDate>
		<description><![CDATA[I have searched long and hard to find the code necessary to tap into the User Level Security functionality and can't seem to find it.  I'm sure there's a way, it's just a matter of figuring it out.   I basically want to add new users and groups as well as modify permissions to objects via my own...]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=16"><![CDATA[Access Help]]></category>
		<author><![CDATA[example@example.com (Hathman)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33947</guid>
	</item>

	<item>
		<title>Module question</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33946&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 20:45:05 GMT</pubDate>
		<description><![CDATA[Can you call a sub from module2 from module1?  I forget.]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=17"><![CDATA[Excel Help]]></category>
		<author><![CDATA[example@example.com (austenr)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33946</guid>
	</item>

	<item>
		<title>Averages of column and formatting</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33945&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 20:19:01 GMT</pubDate>
		<description><![CDATA[:dunno In column C i want to do two things:
(1)FORMAT COLUMN C &gt; All numbers entered are formated in percentages.  (no spaces after decimal)  The formula that generates these percentages is in each cell of column C.  It is . . 
=SUM(F5:M5)/8
 
(2)Secondly, I want to obtain a running average of the...]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=17"><![CDATA[Excel Help]]></category>
		<author><![CDATA[example@example.com (Juicey27)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33945</guid>
	</item>

	<item>
		<title>Border war</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33944&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 17:42:10 GMT</pubDate>
		<description><![CDATA[I created a style that takes away borders and changes the font in a range of cells. That's not the problem. 
 
When I try to reverse it with the opposite of the style I used and it puts borders around the cells inside the range which has a border around it.
 
So is there a way to just reverse the...]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=17"><![CDATA[Excel Help]]></category>
		<author><![CDATA[example@example.com (austenr)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33944</guid>
	</item>

	<item>
		<title>Fill a combobox from a spreadsheet?</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33943&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 14:46:17 GMT</pubDate>
		<description><![CDATA[Hi.  It's been years since I did any VBA and need to relearn some basics.

I need to fill a combobox from a list on a spreadsheet.  That isn't hard - either use .additem, or set the RowSource of the combobox to the column.  The issue is that more entries may be added to the list at any time, and...]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=17"><![CDATA[Excel Help]]></category>
		<author><![CDATA[example@example.com (melgibson2)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33943</guid>
	</item>

	<item>
		<title>Target.Offset(0,2) &amp; Run-time error</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33942&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 14:40:51 GMT</pubDate>
		<description><![CDATA[Hi,
 
Below is a worksheet change event routine I'm compiling. The aim of the code is to do a look up and place the result a couple of columns to the right of the target cell.
 
In this instance, the routine is fine since it uses target.Offset(0,1). It correctly places the result in the cell next...]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=17"><![CDATA[Excel Help]]></category>
		<author><![CDATA[example@example.com (starsky)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33942</guid>
	</item>

	<item>
		<title>permuations</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33941&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 13:25:10 GMT</pubDate>
		<description><![CDATA[hello .. I neeed your help (again). I have to make an calculation of the surface and I have the following dates
Diameter (columns)
Thicknesses (rows)
then, the calculation need to be drop in an excel range, I think it is something like this? or I am far away from VBA reality

'array dia.
Dia(1) =...]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=17"><![CDATA[Excel Help]]></category>
		<author><![CDATA[example@example.com (white_flag)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33941</guid>
	</item>

	<item>
		<title>test filter and delete row in OLD and NEW office</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33939&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 11:21:38 GMT</pubDate>
		<description><![CDATA[Please, does somebody can tell me, how to fix the code below,
to work correctly in both office (2000 / 2007) ?
 
When is used filtering in older office to delete specific rows,
filter also deletes row with &quot;Total&quot; which is not filtred,
 
if is not used OFFSET, probably new office do not work...]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=17"><![CDATA[Excel Help]]></category>
		<author><![CDATA[example@example.com (hardlife)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33939</guid>
	</item>

	<item>
		<title>Merge two data inputs</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33938&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 10:51:07 GMT</pubDate>
		<description><![CDATA[Greetings!!

1. An excel sheet contains data in columns as below--

Col A : IPAddress
Col B : Blank(no data at present)
Col C : Country
Col D : Region
Col E : City
Col F : Address]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=17"><![CDATA[Excel Help]]></category>
		<author><![CDATA[example@example.com (maheshr68)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33938</guid>
	</item>

	<item>
		<title>Solved: Delete range based on 3 cell values?</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33937&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 10:47:05 GMT</pubDate>
		<description><![CDATA[HI 
 
Just struggling with correct code for the following
 
If cells B20, B23 &amp; B27 are empty then delete rows 12 to 29
 
If Range(&quot;B20&quot;).Value = &quot;&quot; And Range(&quot;B23&quot;).Value = &quot;&quot; And Range(&quot;B27&quot;).Value = &quot;&quot; Then
Rows(&quot;12:29&quot;).Select
Selection.Delete shift:=xlUp
End If]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=17"><![CDATA[Excel Help]]></category>
		<author><![CDATA[example@example.com (Blackie50)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33937</guid>
	</item>

	<item>
		<title>Outlook cannot do this action on this type of attachment - script to save attachments</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33936&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 09:37:56 GMT</pubDate>
		<description><![CDATA[Hi All,
 
I have some code I am using to save .mpp attachments from emails into a specific folder.
 
The error message I states outlook cannot do this action on this type of attachment.
 
This message appears when a message in the inbox does not have an attachment other than the company logo in the...]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=18"><![CDATA[Outlook Help]]></category>
		<author><![CDATA[example@example.com (snowbounduk)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33936</guid>
	</item>

	<item>
		<title>CheckBox field in Activedocument check</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33935&amp;goto=newpost</link>
		<pubDate>Wed, 08 Sep 2010 08:19:03 GMT</pubDate>
		<description><![CDATA[Hi,
is there a way how to check protected document (form) if concrete CheckBox or FormField has been changed before closing this form?
I need to force applicants not to &quot;forget&quot; fill relevant parts of the form othervise I will go mad...:banghead:

Thanks in advance for any help.
Peter]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=20"><![CDATA[Word Help]]></category>
		<author><![CDATA[example@example.com (ekosarisan)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33935</guid>
	</item>

	<item>
		<title>Loops that write specific data to file</title>
		<link>http://www.vbaexpress.com/forum/showthread.php?t=33930&amp;goto=newpost</link>
		<pubDate>Tue, 07 Sep 2010 22:25:34 GMT</pubDate>
		<description><![CDATA[Hi all.
I'm trying to create detailed report pages based on excel data.

Here's a little view to the sheet:
ht tp://i33.tinypic.com/2q8dpoi.jpg
I've also attaced this sample if you want to work on it.

First of all, I want the method to &quot;remember&quot; some coulmns by their titles (they'll be always the...]]></description>
		<category domain="http://www.vbaexpress.com/forum/forumdisplay.php?f=17"><![CDATA[Excel Help]]></category>
		<author><![CDATA[example@example.com (MeiR_ct)]]></author>
		<guid isPermaLink="false">http://www.vbaexpress.com/forum/showthread.php?t=33930</guid>
	</item>
</channel>
</rss>