|
My Word macro has grown HUGE, so I want to convert it to some C or C++ console application, or whathever, so that It can run i Background.
Is possible to make an exe out of a Macro, convert the VBA and make and compile it, etc.
This macro simply makes some standard modifies to a TEXT file.
The problem is that the Macro language i think VBA, has some advanced funcions to move the cursor in the text.
Like Selection.
.MoveDown Unit:=wdLine, Count:=1, Extend:=wdExtend
.HomeKey
.TypeText Text:=hello
.TypeParagraph
.TypeBackspace
.Delete Unit:=wdCharacter, Count:=3
"Nelle cose del mondo non e' il sapere ma il volere che puo'."
|
|
|
|
|
Ofcourse, you can cut and paste the code in a VB module and compilet it. Of course you may need to add the appropriate reference and also make some small corrections.
|
|
|
|
|
I dont know much about VB.
My code is something like:
Selection.MoveUp Unit:=wdLine, Count:=1
Selection.HomeKey Unit:=wdLine
Selection.MoveRight Unit:=wdCharacter, Count:=87
Selection.Delete Unit:=wdCharacter, Count:=6
Selection.PasteAndFormat (wdPasteDefault)
Selection.TypeBackspace
Selection.TypeBackspace
Selection.TypeBackspace
Selection.MoveLeft Unit:=wdWord, Count:=1
Selection.TypeBackspace
Selection.MoveRight Unit:=wdWord, Count:=8
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.PasteAndFormat (wdPasteDefault)
Selection.MoveLeft Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.MoveLeft Unit:=wdCharacter, Count:=2
Selection.MoveLeft Unit:=wdWord, Count:=2, Extend:=wdExtend
Selection.TypeText Text:="="
And I copied it into the sub main of module one in a new Visual Basic Console application.
But everithing don't work.
Selection wdCharacter,wdExtend, wdLine, is undeclared, etc etc etc
HELP PLEASE!
"Nelle cose del mondo non e' il sapere ma il volere che puo'."
|
|
|
|
|
Selection seems to be a Word Library Object.
Should I import the Word Library to my project for make my code working again?
"Nelle cose del mondo non e' il sapere ma il volere che puo'."
|
|
|
|
|
Define Global objects like this
Dim Selection as Word.Selection
Dim WordApplication as New Word.Application
Sub Form_Load
set Selection = WordApplication.Selection
End Sub
|
|
|
|
|
Rama Krishna wrote:
Dim Selection as Word.Selection
Dim WordApplication as New Word.Application
It looks like "TYPE WORD NOT DEFINED" ????
"Nelle cose del mondo non e' il sapere ma il volere che puo'."
|
|
|
|
|
I am getting a permission denied error when copying text from inside a temp text file to a file already set up in another folder. The problem only occurs when I am reading a group of files and the last file is the one that fails.
|
|
|
|
|
Two things:
1. Are you closing the file after you are done with each one?
2. Have you checked the file permissions to see that you have access to it?
Nick Parker
|
|
|
|
|
Cuold you be more specific , exactly what is the scenario ?;P
|
|
|
|
|
Dose anyone know how to use the SVGControl.dll in VB6 to view .pdf files. Where can I find any code examples
Thanks
|
|
|
|
|
I found the answer to this one on my own thanks. The SVGControl is for viewing SGV files only. When you try to view a .pdf file no error message is given, only nothing shows on the screen.
|
|
|
|
|
Does VBScript support COMs with events?
rechi
|
|
|
|
|
yes, with a qualifier
vbscript depends on the script host to handle the events.
each script host may expose it differently.
examples of a script host are IE, Windows Scripting Host, and ASP 3.0.
|
|
|
|
|
|
You cannot put an actual radio button on the menu, but you can add the functionality so that the choice between 3 or 4 items will only allow you to select one of them like a radio button.
Build a man a fire, and he will be warm for a day Light a man on fire, and he will be warm for the rest of his life!
|
|
|
|
|
|
Hi!
I would like to know if there is a way to
1) center your message in a message box
2) move down a line in the box
(have part of the message on the first line, and a second part on the next)
Thanks, any help would be breatly appreciated!
Erin
|
|
|
|
|
In your string add CHR$(13) where you want the line to break.
"line 1"+CHR$(13)+"line 2"
There may be a newer syntax these days.
As for centering, do you want each line centered or the overall
message. If it is just the message, I believe centering is
automatic. Don't know how to center each line.
|
|
|
|
|
Anonymous wrote:
There may be a newer syntax these days.
"Line 1" & vbCrLf & "line 2"
|
|
|
|
|
1) I do not believe that there are any settings to center the text in your message box.
2) You can add a newline character to your message to make the message skip to the next line. The newline is the chr(10) command. You can also add chr(9) in order to do a tab sequence.
Build a man a fire, and he will be warm for a day Light a man on fire, and he will be warm for the rest of his life!
|
|
|
|
|
kilowatt wrote:
The newline is the chr(10) command
10 is line feed. I'd suggest a combination of 13 [carriage return] and 10 [line feed]
Nish
Regards,
Nish
Native CPian.
Born and brought up on CP.
With the CP blood in him.
|
|
|
|
|
you've all been a great help! (i'm programming monopoly - insane amounts of code! :P) (for school)
|
|
|
|
|
Just for your information, the message box and other window controls that display text ignore the carraige return, and since you need to type this in VB to get a carraige return:
& chr(13) &
I suggest to not use it at all.
You do need a carraige return when you are dealing with files though.
Build a man a fire, and he will be warm for a day Light a man on fire, and he will be warm for the rest of his life!
|
|
|
|
|
In the properties window under justification click center
|
|
|
|
|
Anonymous wrote:
In the properties window under justification click center
The MsgBox doesn't contain properties like you are talking about.
Nick Parker
|
|
|
|