Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    607

    Thanks RG! I was actually late binding in my code...

    Thanks RG! I was actually late binding in my code but I had the MSWord library enabled in the Excel 2003 references. Disabling the reference fixed the error.
  2. Replies
    2
    Views
    607

    MSWord14.olb Reference Error

    Hi All,

    I have an Excel 2003 macro that contains an Access and Word reference (both 11.0). It opens fine in Excel 2010 and saves normally, as a 97-2003.xls, in Excel 2010. Once opened again in...
  3. Replies
    2
    Views
    3,632

    Date picker in 64-bit Excel 2010

    Hi All,

    Finally moving from 32 bit Win XP & Excel 2003 to 64 bit Win 7 & Excel 2010. When I opened some of these old 2003 workbooks in Excel 2010, it did not recognize the Date Picker Active X...
  4. Replies
    2
    Views
    17,066

    We are planning to move from Office 2003 to...

    We are planning to move from Office 2003 to Office 2010 in the near future & we have a large number of Excel workbooks to convert, many containing macros. To make the process easier for everyone, we...
  5. Replies
    4
    Views
    15,375

    Running "compile" doesn't generate an error but I...

    Running "compile" doesn't generate an error but I do receive error# 445, "object doesn't support this action" when I step to the line:

    Set FS = Application.Filesearch

    So, is there a replacement...
  6. Replies
    4
    Views
    15,375

    Using VBA Filesearch in Excel 2010?

    I've started to explore upgrading my VBA code from Excel 2003 to Excel 2010 and keep finding lots of changes! My latest dilemma comes from the list of "Object Model Changes Since Microsoft Excel...
  7. Replies
    2
    Views
    4,928

    This ActiveX control has been disabled because of...

    This ActiveX control has been disabled because of a security problem - see Microsoft Security Advisory (969898): Update Rollup for ActiveX Kill Bits.

    You can enable it again (which makes your...
  8. Replies
    2
    Views
    4,928

    I'm having some trouble using the MScomm control...

    I'm having some trouble using the MScomm control 6.0. I've made the reference & registered the MSCOMM32.ocx but whenever I try to add the control from the toolbox onto a form I receive the following...
  9. Replies
    3
    Views
    1,744

    Activate reference via code (Office 2003 VBA)

    Is it possible to read the values of activated references and activate/deactivate the reference using VBA code? I would like to toggle the Adobe Acrobat Distiller reference based on which user is...
  10. Replies
    6
    Views
    1,123

    Re: Windows Folder Properites (Win XP, VB 6, VBA)

    Thanks to all for your input. I didn't think there was an elegant solution to this but I had to "run it past the experts" first.
  11. Replies
    6
    Views
    1,123

    Windows Folder Properites (Win XP, VB 6, VBA)

    Is it possible to add, then search on, Summary information (Title, Subject, Author, Category, Keywords and Comments) to folders? My goal is to search on archived folders vs files since all files will...
  12. Re: Copied Worksheet Looks Different (Excel 2003 S

    Jerry,

    There use to be a file in the Excel startup folder that was used as an intermediate between some Access & Excel data on this machine. It will take me several days to verify since I'm out of...
  13. Copied Worksheet Looks Different (Excel 2003 SP2)

    Has anyone seen this one before?

    All PC's in our office have the same OS (Win XP SP2) & Office (2003 SP2) configurations. The problem only occurs on one desktop but it is the primary one used...
  14. Replies
    2
    Views
    514

    Re: Form that's always visible (VB/Office 11)

    Thanks Hans!

    Yes, this is not quite what I was looking for but the custom toolbar works well enough & no coding required.

    John
  15. Replies
    2
    Views
    514

    Form that's always visible (VB/Office 11)

    Hello,

    I've been requested to try to recreate the Office shortcut bar since it no longer exists in Office 2003. Any tips on how to keep the form "always on top" would be appreciated.

    Thanks,...
  16. Replies
    14
    Views
    2,116

    Re: VBA Code - Find & Replace ((xl97,2000,2002))

    Thanks Kevin.

    Never say never !! <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
  17. Replies
    14
    Views
    2,116

    Re: VBA Code - Find & Replace ((xl97,2000,2002))

    Yes - that is an option IF it can be done programatically (how do I copy the userform or module code & paste it back in?).

    John
  18. Replies
    14
    Views
    2,116

    Re: VBA Code - Find & Replace ((xl97,2000,2002))

    Kevin & Jan,

    Thanks for your input. Guess I've got a little digging to do. I'll get back to this thread for other possibilities if I can't make any progress.

    Thanks Again,
    John
  19. Replies
    14
    Views
    2,116

    Re: VBA Code - Find & Replace ((xl97,2000,2002))

    Legare,

    Thanks for the link but I only see flexifind working in the worksheet & not in the VBE.

    John
  20. Replies
    14
    Views
    2,116

    Re: VBA Code - Find & Replace ((xl97,2000,2002))

    Kevin,

    I got as far as the find part but was looking for something simpler than .replaceline since each line that I want to change is going to be different. Don't know if I need an API call or...
  21. Replies
    14
    Views
    2,116

    VBA Code - Find & Replace ((xl97,2000,2002))

    I would like to automated the VBE's find & replace (edit...replace) so I can modify 100+ workbooks containing various subroutines. The changes to code would be in userforms and standard modules,...
  22. Re: DSL & NT 4 Server (Win XP (SP1), NT 4 server (SP4))

    Thanks Charlie,

    I found netbeui of the XP Cd yesterday & came back to post my results when I saw your response. It's the easy way out for now but I'll take it.

    Thanks to everyone for you help....
  23. Re: DSL & NT 4 Server (Win XP (SP1), NT 4 server (SP4))

    Joe,

    Both the win2k & XP workstations have their respective SP-1's. I will look into the NT 4 server SP6a to see if they mention anything relating to my problem.

    Thanks,
    John
  24. DSL & NT 4 Server (Win XP (SP1), NT 4 server (SP4))

    I was wondering if anyone has had this problem and can share a fix for what I'm doing wrong.

    We have a small network (NT4 Server, SP4) with a mix of clients (Win 98, NT4 workstation, Win 2000 &...
  25. Replies
    0
    Views
    264

    Task Scheduler & Recycle Bin

    I would like to run disk cleanup via the scheduler but was wondering if there is a way to limit what is deleted in the recycle bin (switches, registry, whatever works). I would like to run the disk...
Results 1 to 25 of 40
Page 1 of 2 1 2