Search:

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

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    328

    Excel data to Word (2003)

    We have a patient list and doctor list in 2 separate Excel files and they must remain separate and unless someone knows how I can use 2 different data sources in a merge document, merging is not the...
  2. Replies
    5
    Views
    482

    Re: Convert Case of Variable (Word 2003)

    Thank you Hans. Here is what I was looking at in the Word 2003 VB Help file:

    Case Property
    See AlsoPropertiesMethodsEventsSpecificsReturns or sets a WdCharacterCase constant that represents the...
  3. Replies
    5
    Views
    482

    Re: Convert Case of Variable (Word 2003)

    Actually I am going from all upper case to title case and just could not figure out how to it using the Case property the simplest way. I do know how to assign the variable contents to a bookmark...
  4. Replies
    5
    Views
    482

    Convert Case of Variable (Word 2003)

    I use the following to insert a company name into a Word document from Outlook. How do I change the case of strProvider before inserting it? (I think I have seen this answer somewhere on the board...
  5. Replies
    11
    Views
    639

    Re: Move Files (XP SP3)

    Thank you for your help. In the interest of simplicity and after a couple of hours of investigation and testing (and because I really didn't understand your solution since I am such a neophyte at...
  6. Replies
    11
    Views
    639

    Re: Move Files (XP SP3)

    I have one more step I need to add to the following macro. If there are no files found to print, it gives an error. I need to add an "If" there ar eno files, go to the quit function. This is a...
  7. Replies
    11
    Views
    639

    Re: Move Files (XP SP3)

    Thank you again, that worked like a charm.
  8. Replies
    11
    Views
    639

    Re: Move Files (XP SP3)

    This is working well, except if the file already exists which does happen sometimes when we make edits. Is there an option on the MoveFile to overwrite? I couldn't see one.

    Thanks!
  9. Replies
    11
    Views
    639

    Re: Move Files (XP SP3)

    Found your solution in another post and added the Background:=False to the PrintOut. (I will look longer next time.)

    Thanks, Hans!
  10. Replies
    11
    Views
    639

    Re: Move Files (XP SP3)

    I got a permission denied error, probably because I am printing tthe documents first. Here is what I have:

    Dim sMyDir As String
    Dim sDocName As String
    ' The path to obtain the files.
    ...
  11. Replies
    11
    Views
    639

    Move Files (XP SP3)

    I need to move files from the C:AscendPrint folder to the C:AscendArchive folder as part of a Word macro. I found the FileSystemObject.MoveFile method, but I am not sure how to use it or if it is...
  12. Replies
    2
    Views
    367

    Re: 'My Documents' (2000-2003)

    Thank you again, Hans, worked like a charm!
  13. Replies
    2
    Views
    367

    'My Documents' (2000-2003)

    I need to save documents to different subfolders under the My Documents folder in a Word macro using ActiveDocument.SaveAs ...how do I reference the My Documents folder? This macro will run on...
  14. Replies
    2
    Views
    840

    Re: File Mask (XP Pro SP2)

    Thanks, Joe, I do use the Google desktop search. It was more for file management purposes I wanted the file mask native in Windows Explorer. There are lots of explorer replacements, etc. that do...
  15. Replies
    2
    Views
    840

    File Mask (XP Pro SP2)

    Is there one or is anyone ever going to write an explorer add-on that addes file mask (wildcard) capability to the address bar? (Probably not possible, but I can wish.) I did purchase a little...
  16. Replies
    2
    Views
    356

    Re: Insert File Menu (XP)

    Thank you, I knew there was a simple answer!
  17. Replies
    2
    Views
    356

    Insert File Menu (XP)

    I'm trying to write a macro which will display a list of files available for insertion from a specific directory, wait for the user to choose a file to insert, then change the directory back to the...
  18. Accessing Excel from Word (Office 2000-2003)

    My client uses Excel to distribute patient information to their transcriptionists who are transcribing medical records. Currently, the users highlight an Excel record, then press Ctrl-C (Copy) go...
  19. Replies
    5
    Views
    454

    Re: Filename Counter (Word 2003)

    Okay, figured it out, thank you! I used:

    Dim strFileName As String

    strFileName = Format(Now, "yyyyMMddHHmmss") & Application.UserInitials & ".doc"
    ActiveDocument.SaveAs (strFileName)
  20. Replies
    5
    Views
    454

    Re: Filename Counter (Word 2003)

    Thank you for the help. I did get the numerical, incrementing macro to work and set it as an AutoNew macro to automatically generate filenames.

    I would like to know how to use the date and time...
  21. Replies
    5
    Views
    454

    Re: Filename Counter (Word 2003)

    Thanks, it was a typo causing me problems. Yes, it is related to the other post, should I delete that one?

    I have one more question, how do I get the user initials into a variable? I tried:
    ...
  22. Replies
    5
    Views
    454

    Filename Counter (Word 2003)

    I found the following code I can use to create sequential filenames for documents automatically. How do I get the contents of the Order variable into the strFileName variable?

    Sub AutoNew()
    ...
  23. Replies
    1
    Views
    566

    Filename Generator (2003)

    Is there a utility for Word that automatically creates a filename for each document? It seems there should be an add-in for this somewhere. Ideally it would autumatically generate the directory...
  24. Replies
    2
    Views
    391

    Automatic Faxing (2003)

    Does anyone know of software that will watch a folder and automatically fax the Word documents in it? Of course, there would have to be some text or code in the Word documents to indicate who the...
Results 1 to 24 of 24