Search:
Type: Posts; User: agmorgan
Search:
Search took 0.27 seconds.
-
I've always followed the doctrine of using the "Body Text" style in preference of the "Normal" style when creating Word documents.
However, in 2010 I can't seem to find it.
It isn't in the Style...
-
Thats the unfortunate part, very often banks won't allow external laptops on their networks.
I'm starting to think it might be easier to do it in the reverse direction - connect to the database...
-
I didn't understand your second statement.
Are you saying that I can do it with just ADO and OLEDB and no extra drivers?
The way I understood it was the same as your first statement, that an...
-
How do I connect to an Oracle database from Excel to run some queries when I don't have access to tns or ODBC?
I currently have a series of SQL queries that I run on the (Oracle) database of a...
-
Well noone else answered so I had no reason to unsubscribe :D
-
I think he might be the author because the exact same text with the same username is also posted on StackOverFlow and UbuntuForums.
Interesting to look back and see how I've moved on now though....
-
There are (at least) two different types of online scanners.
The first is, as you mention, a service that scans files you upload.
The second is a webpage with an ActiveX control or a Java applet...
-
Thats a little complicated with the command lines.
Get an Ubuntu CD, it will recognise your NT discs.
Click on them so that they are mounted.
Use an online scanner to scan the mounted drive...
-
Will be the BIOS setting not having CD above hard disk in the boot order
-
https://help.ubuntu.com/community/Installation/SystemRequirements
-
I had to do a Vista repair install and was quite impressed with the Windows.old folder and saving of my data.
Unfortunately it meant reinstalling my applications.
Since I have several simple apps...
-
There are lots of reviews on the CustomPC/BitTech site
http://www.bit-tech.net/hardware/storage/
TRIM support definitely seems to be an issue for certain drives.
According to their tests, not...
-
I've seen a couple of reviews that say performance seems to inexplicably drop off after a few months of use (must be RC).
Did anyone here use the RC long enough to see/not see this effect?
-
Sorry for the confusion :o
I did mean Recently used Items in Start menu (i.e the programs)
Unfortunately, under properties, the number of programs in the start menu is already listed as 6.
Are...
-
For some reason, none of my recently used programs are appearing on my XP Start Menu.
I thought it might be a group policy, but when I checked the registry the obvious values are all set to 0...
-
I want to remove all xml files in a temporary directory before proceeding with my macro.
What is the preferred method?
Kill is a one liner but will throw a run time error if there are no xml files...
-
I only wanted to read the items.
e.g. I might have 100 items, but after filtering at level 1, 30 are displayed on screen.
I wanted to read all the visible items at level 3 (i.e. 30 items).
The...
-
This will add an autofilter and filter on the critera column 1 equal to SPOT and column 2 not equal to 5
(Obviously put your own criteria in!)
Range("A1").AutoFilter
Dim rngFilter As Range
Set...
-
If I create a Pivot Table with 3 sets of row items but hide all but 2 of the top level pivot items, the visible property of the 3rd level items doesn't seem to be affected.
e.g. This shows the name...
-
I am getting an error when I am programmatically opening another Workbook from my macro:
Compile error in hidden module: ThisWorkbook
Set wb = Workbooks.Open(Filename:=strFileName,...
-
Amazing what a different perspective on things comes up with!
Searched for vba userform continue background excel and and came up with this
http://www.ozgrid.com/forum/showthread.php?t=28949
...
-
I'm using the example from here to create a progress bar in my VBA
http://spreadsheetpage.com/index.php/tip/displaying_a_progress_indicator/
I took all the code out from inside the userform and I...
-
Just tested on an XP machine and it works fine.
Vista issue perhaps?
-
I am using the code from this site to create a zip file and copy all the files from a directory into it
http://www.rondebruin.nl/windowsxpzip.htm
However when I try to set the Namespace for the...
-
For comparing the content of spreadsheet I use this addin http://www.worksheetcompare.com/
However, it doesn't look at the VBA.
Does anyone know of a comparison tool that will compare the VBA...
-
Is it possible to assign keyboard shortcuts to actions that don't currently have any?
e.g. Comment/Uncomment Block
MZTools looks like it is doing it, but I wonder if it has its own...
-
I have a list of Ids in a Column (as well as data in columns next to this).
I have auto-filtered that column and now I need to check for matches in that new filtered list.
I tried doing this but...
-
Thanks.
Seems a bit more complete than what I subsequently found on planet source code.
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=64390&lngWid=-10
-
In 2007 I can use the WorksheetFunction.NetworkDays to find the number of business days between two dates.
However, when the code is run on another PC running 2003 (without the Analysis ToolPak) I...
-
An interesting development!
I actually inherited the original sheet and it looks like the autofilter is actually part of a List (or Table in 2007 parlance).
I've converted it to a normal range...
-
So far I am doing it multiple times to try and catch all commas (very error prone).
strNames = Replace (strNames, ",,", ",")
strNames = Replace (strNames, ",,", ",")
strNames = Replace (strNames,...
-
I have a method that builds up a comma separated list returned as a string.
Unfortunately it sometimes returns stuff like
Tom,,,,,,Dick,,,,,,Harry
I tried replace to return single commas e.g
...
-
Something very strange is going on.
I have a spreadsheet saved with an autofilter on.
I then call one method (via a button) which fills some data and does some filtering.
I then change one of the...
-
I can't seem to find the developer edition on the Microsoft site.
Is it called something else in 2007?
-
I have a column of IDs and I want to check if there are duplicates in this column as I loop through it.
However, I need to ignore suffixes to the data.
e.g.
123 - false
124 - true
124 - true...
-
This page (and others on msdn) says that you can create them from VBA
http://msdn.microsoft.com/en-us/library/aa166223(office.10).aspx
However, I fail on step 3
From the File menu, select New...
-
After using some IDEs in other languages for a few years, coming back to do a bit of VBA has left me feeling quite frustrated and unproductive!
A few things that immediately spring to mind are:
...
-
Sorry. Didn't mean to come across as aggressive.
I've spent too much time in the Sun Java forums :p
From the help file, yours seems to be of a code repository though, rather than a true...
-
Didn't want to duplicate anything that had already been done.
There doesn't seem to be any source in the attachment on that thread.
I was under the impression that VBF didn't allow compiled...
-
I've seen this class generator for VB6, but is equally applicable to VBA.
http://edais.mvps.org/Files/Full/PropGen/index.html
However, it runs as a standalone file, which is a bit of a pain.
Are...
|
Click Here to Expand Forum to Full Width
|