Search found 13 matches

by yadhukrishna36
Wed Jan 27, 2021 12:09 pm
Forum: Beginners
Topic: Processing multiple files in a directory
Replies: 7
Views: 18906

Re: Processing multiple files in a directory

Thanks all.................. :D :)
by yadhukrishna36
Fri Jan 22, 2021 7:19 am
Forum: Technical / Scripting
Topic: How to set excel cell font bold
Replies: 2
Views: 1555

How to set excel cell font bold

Hi I want to set the font of a specific cell range in the excel sheet to BOLD I tried VBStart Sub setExcelCellBold(vbFilePath) Set objExcel=CreateObject("Excel.Application") objExcel.Visible = false Set objWorkbook = objExcel.Workbooks.Open(vbFilePath) Set objRange = objExcel.Range("CB3","CD3") objR...
by yadhukrishna36
Wed Jan 06, 2021 11:27 am
Forum: Technical / Scripting
Topic: How to remove macro scheduler logo and name in input dialogue box
Replies: 6
Views: 3688

How to remove macro scheduler logo and name in input dialogue box

Hi I'm using the following code,

Code: Select all

Let>INPUT_BROWSE=1
Let>INPUT_BROWSE_FILTER=Excel files (*.xlsx)|*.XLSX
Input>filePath,Please select the input excel file,%defaultFilePath%
I need to remove the macro scheduler's logo and name from the top of input dialogue box
by yadhukrishna36
Tue Jan 05, 2021 4:29 pm
Forum: Technical / Scripting
Topic: Get the parent directory path of the exe file
Replies: 3
Views: 2607

Get the parent directory path of the exe file

I need to get the directory path of the .exe file ( created using Ctrl+F9 ) in my script to get additional files. I keep some config files inside the directory of .exe itself and I need to get those without hardcoding the path. Suppose a user runs my .exe from C:\Users\<userName>\Documents\<appName>...
by yadhukrishna36
Tue Dec 29, 2020 12:31 pm
Forum: Technical / Scripting
Topic: How to read xml data from a url and parse it ?
Replies: 3
Views: 2164

How to read xml data from a url and parse it ?

I need to get the currency exchange rates from a URL http://www.ecb.europa.eu/stats/eurofxre ... -daily.xml which gives an XML response, I tried with httpRequest but did not work as expected. Can somebody help me?
by yadhukrishna36
Sun Dec 20, 2020 3:46 pm
Forum: Scripts and Tips
Topic: Convert time serial number of excel to time
Replies: 4
Views: 12953

Re: Convert time serial number of excel to time

Actually excel cell is formatted in time and it shows 5:07:00 AM. I'm getting the time serial number when I try to get the value using.. XLGetCell>xlBook,sheet,10,9,time Also tried, XLSetRangeFormat>xlBook,Sheet1,I10:I10,[$-en-US]h:mm:ss AM/PM;@ // Time is in cell I10 XLGetCell>xlBook,sheet,10,9,tim...
by yadhukrishna36
Sun Dec 20, 2020 1:49 pm
Forum: Scripts and Tips
Topic: Convert time serial number of excel to time
Replies: 4
Views: 12953

Convert time serial number of excel to time

I need to get time from time serial number of excel. like time serial number for 1:00:00 AM is 0.0416666666666667 in excel and 5:07:00 AM is 0.213194444444444 I need to get them as 1:00:00 AM and 5:07:00 AM The excel cell is formatted in time and it shows 5:07:00 AM. I'm getting the time serial numb...
by yadhukrishna36
Wed Oct 07, 2020 11:11 am
Forum: Technical / Scripting
Topic: Getting values from "VSFlexGrid8L"
Replies: 3
Views: 5092

Re: Getting values from "VSFlexGrid8L"

Dorian (MJT support) wrote:
Tue Oct 06, 2020 7:28 pm
If it's an application I suggest trying the Find Object Wizard on it.
I have WIN_USEHANDLE for that grid I need to know how to read values from VSFlexGrid8L, get index (row count) of a given text in that etc.
by yadhukrishna36
Tue Oct 06, 2020 6:40 pm
Forum: Technical / Scripting
Topic: Getting values from "VSFlexGrid8L"
Replies: 3
Views: 5092

Getting values from "VSFlexGrid8L"

Hi, I'm trying to automate a window application, in which I need to select an item from a flex grid (class name = "VSFlexGrid8L" ), The window has no title so I'm taking objects by selecting objects by pressing tabs and getting objects using "GetFocusedObject" (like GetFocusedObject>focdList). Now i...
Sign up to our newsletter for free automation tips, tricks & discounts