Replies

Hi Hans,

<>

Forget it, I goofed and it was my wrong doing.

Regarding the updating the field, I got it and will follow your suggestions

I appreciate your insights and helpfull assistance, Thanks!

-Tivoli0

Hi Hans,

Thanks for replying!

You’re right, the Document1 is Being created WITHOUT the saving.

I was able to get the prompt I was seeking. I entered in the filename.dot file the following code and have the first field in it to use the proc on entry:

Sub SaveAsNewFile()

Dim strDocName As String

strDocName = InputBox(“Please enter the name ” & _
“of your document.”)
ActiveDocument.SaveAs FileName:=strDocName

End Sub

So all is fine now, but I’m facing another issue now:

In the filename.dot file’s header I have specified to insert the filename. Although the filename.dot shows its true filename in the its header, the newly created *.doc document shows “Document1”.

How can I have the newly created document to show my assigned filename?

Thanks again, Hans, for your assistance!

-Tivoli0

Hi Anrew,

Thanks for the code!

Is there a way to attach a sample file to show what the code’s output looks like?

Thanks’ again.

-Tivoli0

hello Hans,

Yes, I know it’s a completely different task which I had tried to accomplish on my own.
It seems I got blacked out from the previous posts. . .

Anyway, your reply was on target and thanks to you, and the others who replied, I was able to accomplished what I set forth.

Thanks a million!

-Tivoli0

Hello Hans,

Thanks for your reply!

I tested it and it worked like a charm. I tried to modify it for a yet another task and had difficulties. I just coudn’t figre out which way to go. I guess I have to strugle with the code.

I attached a sample worksheet. If you can guide me it will be wonderful as this is the last step I need to overcome to finish a project.

THANK YOU!

-tivoli0

I am back…

Thanks for the replies!!!

I’ve been experimenting and trying all the ways to achieve what I was looking for.
It’s amazing what varieties exist.

In applying the different techniques and principles to further the experimentation,
all worked great – as long as I manipulated numbers. However, I had problems working with strings.

The attached worksheet demonstrate what I mean.

I am really thankful for your input and was able to learn from you and apply the acquired knowledge.
I hope you will be able to assist me and suggest a resolution to the attached problem.

Thank you!

Tivoli0

Hi Hans,

Thanks for your reply.
I didn’t know Excel hasn’t got a “built-in” mechanism tp password a sheet.
I’ve applied your suggestion and it works fine, “Fragile” is OK.

Thanks again! -Tivoli0

Hello Hans,

Thanks, again, for your prompt help! Works like a charm!

You know, I tried to use the countif() again before I had posted my request but I couldn’t figure out the “0”.
I tried =0 with and without the “” and it didn’t work. Syntax, syntax……

Have a great day! -Tivoli0

Hello Hans,

I see. I followed your instructions and got what I wanted.
Thanks much for your help!

-Tivoli0

Hi Hans,

My “Tasks” listing contains raws with the fields Subject, Company, Complete.
I view these raws via the View>Expand/Colapse Groups.
When I select from the menu File>print>Table Style, I only have options to print out to a printer.

I’ve installed pdf driver so I sometimes print the report to a pdf file.
However, my boss asked me if I can print it out to a text file or even better export to an Excel format file.

Hope I am understood and will be glad to receive any help. Thanks!

-Tivoli0

Hi Steve,

You’re right about that, I’ve noticed it.
However, luckily I didn’t have to care about that in this scenario.

Thanks for your input!

-Tivoli0

Rudi,

Thanks a million!!!

What a classic solution, you guys are the best!

-Tivoli0

Rudi,

You certainly started my new year with a great smile!
It worked, and it is simple. Thanks much!

-Tivoli0

Thanks, Hans, for the comment.

Happy New Year! -Tivoli0

OK, I found the solution.
Here is how I fixed it, If anyone experiencing the same:
I right clicked on the taskbar – while the small window is open – and chose “move”.
I rescaled the small window to fit the whole screen with the mouse.
Then, I exited the browser (“x” out).
When I logged back on and clicked a link, the 2nd window captured the whole screen.
-Tivoli0