Macro Scheduler Forums

yadhukrishna36

Thanks all..................

yadhukrishna36

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...

yadhukrishna36

Thanks, JRL

yadhukrishna36

ok thanks Dorian

yadhukrishna36

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

yadhukrishna36

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>...

yadhukrishna36

Thanks Marcus Tettmar

yadhukrishna36

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?

yadhukrishna36

Thanks Dorian

yadhukrishna36

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...

yadhukrishna36

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...

yadhukrishna36

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.

yadhukrishna36

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...

Search found 13 matches

Re: Processing multiple files in a directory

How to set excel cell font bold

Re: Get the parent directory path of the exe file

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

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

Get the parent directory path of the exe file

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

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

Re: Convert time serial number of excel to time

Re: Convert time serial number of excel to time

Convert time serial number of excel to time

Re: Getting values from "VSFlexGrid8L"

Getting values from "VSFlexGrid8L"