Search found 26 matches

by tech_soul8
Mon Apr 23, 2012 8:24 pm
Forum: VBScript
Topic: Call subfolder from variable
Replies: 13
Views: 7287

Call subfolder from variable

Hello! This is the code: Dim oFSO, folder, folder2, coll folder = "Test" folder2 = "Test1" Set oFSO = CreateObject("Scripting.FilesystemObject") oFSO.CreateFolder ("C:Documents and SettingsAdministratorDesktop" &folder) Set path = oFSO.GetFolder ("C:Documents and SettingsAdministratorDesktop" & fold...
by tech_soul8
Fri Apr 20, 2012 12:49 am
Forum: VBScript
Topic: How to Close open documents?
Replies: 3
Views: 2754

How to Close open documents?

I figured it out :)) I created new variable and set reference to xl :) like this:

Set xy = xl.workbooks

and now I can access to methods,properties...just like I created new object with CreateObject function and I can save documents before exiting appliaction.

Book question is still opened :)
by tech_soul8
Thu Apr 19, 2012 10:56 pm
Forum: VBScript
Topic: How to Close open documents?
Replies: 3
Views: 2754

How to Close open documents?

Hello! I wrote this script: Dim oExcel, Workbook, File, oFSO Set ofso = CreateObject ("Scripting.FileSystemObject") Set file = oFSO.GetFile ("C:Documents and SettingsAdministratorDesktopBook1.xlsx") Set oExcel = CreateObject ("Excel.Application") oExcel.Visible = True Set Workbook = oExcel.Workbooks...
by tech_soul8
Thu Apr 19, 2012 10:56 pm
Forum: VBScript
Topic: How to Close open documents?
Replies: 3
Views: 2754

How to Close open documents?

Hello! I wrote this script: Dim oExcel, Workbook, File, oFSO Set ofso = CreateObject ("Scripting.FileSystemObject") Set file = oFSO.GetFile ("C:Documents and SettingsAdministratorDesktopBook1.xlsx") Set oExcel = CreateObject ("Excel.Application") oExcel.Visible = True Set Workbook = oExcel.Workbooks...
by tech_soul8
Sun Apr 15, 2012 6:09 am
Forum: VBScript
Topic: Stop statement???
Replies: 4
Views: 4655

Stop statement???

You are wright! The code bellow works and I like it more than if, elsif,else...statatement. Select Case strMjesec Case 4: iKraj = 30 Case 5: iKraj = 31 Case 6: iKraj = 30 Case 7: iKraj = 31 Case 8: iKraj = 31 Case 9: iKraj = 30 Case 10: iKraj = 31 Case 11: iKraj = 30 Case 12: iKraj = 31 End Select T...
by tech_soul8
Sat Apr 14, 2012 11:26 pm
Forum: VBScript
Topic: Stop statement???
Replies: 4
Views: 4655

Stop statement???

Hello folks, again :)How can I stop script from executing further code after STOP statement?For example I have wrote this code:Dim oFSO, iStart, iKraj, strMjesec, strProvjera, strPrethodniMjesec, objFolderstrMjesec = Month (Now) 'Dohavti tekuci mjeseciStart = 1 'Pocetna vrijednost brojacastrPrethodn...
by tech_soul8
Thu Apr 12, 2012 11:07 am
Forum: VBScript
Topic: Finding objects documentation!
Replies: 2
Views: 2025

Finding objects documentation!

Well what I needed I done it already. I wanted to write script which will create new .xls document every day on my desktop with current day and month as a name. Then I run on to Excel object and I was wondering where could I get complete list of objects, metods, properties... for Excel object just t...
by tech_soul8
Thu Apr 12, 2012 6:46 am
Forum: VBScript
Topic: Finding objects documentation!
Replies: 2
Views: 2025

Finding objects documentation!

Ok tkanks jvierra :)
by tech_soul8
Thu Apr 12, 2012 5:28 am
Forum: VBScript
Topic: Finding objects documentation!
Replies: 2
Views: 2025

Finding objects documentation!

Hello! Where for example I can found how to access Excel object and all of it's properties, metods... I tryed on msdn but without success. Is there any documentation you can download for Office application like you can for Vbscript?? Is there any list of all objects you can work with and all of it's...
by tech_soul8
Thu Apr 05, 2012 9:05 am
Forum: VBScript
Topic: Run logon script with different user credentials
Replies: 10
Views: 10785

Run logon script with different user credentials

I've read carefully all yor posts and links you gave me and finally it works :) Actually the problem was in virtualbox net adapters configuration. There was no clients on the other side of a router becouse virtualbox was actually acting like a swtich so every time client requested an ip address from...