Search:

Type: Posts; User: d_rasley; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. I have found that Open Office is far more than...

    I have found that Open Office is far more than adequate for home users. Free, updated, and powerful. How much collaboration goes on in a non-commercial setting?
  2. The problem is with the batch files and such. ...

    The problem is with the batch files and such. The paths to the programs are hard-coded to a their XP-style path, C:\Program Files\..., so that the command line is built to execute the program with...
  3. Installing 32-bit software on a Windows7-64 PC

    I recently set up a new Windows 7-64 PC to replace my current XP setup. A lot of the programs I use are 32-bit and so were installed in the \Program Files (x86)\ folder by default. Unfortunately...
  4. Replies
    2
    Views
    11,508

    VBA to refresh all queries and pivot tables

    For years I've relied on a chunk of code (from Ozgrid.com) to loop through each worksheet in a file to refresh all queries, and then loop through again to refresh all pivot tables. It worked great...
  5. Replies
    1
    Views
    437

    MSQuery time conversion error

    I have an Access database that has the Time as text field ("0350" for 3:50 AM), which is recalculated in a query into a TimeValue decimal value. When I use Excel 2000 on a Windows XP computer...
  6. Replies
    6
    Views
    1,556

    Re: E-mail address 'aliases' add security......

    Re: E-mail address 'aliases' add security... "myname+windowssecrets@gmail.com" is really a pretty weak way to 'disguise' your email address. All a scoundrel needs to do is look for and eliminate...
  7. Replies
    15
    Views
    5,644

    Anyone find any solutions for this? I've only...

    Anyone find any solutions for this? I've only started playing with email after all these years, and I'm experiencing the same thing. I wonder if it's a function of the device you're using. For...
  8. Prevent message from being opened in junk folder (2000 SP3)

    I use SpamBayes to filter junk mail into 'Junk E-Mail' and 'Junk Suspects' folders. As an added measure of security I would like to have a way to prevent any messages in these folders from being...
  9. Replies
    1
    Views
    400

    Hit any key to ... (O2K SP3 (Excel))

    I have a workbook_open procedure set up, but I want to insert a 'hit any key' or 'hit esc' check so the user can prevent the remainder of the autoexec code from running, ie open in maintenance mode...
  10. Replies
    8
    Views
    423

    Re: Read text (Word 2000)

    Got it working, thanks. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> I just had to tweak a little to strip non-printing characters off the end before I could pull the date from the...
  11. Replies
    8
    Views
    423

    Re: Read text (Word 2000)

    My code opens the file to inset page breaks, then save & archive the source and converted files. When archiving I put a datestamp on the file. Currently unable to read the date from the file itself...
  12. Replies
    8
    Views
    423

    Re: Read text (Word 2000)

    Both solutions seem to imply the file needs to be opened by the routine in order to read it. In the situation I am working with the file is already open. Would these work under this circumstance? ...
  13. Replies
    8
    Views
    423

    Read text (Word 2000)

    I have a text file that I use Word to open & manipulate. The third line has a date I want to capture and use. How do I tell VBA "OrderDate = Right(Line3,10)"?

    <pre>Line1........
    Line2........
    ...
  14. Re: Using the 'F' keys for shortcuts (XP PRO)

    A little utility I use is The Wonderful Icon. Small in size, big in features, and absolutely <img src=/S/free.gif border=0 alt=free width=30 height=15>.
  15. Replies
    1
    Views
    735

    Selfcert vs Office 2007 (Office 2000)

    I used selfcert to create a certificate and enable me to sign my vba macros, but this doesn't appear to help when my Office 2000 files are opened up in Office 2007. The option to 'always trust' is...
  16. Replies
    5
    Views
    1,701

    Re: Stop a running program (VBA 6.0)

    Works nice, thanks.
  17. Replies
    5
    Views
    1,701

    Re: Stop a running program (VBA 6.0)

    My immediate desire is to be able to stop 'Batchrun.exe' - a batch control program that actually launches the Access program this bit of code would be used in. I want to test a condition, and then...
  18. Replies
    5
    Views
    1,701

    Stop a running program (VBA 6.0)

    I want to be able to stop a running program/application from within a VBA function. I've found a number of ways to start a program but none that can end a program. What I want to do is something...
  19. Replies
    2
    Views
    515

    Re: Vista vs Office 2000

    One mention comes from Lockergnome at http://www.lockergnome.com/nexus/windows/2...ips-and-tricks/, point #3:<blockquote><hr>Your software won
  20. Replies
    2
    Views
    515

    Vista vs Office 2000

    Is there any definitive and detailed information available on Office 2000's compatibility with Vista? I've seen bits and pieces here and there that suggest there may be problems, especially with...
  21. Re: Create mailing list address array (Excel 2k VBA)

    Such a simple solution! <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>
  22. Create mailing list address array (Excel 2k VBA)

    I want to create an easily-manageable mailing list on an Excel sheet that can be read into an array variable and passed to a sendmail command: ActiveWorkbook.SendMail...
  23. Re: Format a cell with a custom function (Excel 2000 SP-3)

    Interesting solution, but a bit of an overkill for how I would be using the formula. I am intrigued with your ThisWorkbook subs - I'm sure I'll find a use for them somewhere.
  24. Format a cell with a custom function (Excel 2000 SP-3)

    I wrote a function to convert dates from yyyymmdd format to a numeric date (20061128 => 39049) but in addition to creating the date number I want the cell formatting changed to mm/dd/yy. Is there...
  25. Replies
    4
    Views
    1,300

    Re: Installation Hangs (XP Pro SP2 )

    What setting is the BIOS using for Advanced Power Management? My hardware fully supports it, but Microsoft can't detect the support, causing my installations to always fail at the exact same point...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4