Search results for query: *

Problemo Solvedo! Guys, you were right all along. It is because of an illegal character. I stepped through the procedure and after this step: NewFileName = ActiveDocument.Shapes("Text Box 2").TextFrame.TextRange.Text I hovered the mouse cursor over NewFileName and noticed a little square...

Hi mintjulep, If I type in a string literal for the "FileName"-argumanet of the SaveAs method, it does save, even though the document is open.

I also posted this question here: http://www.vbaexpress.com/forum/showthread.php?p=164420#post164420 http://www.xtremevbtalk.com/showthread.php?t=301722

Dim myYear As Integer For myYear = 2001 To 2008 Step 1 Sheets(CStr(myYear)).Select ' Other code goes here Next myYear

Hallo Guys, In Word, I want to take the text in a textbox in the active document and use it as the filename for the active document by using the SaveAs method. Here is the code: Sub Rename_ActiveDocument() Dim NewFileName As String NewFileName = ActiveDocument.Shapes("Text Box...

Hallo Guys, In Excel 2007, I have made a custom spreadsheet function. When I start typing the function in a cell on a sheet, a list of functions that start with the same letters appears and then I can select my custom function from the list. This makes entering the function much faster...