Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. michaelbr55

    Where should a macro template be installed in Vista

    I have a Program that I distribute in a setup file that contains a Word Template, a couple of Word Documents and various other associated files that I want to install on Windows Vista. The program is already being used by many people on other version of Windows and the setup file has been...
  2. michaelbr55

    Change Font Name in Function

    Ok Skip, thanks for that, at least I can stop looking for a solution now. Michael Bryant Southern Ocean Software http://southernoceansoftware.com
  3. michaelbr55

    Need help with Macro in MS Word 2007

    PanfTeach What error was it generating? Like I said I can't test this myself, have a look at http://msdn.microsoft.com/en-us/library/microsoft.office.tools.word.document.compare(VS.80).aspx for info about Compare. Michael Bryant Southern Ocean Software http://southernoceansoftware.com
  4. michaelbr55

    Change Font Name in Function

    Yes it is a UDF called from a cell formula, so how can I make changes to the sheet. I even tried calling a sub from the function and that doesn't work either. Is there no way to do this at all? Michael Bryant Southern Ocean Software http://southernoceansoftware.com
  5. michaelbr55

    How to replace variable placeholder in Word doc with variable text

    I don't know if this is better than your solution, I tried it and it didn't work. Why not stick with what you know, Instr, Right, Mid always work for me. Try this if you like Sub ReturnVariables() Dim bReturn As Integer, eReturn As Integer, vReturn(100) As String Dim MySent, x As Integer, y...
  6. michaelbr55

    Excel Dialog with arguments

    The argument to pass to the dialog are name_text, password_text, download_logical ie With Application.Dialogs(xlDialogMailLogon) .Show michael, 29837452, True End With Michael Bryant Southern Ocean Software http://southernoceansoftware.com
  7. michaelbr55

    Change Font Name in Function

    I have a function which I want to return a value and change the font of the cell where the return value is to be. But I can't get it to work, any ideas? Here is the code Function Power_3Ph(Optional Voltage As Variant = 0, Optional Current As Variant = 0, Optional Resistance As Variant = 0...
  8. michaelbr55

    How to Select a Value in an IE Drop List?

    Can you describe your problem more clearly, do you mean Internet Explorer for IE, where is your code? Michael Bryant Southern Ocean Software http://southernoceansoftware.com
  9. michaelbr55

    Need help with Macro in MS Word 2007

    Why are you using Merge, don't you want to compare? How about something like this? Private Sub DocumentCompare() Dim fs, f, f1, fc, s, DocPath, Myfile DocPath = "F:\Grade\214-7\214-7-3\MLA Reports\packet 1\" Myfile = DocPath & "\key1.doc" Set fs =...
  10. michaelbr55

    Can't save template after adding Digital Cerrtificate

    Thanks PHV I should never have doubted you, installing the updates and SP worked at treat.
  11. michaelbr55

    Can't save template after adding Digital Cerrtificate

    No I haven't applied all of the SP & SR? but the users of my program probable haven't either, so I have to get it working on the system I have!
  12. michaelbr55

    Can't save template after adding Digital Cerrtificate

    I have just installed a digital certificate and added it to a Word Template, it all looks OK but when I try to save the template I get and error message Can't save not enought space on the drive, even thought there is 75 Gigs on the drive. I am running MS Word 2000 Profession on MS Vista Home...
  13. michaelbr55

    Error writing ini files in Vista

    When trying to write to an 'ini' file from Word in Windows Vista the following error occurs "Run-time error '-2147467259 (80004005) Method 'PrivateProfileString' of object 'System' failed" Does anyone know how to overcome this error, or what is causing it?
  14. michaelbr55

    Macro stops and send microsoft a report

    I wouldn't like to question the users about the lack of error message, and looking over her shoulder is not really and option, my eyes aren't that good anymore and she is in the US and I am in Australia, so even phone conversations aren't that easy, or cheap! What event logs could I get her to...
  15. michaelbr55

    Macro stops and send microsoft a report

    The user says that when it says send error report there is no specific error message. Mike [pipe]
  16. michaelbr55

    Macro stops and send microsoft a report

    I have a user of a collection of MS Word macros that is having this problem whenever she tries to activate any of the macros. The macros don't run at all and Word pops up a box saying it is going to send a report to Microsoft. This collection is in use by many other users but none have...
  17. michaelbr55

    Getting rid of a Menu Bar

    Thanks Loomah, While it most certainly would have been more sensible to make the bar ".visible=false" I had tried that and it just didn't work, but the ".enabled=false" works a treat. I don't think users of the template will want the Mail Merge menu anyway, and tough if they do! Thanks...
  18. michaelbr55

    Getting rid of a Menu Bar

    I have a template with which I create a document and even though the template does not have the "Mail Merge" menu when I create a new document based on the template the "Mail Merge" menu is visible. How can I get rid of this once and for ever! [pipe] Mike.
  19. michaelbr55

    How can I determine if Office is Installed

    Hi Mike, My application is a MS Word macro, it only requires Word to run, but to add the commandbars collection it requires the MS Office 9.0 Object Library which is located on my machine in "C:\Program Files\Microsoft Office\Office\MSO9.dll" If a user only has MS Word installed...
  20. michaelbr55

    How can I determine if Office is Installed

    Yes! you are missing something, It is possible to install office applications without Office, ie you can install MS Word or Excel or Access all by themselves, and not have Office installed. Mike [pipe]

Part and Inventory Search

Back
Top