Search:

Type: Posts; User: agmorgan

Page 1 of 13 1 2 3 4

Search: Search took 1.39 seconds.

  1. MsOf10 [WORD] Why Is The Body Text Style Always Hidden?

    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...
  2. Re: Connect To Random Oracle Database From Excel

    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...
  3. Re: Connect To Random Oracle Database From Excel

    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...
  4. Connect To Random Oracle Database From Excel

    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...
  5. Replies
    8
    Views
    2,840

    Re: [Prolog] Nice Free IDE

    Well noone else answered so I had no reason to unsubscribe :D
  6. Replies
    8
    Views
    2,840

    Re: [Prolog] Nice Free IDE

    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....
  7. Replies
    21
    Views
    4,754

    Re: Is it even possible?

    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...
  8. Replies
    21
    Views
    4,754

    Re: Is it even possible?

    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...
  9. Replies
    1
    Views
    3,032

    Re: Distro specific boot problems

    Will be the BIOS setting not having CD above hard disk in the boot order
  10. Replies
    1
    Views
    2,200

    Re: Linux Hardware Configuration

    https://help.ubuntu.com/community/Installation/SystemRequirements
  11. Replies
    0
    Views
    431

    Fix MS Office Installation

    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...
  12. Replies
    65
    Views
    3,399

    Re: Solid State Hard Drives

    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...
  13. Replies
    61
    Views
    2,846

    Re: Windows 7 - would you recommend it?

    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?
  14. Replies
    9
    Views
    2,040

    Re: No MRU List On XP Start Menu

    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...
  15. Replies
    9
    Views
    2,040

    No MRU List On XP Start Menu

    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...
  16. Replies
    2
    Views
    544

    [EXCEL] Kill FSO or API

    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...
  17. Replies
    2
    Views
    1,885

    Re: [EXCEL] Visible Pivot Items

    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...
  18. Thread: Autofilter

    by agmorgan
    Replies
    3
    Views
    570

    Re: Autofilter

    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...
  19. Replies
    2
    Views
    1,885

    [EXCEL] Visible Pivot Items

    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...
  20. [EXCEL] Suppress Compile error in hidden module

    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,...
  21. Re: [EXCEL] Creating A Progress Bar

    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
    ...
  22. [RESOLVED] [EXCEL] Creating A Progress Bar

    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...
  23. Replies
    1
    Views
    636

    Re: [EXCEL] Cant Create Zip NameSpace

    Just tested on an XP machine and it works fine.
    Vista issue perhaps?
  24. Replies
    1
    Views
    636

    [EXCEL] Cant Create Zip NameSpace

    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...
  25. Replies
    0
    Views
    448

    [EXCEL] Compare VBA Projects

    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...
  26. Replies
    1
    Views
    594

    [EXCEL] Assign Keyboard Shortcut

    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...
  27. [Excel] Find Matches In Autofilter Column

    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...
  28. Re: [Excel] WorksheetFunction.NetworkDays in 2003

    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
  29. [RESOLVED] [Excel] WorksheetFunction.NetworkDays in 2003

    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...
  30. Replies
    1
    Views
    708

    Re: AutoFilter With block variable not set

    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...
  31. Re: Replace All Duplicates in String

    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,...
  32. [RESOLVED] Replace All Duplicates in String

    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
    ...
  33. Replies
    1
    Views
    708

    AutoFilter With block variable not set

    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...
  34. Replies
    7
    Views
    1,937

    Re: [EXCEL] Improve VBA IDE

    I can't seem to find the developer edition on the Microsoft site.
    Is it called something else in 2007?
  35. Replies
    1
    Views
    480

    CountIf Including String

    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...
  36. Replies
    7
    Views
    1,937

    Re: [EXCEL] Improve VBA IDE

    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...
  37. Replies
    7
    Views
    1,937

    [EXCEL] Improve VBA IDE

    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:
    ...
  38. Replies
    4
    Views
    3,311

    Re: Class Generator Addin

    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...
  39. Replies
    4
    Views
    3,311

    Re: Class Generator Addin

    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...
  40. Replies
    4
    Views
    3,311

    Class Generator Addin

    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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width