MSFN Forum: Noob needs help vbs script change text in word .doc - MSFN Forum

Jump to content


  • 3 Pages +
  • 1
  • 2
  • 3
  • You cannot start a new topic
  • You cannot reply to this topic

Noob needs help vbs script change text in word .doc Rate Topic: -----

#21 User is offline   bphlpt 

  • MSFN Expert
  • PipPipPipPipPipPip
  • Group: Members
  • Posts: 1,077
  • Joined: 12-May 07

Posted 06 February 2013 - 10:58 PM

@oxb,

This might be a dumb question, but, if I understand this, since the "outer" folder (A, B, C, ...) seems to always be the first letter of the Client name, why is it necessary to have the user enter both steps? I mean if you just have the user enter the Client name such as "Ajax", then the script should be able to easily figure out that the .doc file copies and edits are going to to happen in the "A\Ajax" folder, right? Or is that not actually the case? Leaving in both steps allows more flexibility, but if what I surmised is really the case, then automating it will eliminate possible "misfiling" mistakes.

Cheers and Regards

This post has been edited by bphlpt: 07 February 2013 - 04:56 AM



#22 User is offline   oxb 

  • Newbie
  • Group: Members
  • Posts: 29
  • Joined: 20-February 05

Posted 07 February 2013 - 12:14 AM

Wow man amazing
looks professional now!
Im so pleased, wouldt have never come up with that kind of scripting,
Will take a look this evening gotta go work now.

Much kudo`s to you sir :thumbup

SUPER :D

#23 User is offline   bphlpt 

  • MSFN Expert
  • PipPipPipPipPipPip
  • Group: Members
  • Posts: 1,077
  • Joined: 12-May 07

Posted 07 February 2013 - 04:56 AM

@oxb,

Please see my question above. (It was directed to you.)

Cheers and Regards

#24 User is offline   jaclaz 

  • The Finder
  • Group: Developers
  • Posts: 11,433
  • Joined: 23-July 04
  • OS:none specified
  • Country: Country Flag

Posted 07 February 2013 - 08:01 AM

UNneeded, but JFYI:
@echo off
SETLOCAL ENABLEEXTENSIONS
CLS 
::PUSHD network Path to be filled in later
ECHO Geef alfabetische letter en druk op enter!

CHOICE /C:abcdefghijklmnopqrstuvwxyz /N >NUL
SET /A CharNum= %errorlevel% + 96
CMD /C EXIT /B %CharNum%
SET "Char=%=ExitCodeAscii%"
ECHO copy offerte.doc %Char% ^& copy factuur.vbs %Char% ^& cd %Char% ^& Set directory=%Char%


More details:
http://reboot.pro/to...eccmd/?p=136708

;)

jaclaz

This post has been edited by jaclaz: 07 February 2013 - 08:03 AM


#25 User is offline   oxb 

  • Newbie
  • Group: Members
  • Posts: 29
  • Joined: 20-February 05

Posted 07 February 2013 - 12:20 PM

Hi jaclaz
Sorry i didnt see youre post ,you are right it better to let the script find its way.
Didnt know that was possible, again big Noob at scripting.
But the script you provided is under dos, i like the vbs option better (look and feel)

Still youre input is highly appriciated and the script is going in my scripts folder for maybe later use.
Thank you for the effort and input.
Going to test the vbscript Gunsmokingman provided :hello:

Will check back later.
Thanx Guys

#26 User is offline   oxb 

  • Newbie
  • Group: Members
  • Posts: 29
  • Joined: 20-February 05

Posted 07 February 2013 - 01:01 PM

Gunsmokingman

I tried youre script and like it very much :thumbup
However there are 2 (for you ) small things

The offerte.doc needs to be in the same folder as factuur.vbs ex folder J >john doe >factuur.vbs+offerte.doc< wich needs to be renamed to> john doe.doc
The situation now is J>offerte.doc > john doe > factuur.vbs

The offerte.doc shouldt be renamed after the user input > john doe .doc

Also couldt you please edit script that after creation of john doe.doc it gets opened in word? :unsure:

I have been playing about with youre script (tried it myself) but i seem to mess up.

Again thanx for youre effort :thumbup

EDIT
Nevermind i tried and figured out myself how to do it.
Thanx for all your hard work Gunsmokeman
Thank you jaclaz

If you ever need new carpet ill hop on a plane and install that for you :w00t:

This post has been edited by oxb: 07 February 2013 - 02:38 PM


#27 User is offline   gunsmokingman 

  • MSFN Master
  • Group: Super Moderator
  • Posts: 2,352
  • Joined: 02-August 03
  • OS:none specified
  • Country: Country Flag

Posted 07 February 2013 - 05:32 PM

1:\ offerte.doc does this become User Input.doc, and it gets copy to User Letter \User Input Folder Name
along with the VBS script.

2:\ Open The User Name.doc from User Letter \User Input Folder Name


Here is the updated HTA, with changes to the copy, both files end up in the User Name
folder and the doc file is rename to the user input.

<!--
 February-06-13
 Hta And Script By Gunsmokingman Aka Jake1Eye
-->
 <TITLE>UserInput MkDir2</TITLE>
 <HTA:APPLICATION ID="InMkDir2" 
   SCROLL="No"		   
   SCROLLFLAT ="No"  
   SingleInstance="Yes"   
   ShowInTaskbar="No"		   
   SysMenu="No"		  
   MaximizeButton="No"		
   MinimizeButton="No"	
   Border="Thin" 
   BORDERSTYLE ="complex" 
   INNERBORDER ="No"  
   Caption="Yes"		  
   WindowState="Normal" 
   APPLICATIONNAME="InMkDir2"
   Icon="%SystemRoot%\explorer.exe">
<STYLE type="text/css">
  Body
   {
    Font-Size:9.25pt;
    Font-Weight:Bold;
    Font-Family:Segoe Ui, Arial,Tahoma,Comic Sans MS;
    Color:Black;
    BackGround-Color:#EFE9E3;
    Text-Align:Center;
    Vertical-Align:Top;
   }
  TD 
   {
    Font-Size:8.25pt;
    Font-Weight:Bold;
    Font-Family:Segoe Ui, Arial,Tahoma,Comic Sans MS;
    Color:Black;
   }
  .Tbx
   {
    Font-Size:8.25pt;
    Font-Weight:Bold;
    Font-Family:Segoe Ui, Arial,Tahoma,Comic Sans MS;
    Color:Black;
   }
  BUTTON
   { 
	  Height:15pt;  
	  width:60pt;
	  Cursor:Hand;
	  Font:8.05pt;
	  Font-weight:bold;
	  Font-Family:Segoe Ui, Arial,Tahoma,Comic Sans MS;
	  Color:#404040;
	  Text-Align:Center;
	  Vertical-Align:Middle;
	  filter:progid:DXImageTransform.Microsoft.Gradient
	  (StartColorStr='#E5E5E5',EndColorStr='#7D7D7D');
	  Margin:1;
	  Margin-Top:15pt;
	  Padding:2;
	  Border-Left: 1px Transparent;  
	  Border-Right: 2px Transparent;
	  Border-Top: 1px Transparent;   
	  Border-Bottom: 2px Transparent;
   }
 </STYLE>  
<script LANGUAGE='VBScript'>
'-> Resize And Place In Approx Center Of Screen
 Dim Wth, Hht :Wth = int(475) :Hht = int(225)
  window.ResizeTo Wth, Hht
  MoveTo ((Screen.Width / 2) - (Wth / 2)),((Screen.Height / 2) - (Hht / 2))
'-> Run Time Objects
 Dim Act :Set Act = CreateObject("Wscript.Shell")
 Dim Fso :Set Fso = CreateObject("Scripting.FileSystemObject")
'-> RunTime Varibles
 Dim F1, F2, F1a, F2a, Msg1, Tm1, UserDoc
  Msg1=". The Textboxes Have Been Disable, Contact The " & _
       "System Admin To Get The Missing Files"
  F1a="offerte.doc"
  F2a="factuur.vbs" 
  Function Window_OnLoad()
 '-> Check To Make Both Files Exists
   CheckFile(F1a)
   CheckFile(F2a)
   If F1 = True And F2 = True Then 
    Tx1.style.visibility = ""
    Tx1.style.color="#117711"
    Tx1.innerHTML = "Confirm " & F1a & " Confirm " & F2a
   ElseIf F1 = True And F2 = False Then 
    DisableTextBoxes()
    Tx1.innerHTML = "Confirm " & F1a & " Missing " & F2a & Msg1    
   ElseIf F1 = False And F2 = True Then    
    DisableTextBoxes()
    Tx1.innerHTML = "Missing " & F1a & " Confirm " & F2a & Msg1 
   ElseIf F1 = False And F2 = False Then
    DisableTextBoxes()
    Tx1.innerHTML = "Missing " & F1a & " Missing " & F2a & Msg1     
   End If
  End Function
'-> Checks For Files
  Function CheckFile(F)
   If Fso.FileExists(F) And F=F1a Then F1 = True
   If Fso.FileExists(F) And F=F2a Then F2 = True
  End Function
'-> If Any File Is Missing Disable The TextBox
  Function DisableTextBoxes()
    Tx1.style.visibility = ""
    Tx1.style.Bottom = 35
    Tx1.style.Left = 40
    Tx1.style.width = 375
    Tx1.Align="Left"
    Tx1.style.color="#980000"
    In1.disabled = True
    In2.disabled = True  
  End Function
'-> Process The Submit Button
  Function MySubmit()
  Tx1.style.color="#980000"
   If Len(In1.value) = 1 And Len(In2.value) >= 3 Then
    Tx1.style.color="#117711" :Tx1.style.Bottom = 35
    Tx1.innerHTML = "Confirm, Processing Information<BR>" & _
                    UCase(In1.value) & " " & In2.value 
    Display()                  
   ElseIf Len(In1.value) = 0 And Len(In2.value) = 0 Then    
    Tx1.innerHTML = "Error, Fill In Both Textboxes"
   ElseIf Len(In1.value) = 1 And Len(In2.value) = 0 Then
    Tx1.innerHTML = "Error, Fill In Full Name"
   ElseIf Len(In1.value) = 1 And Len(In2.value) <= 3 Then
    Tx1.innerHTML = "Error, Full Name Less Then 3 Characters"
   ElseIf Len(In1.value) = 0 And Len(In2.value) >= 3 Then
    Tx1.innerHTML = "Error, Single Letter Missing"
   End If
  End Function
'-> Process The Information
  Function ProcessMySubmit()
   If Fso.DriveExists("H:\") Then
'-> Make First Folder
    Dim P :P="H:\" & UCase(In1.value) 
    If Not Fso.FolderExists(P) Then Fso.CreateFolder(P)
'-> Make Second Folder
     P = P & "\" & In2.value  
    If Not Fso.FolderExists(P) Then Fso.CreateFolder(P)       
'-> Copy Rename offerte.doc And Get The Path And New Name
    Set F=Fso.GetFile(F1a)
    UserDoc = P & "\" & Replace(F1a,Left(F1a,7),In2.value)
     F.Copy P & "\" & Replace(F1a,Left(F1a,7),In2.value),True 
'-> Copy factuur.vbs
    Set F=Fso.GetFile(F2a)
     F.Copy P & "\" & F.Name,True 
   End If
   MsgDisplay()
  End Function  
'-> Time Dealy Then Close
  Function Display()
   Tm1=window.setTimeout("Process1()",2000,"VBScript") 
  End Function
  Function Process1()
    window.clearTimeout(Tm1)
    ProcessMySubmit()  
  End Function
'-> Time Dealy Then Close
  Function MsgDisplay()
   Tx1.style.color="#3377AD"
   Tx1.style.Bottom = 39
   Tx1.style.Left = 30
   Tx1.style.width = 395
   Tx1.innerHTML = "Process Completed, Preparing To Open : " & In2.value & ".doc"   
   Tm1=window.setTimeout("ProcessFinished()",3000,"VBScript") 
  End Function
  Function ProcessFinished()  
'-> Open User Input Doc 
    Act.Run(Chr(34) & UserDoc & Chr(34)),1,False
    window.clearTimeout(Tm1)
    window.close()
  End Function
</SCRIPT>
<BODY>
<!-- Folder Letter -->
 <TABLE Border='1'><TD Style='Width:385;Text-Align:Left;'>
   Please Type In A Single Letter From A-Z</TD><TD Style=''>
  <INPUT Type='TextBox' ID='In1' Class='Tbx' Size='1' MAXLENGTH='1'>
  </TD></TABLE>
<!-- User Name -->
 <TABLE Border='1'><TD Style='Width:325;Text-Align:Left;'>
  Type In Your Full Name</TD><TD Style=''>
  <INPUT Type='TextBox' ID='In2' Class='Tbx' Size='35' MAXLENGTH='128'>
  </TD></TABLE>
 <BUTTON ID='Bn1' OnClick='MySubmit()'>Submit</BUTTON>
 <BUTTON ID='Bn2' OnClick='window.close()'>Close</BUTTON>
<!-- For Positioning The Tx1 Div Small And Large Text
 <DIV Style='Width:275;'>Confirm offerte1.doc Confirm factuur.vbs.
 </DIV> 
 <DIV Style='Width:375;Margin-Top:22pt;Text-Align:Left;'>
 Missing offerte1.doc Confirm factuur.vbs. The 
 Textboxes Have Been Disable, Contact The System Admin To 
 Get The Missing Files</DIV>
  -->
 <DIV ID='Tx1' Style='visibility:hidden;Position:Absolute;
  Bottom:49;Left:90;Width:275;'></DIV>
</BODY>



#28 User is offline   oxb 

  • Newbie
  • Group: Members
  • Posts: 29
  • Joined: 20-February 05

Posted 08 February 2013 - 10:47 AM

This is what i came up with (copy paste) :lol:
Some text changed to my langauge
<!--
 February-05-13
 Hta And Script By Gunsmokingman Aka Jake1Eye
-->
 <TITLE>Maak Offerte</TITLE>
 <HTA:APPLICATION ID="InMkDir" 
   SCROLL="No"		   
   SCROLLFLAT ="No"  
   SingleInstance="Yes"   
   ShowInTaskbar="No"		   
   SysMenu="No"		  
   MaximizeButton="No"		
   MinimizeButton="No"	
   Border="Thin" 
   BORDERSTYLE ="complex" 
   INNERBORDER ="No"  
   Caption="Yes"		  
   WindowState="Normal" 
   APPLICATIONNAME="InMkDir"
   Icon="%SystemRoot%\explorer.exe">
<STYLE type="text/css">
  Body
   {
    Font-Size:9.25pt;
    Font-Weight:Bold;
    Font-Family:Segoe Ui, Arial,Tahoma,Comic Sans MS;
    Color:Black;
    BackGround-Color:#EFE9E3;
    Text-Align:Center;
    Vertical-Align:Top;
   }
  TD 
   {
    Font-Size:8.25pt;
    Font-Weight:Bold;
    Font-Family:Segoe Ui, Arial,Tahoma,Comic Sans MS;
    Color:Black;
   }
  .Tbx
   {
    Font-Size:8.25pt;
    Font-Weight:Bold;
    Font-Family:Segoe Ui, Arial,Tahoma,Comic Sans MS;
    Color:Black;
   }
  BUTTON
   { 
	  Height:15pt;  
	  width:60pt;
	  Cursor:Hand;
	  Font:8.05pt;
	  Font-weight:bold;
	  Font-Family:Segoe Ui, Arial,Tahoma,Comic Sans MS;
	  Color:#404040;
	  Text-Align:Center;
	  Vertical-Align:Middle;
	  filter:progid:DXImageTransform.Microsoft.Gradient
	  (StartColorStr='#E5E5E5',EndColorStr='#7D7D7D');
	  Margin:1;
	  Margin-Top:15pt;
	  Padding:2;
	  Border-Left: 1px Transparent;  
	  Border-Right: 2px Transparent;
	  Border-Top: 1px Transparent;   
	  Border-Bottom: 2px Transparent;
   }
 </STYLE>  
<script LANGUAGE='VBScript'>
'-> Resize And Place In Approx Center Of Screen
 Dim Wth, Hht :Wth = int(475) :Hht = int(225)
  window.ResizeTo Wth, Hht
  MoveTo ((Screen.Width / 2) - (Wth / 2)),((Screen.Height / 2) - (Hht / 2))
'-> Run Time Objects
 Dim Act :Set Act = CreateObject("Wscript.Shell")
 Dim Fso :Set Fso = CreateObject("Scripting.FileSystemObject")
'-> RunTime Varibles
 Dim F1, F2, F1a, F2a, Msg1, Tm1, Tm2
  Msg1=". FOUT " & _
       "VRAAG OSCAR HULP"
  F1a="offerte.doc"
  F2a="factuur.vbs" 
  Function Window_OnLoad()
 '-> Check To Make Both Files Exists
   CheckFile(F1a)
   CheckFile(F2a)
   If F1 = True And F2 = True Then 
    Tx1.style.visibility = ""
    Tx1.style.color="#117711"
    Tx1.innerHTML = "Confirm " & F1a & " Confirm " & F2a
   ElseIf F1 = True And F2 = False Then 
    DisableTextBoxes()
    Tx1.innerHTML = "Confirm " & F1a & " Missing " & F2a & Msg1    
   ElseIf F1 = False And F2 = True Then    
    DisableTextBoxes()
    Tx1.innerHTML = "Missing " & F1a & " Confirm " & F2a & Msg1 
   ElseIf F1 = False And F2 = False Then
    DisableTextBoxes()
    Tx1.innerHTML = "Missing " & F1a & " Missing " & F2a & Msg1     
   End If
  End Function
'-> Checks For Files
  Function CheckFile(F)
   If Fso.FileExists(F) And F=F1a Then F1 = True
   If Fso.FileExists(F) And F=F2a Then F2 = True
  End Function
'-> If Any File Is Missing Disable The TextBox
  Function DisableTextBoxes()
    Tx1.style.visibility = ""
    Tx1.style.Bottom = 35
    Tx1.style.Left = 40
    Tx1.style.width = 375
    Tx1.Align="Left"
    Tx1.style.color="#980000"
    In1.disabled = True
    In2.disabled = True  
  End Function
'-> Process The Submit Button
  Function MySubmit()
  Tx1.style.color="#980000"
   If Len(In1.value) = 1 And Len(In2.value) >= 3 Then
    Tx1.style.color="#117711" :Tx1.style.Bottom = 35
    Tx1.innerHTML = "Bevestigd, Bezig met Offerte<BR>" & _
                     " " & In2.value 
    Display()                  
   ElseIf Len(In1.value) = 0 And Len(In2.value) = 0 Then    
    Tx1.innerHTML = "Fout,Voer beide velden in!"
   ElseIf Len(In1.value) = 1 And Len(In2.value) = 0 Then
    Tx1.innerHTML = "Fout, Voer naam in!"
   ElseIf Len(In1.value) = 1 And Len(In2.value) <= 3 Then
    Tx1.innerHTML = "Fout, Naam minimaal 3 letters"
   ElseIf Len(In1.value) = 0 And Len(In2.value) >= 3 Then
    Tx1.innerHTML = "Fout, Voer alfabetische letter in!"
   End If
  End Function
'-> Process The Information
  Function ProcessMySubmit()
   If Fso.DriveExists("D:\") Then
'-> Make First Folder Then Copy offerte.doc
    Dim P :P="D:\" & LCase(In1.value) 
    If Not Fso.FolderExists(P) Then Fso.CreateFolder(P)
'-> Make Second Folder Then Copy factuur.vbs
     P = P & "\" & In2.value
    If Not Fso.FolderExists(P) Then Fso.CreateFolder(P)
    Set F=Fso.GetFile(F2a)
     F.Copy P & "\" & F.Name,True 
	Set F=Fso.Getfile(F1a)
	F.Copy P & "\" & In2.value & "_offerte.doc"
 Set oWord = CreateObject("Word.Application")   
   set oDoc = oWord.Documents.Open (P & "\" & In2.value & "_offerte.doc")
   oWord.Visible = true	
      End If
   MsgDisplay()
  End Function  
'-> Time Dealy Then Close
  Function Display()
   Tm1=window.setTimeout("Process1()",5000,"VBScript") 
  End Function
  Function Process1()
    window.clearTimeout(Tm1)
    ProcessMySubmit()  
  End Function
'-> Time Dealy Then Close
  Function MsgDisplay()
   Tx1.style.color="#3377AD"
   Tx1.style.Bottom = 39
   Tx1.innerHTML = "Offerte Klaar"
   Tm2=window.setTimeout("ProcessFinished()",2000,"VBScript")
    
  End Function
  Function ProcessFinished()
    window.clearTimeout(Tm2)
    window.close()
  End Function
</SCRIPT>
<BODY>
<!-- Folder Letter -->
 <TABLE Border='1'><TD Style='Width:385;Text-Align:Left;'>
Voer alfabetische letter in</TD><TD Style=''>
  <INPUT Type='TextBox' ID='In1' Class='Tbx' Size='1' MAXLENGTH='1'>
  </TD></TABLE>
<!-- User Name -->
 <TABLE Border='1'><TD Style='Width:325;Text-Align:Left;'>
  Naam klant</TD><TD Style=''>
  <INPUT Type='TextBox' ID='In2' Class='Tbx' Size='35' MAXLENGTH='128'>
  </TD></TABLE>
 <BUTTON ID='Bn1' OnClick='MySubmit()'>Start</BUTTON>
 <BUTTON ID='Bn2' OnClick='window.close()'>Sluiten</BUTTON>
<!-- For Positioning The Tx1 Div Small And Large Text
 <DIV Style='Width:275;'>Confirm offerte1.doc Confirm factuur.vbs.
 </DIV> 
 <DIV Style='Width:375;Margin-Top:22pt;Text-Align:Left;'>
 Missing offerte1.doc Confirm factuur.vbs. The 
 Textboxes Have Been Disable, Contact The System Admin To 
 Get The Missing Files</DIV>
  -->
 <DIV ID='Tx1' Style='visibility:hidden;Position:Absolute;
  Bottom:49;Left:90;Width:275;'></DIV>
</BODY>


Gunsmokingman added code tags

#29 User is offline   submix8c 

  • Inconceivable!
  • Group: Patrons
  • Posts: 3,244
  • Joined: 14-September 05
  • OS:none specified
  • Country: Country Flag

Posted 08 February 2013 - 11:39 AM

@oxb - when you want to post "code" use
some code here
to keep from disturbing the code. Note that you now have an "emoticon" (smiley face) in your code. The way to do above "code" is
[ code ]something[ /endcode ]
(remove the blanks inside brackets). ;)

edit - DOH!!! Was too quick with that (see jaclaz' below). Edited (remove strikethrough from it)...
Aaand - OK, just got too used to manually doing
"stuff"
(senselessly of course, seeing as how that little icon works...)

This post has been edited by submix8c: 08 February 2013 - 12:36 PM


#30 User is offline   jaclaz 

  • The Finder
  • Group: Developers
  • Posts: 11,433
  • Joined: 23-July 04
  • OS:none specified
  • Country: Country Flag

Posted 08 February 2013 - 12:05 PM

View Postsubmix8c, on 08 February 2013 - 11:39 AM, said:

The way to do above "code" is [ code ]something[ /endcode ] (remove the blanks inside brackets). ;)

Not really. :no:
It is [ code] and [ /code] (not [ /endcode]), and in practice you select what you want to insert in CODE tags, then click on the little icon senselessy representing "<>" which you find in "post" or "edit" mode.

jaclaz

This post has been edited by jaclaz: 08 February 2013 - 12:06 PM


#31 User is offline   gunsmokingman 

  • MSFN Master
  • Group: Super Moderator
  • Posts: 2,352
  • Joined: 02-August 03
  • OS:none specified
  • Country: Country Flag

Posted 08 February 2013 - 12:18 PM

Your code only adds the User Input
F.Copy P & "\" & In2.value & "_offerte.doc"



Where as I replace the offerte with the User Input
UserDoc = P & "\" & Replace(F1a,Left(F1a,7),In2.value)



Here is how I open the rename doc, the name and path can have as many
spaces in it name and it will open.
 
'-> Open User Input Doc     
 Act.Run(Chr(34) & UserDoc & Chr(34)),1,False


Good job at finishing the HTA your self

#32 User is offline   oxb 

  • Newbie
  • Group: Members
  • Posts: 29
  • Joined: 20-February 05

Posted 08 February 2013 - 01:48 PM

View Postgunsmokingman, on 08 February 2013 - 12:18 PM, said:

Your code only adds the User Input
F.Copy P & "\" & In2.value & "_offerte.doc"



Where as I replace the offerte with the User Input
UserDoc = P & "\" & Replace(F1a,Left(F1a,7),In2.value)



Here is how I open the rename doc, the name and path can have as many
spaces in it name and it will open.
 
'-> Open User Input Doc     
 Act.Run(Chr(34) & UserDoc & Chr(34)),1,False


Good job at finishing the HTA your self


Thanks for all the effort,
And thanks for the good job statement that means a lot coming from you.

Thanks to the others for the input i got a little wizer in scripting.

The thing is sometimes i want something automated and then i go all-in.
But it takes a long time before i have a new project, and by then i forgot most part of it.

If you see the amount of code used to do something this simple you get some more respect for coders and programmers.
We are all accustomed that the pc works when we turn it on, but really never stand stil by whats behind it all.

So respect to all of you :thumbup

Maybe we meet again on this forum if i got something else to play around with.

This post has been edited by oxb: 08 February 2013 - 01:49 PM


#33 User is offline   jaclaz 

  • The Finder
  • Group: Developers
  • Posts: 11,433
  • Joined: 23-July 04
  • OS:none specified
  • Country: Country Flag

Posted 08 February 2013 - 02:16 PM

View Postoxb, on 08 February 2013 - 01:48 PM, said:

If you see the amount of code used to do something this simple you get some more respect for coders and programmers.
We are all accustomed that the pc works when we turn it on, but really never stand stil by whats behind it all.


That is the initial steep of the curve, after you will get the hang of it you will probably start wondering how come that some (not necessarily all :)) programmers have this quirk for selling you trifling things as if they were the only geniuses on earth capable of doing that :ph34r: .

Seriously, I have seen guys putting together half @§§ed MS Access "custom databases" (actually no more that a few forms and reports) talking as if they were Linus Torvalds or Sergey Brin :w00t:

jaclaz

#34 User is offline   gunsmokingman 

  • MSFN Master
  • Group: Super Moderator
  • Posts: 2,352
  • Joined: 02-August 03
  • OS:none specified
  • Country: Country Flag

Posted 08 February 2013 - 02:33 PM

jaclaz have you learned how to read VBS script yet. Myself I can write in mutilple langauges, cmd, html, hta, vbs, Jscript, Vb.net
and you? All self taught , unless you really want to count one semester of programmming in around 1983 when I went to college.

#35 User is offline   oxb 

  • Newbie
  • Group: Members
  • Posts: 29
  • Joined: 20-February 05

Posted 08 February 2013 - 02:34 PM

View Postjaclaz, on 08 February 2013 - 02:16 PM, said:

View Postoxb, on 08 February 2013 - 01:48 PM, said:

If you see the amount of code used to do something this simple you get some more respect for coders and programmers.
We are all accustomed that the pc works when we turn it on, but really never stand stil by whats behind it all.


That is the initial steep of the curve, after you will get the hang of it you will probably start wondering how come that some (not necessarily all :)) programmers have this quirk for selling you trifling things as if they were the only geniuses on earth capable of doing that :ph34r: .

Seriously, I have seen guys putting together half @§§ed MS Access "custom databases" (actually no more that a few forms and reports) talking as if they were Linus Torvalds or Sergey Brin :w00t:

jaclaz


LoL Yeah i know what you mean, i am quite good as to setting up a network enviroment as a hobby.
Sometimes i have some it guy come over and i have to make corrections to his s***.
My brother in law wanted a vpn connection to his office, the reply was: not possible! you need new computers
i spend some time on it and got it to work.
Just tried to rip him off :realmad:

:hello:
I

#36 User is offline   jaclaz 

  • The Finder
  • Group: Developers
  • Posts: 11,433
  • Joined: 23-July 04
  • OS:none specified
  • Country: Country Flag

Posted 09 February 2013 - 05:45 AM

View Postgunsmokingman, on 08 February 2013 - 02:33 PM, said:

jaclaz have you learned how to read VBS script yet. Myself I can write in mutilple langauges, cmd, html, hta, vbs, Jscript, Vb.net
and you? All self taught , unless you really want to count one semester of programmming in around 1983 when I went to college.

Sure, reading is easy :).
Writing is another thing.

However you would be surprised by the little thingies that this old dinosaur wrote in VBA (for Excel) ;).

jaclaz

#37 User is offline   oxb 

  • Newbie
  • Group: Members
  • Posts: 29
  • Joined: 20-February 05

Posted 09 February 2013 - 10:47 AM

Damnit Got a problem

Today i tried to run the script on the NAS but i believe the path is not correct.
On the pc there is a network connection to the drive (Z:)
In the script i tried to put in the networkdriveletter Z:
The script runs and gives error not finding document, the folder is not created and there are no files copied.
Do i have to fill in something like %networkdrive% or %networkpath% in line 137/139

So dissapointed here at home everything worked fine even got the script to take user input to fill in the adress in the document.
I
Any ideas?

Thanx

EDIT
Nevermind got it fixed stupid was running the hta locally not from nas drive :blushing:

This post has been edited by oxb: 09 February 2013 - 11:14 AM


#38 User is offline   oxb 

  • Newbie
  • Group: Members
  • Posts: 29
  • Joined: 20-February 05

Posted 09 February 2013 - 11:34 AM

Still one more question :lol:

How can i make this script look for the .doc file and automaticly use that .doc?
This vbs wil be in the same folder as the userinput,doc
The userinput.doc name will change every time so i would like to use a wildcard like in dos *.doc but dont know how to do it in vbs.
Note that there wil be only one .doc file in the same directory as this vbs script. it wil always be named like this userinput_offerte.doc.
I wouldt like to take out the userinput just click and go.

currentDirectory = left(WScript.ScriptFullName,(Len(WScript.ScriptFullName))-(len(WScript.ScriptName)))
input = Inputbox("Geef naam, bijv: De Groot")
dim fso
Set FSO = CreateObject("Scripting.FileSystemObject")
Fso.Copyfile input & "_offerte.doc" , input & "_factuur.doc"
   Const wdReplaceAll = 2
Set oWord = CreateObject("Word.Application")
oWord.Visible =True
set oDoc = oWord.Documents.Open (currentdirectory & input & "_factuur.doc") 
With oWord.Selection
    .Find.Text = "Offerte:"
    .Find.Replacement.Text = "factuur:"
    .Find.Forward = True
    .Find.MatchWholeWord = True
    .Find.Execute ,,,,,,,,,,wdReplaceAll
	.Find.Text = "Na eventuele accordatie stellen wij betaling per pin op prijs."
    .Find.Replacement.Text = "Wij danken u voor uw opdracht, graag betaling via PIN"
    .Find.Forward = True
    .Find.MatchWholeWord = True
    .Find.Execute ,,,,,,,,,,wdReplaceAll
	
End With
oDoc.Save 


Set objFSO = CreateObject("Scripting.FileSystemObject")



strScript = Wscript.ScriptFullName
objFSO.DeleteFile(strScript) 

This post has been edited by oxb: 09 February 2013 - 11:45 AM


#39 User is offline   gunsmokingman 

  • MSFN Master
  • Group: Super Moderator
  • Posts: 2,352
  • Joined: 02-August 03
  • OS:none specified
  • Country: Country Flag

Posted 09 February 2013 - 12:34 PM

Here this will sort out the doc type , you will have to work out where to place it in your script.
Dim Fso :Set Fso = CreateObject("Scripting.FileSystemObject")
Dim Obj

  For Each Obj In Fso.GetFolder(".").Files 
   If LCase(Right(Obj.Name,3)) = "doc" Then
    WScript.Echo Obj.Name
   End If
  Next 



#40 User is offline   oxb 

  • Newbie
  • Group: Members
  • Posts: 29
  • Joined: 20-February 05

Posted 09 February 2013 - 12:40 PM

View Postgunsmokingman, on 09 February 2013 - 12:34 PM, said:

Here this will sort out the doc type , you will have to work out where to place it in your script.
Dim Fso :Set Fso = CreateObject("Scripting.FileSystemObject")
Dim Obj

  For Each Obj In Fso.GetFolder(".").Files 
   If LCase(Right(Obj.Name,3)) = "doc" Then
    WScript.Echo Obj.Name
   End If
  Next 




Going to try this one out thanx yet again :thumbup

Share this topic:


  • 3 Pages +
  • 1
  • 2
  • 3
  • You cannot start a new topic
  • You cannot reply to this topic

2 User(s) are reading this topic
0 members, 2 guests, 0 anonymous users



All trademarks mentioned on this page are the property of their respective owners
Copyright © 2001 - 2013 msfn.org
Privacy Policy