Click here to Skip to main content

Submit your article

Automation

automation

Great Reads

Never Buy A Garage Door Remote Again: Open Your Door With Your Android Phone (via Bluetooth)

by raddevus

Steps for building a device you can add to your existing garage door, which implements an atmega328, bluetooth (hc-05) and relay module which will allow you to open your garage door from any paired Android device.

5 More Attributes of Highly Effective Programmers

by Ben M Watson

Five more attributes of highly effective programmers

Hacking Alexa's Voice Recordings

by Michael Haephrati

Now you can store your own voice recordings kept by Amazon but not made available to customers

Using C# .NET User Defined Functions (UDF) in Excel

by Adam Tibi

Exposing .NET functions to be consumed as Excel functions, otherwise known in Excel as "User Defined Functions" . Those .NET exposed functions can be easily used from Excel's cells. This article presents two ways to achieve this and the pros and cons of each.

Latest Articles

Azure Automation Runbooks in 2024

by Wessel Beulink

Azure spearheads cloud evolution, Azure Automation Runbooks manage hybrid/SOC environments effectively

Running Automation Tests At Scale Using Playwright

by Suhagkumar Vamja

In this article, we learn about Playwright, how it works, and why it is a good choice for web automation with Java.

Running Automation Tests at Scale Using Cypress

by Suhagkumar Vamja

In this article, we will learn how to set up Cypress and run the web automation tests (in series and parallel) on the LambdaTest cloud grid.

IoT Device for Predicting and Identifying Problems in a Datacenter

by André Marcos (Advisor), Luciano Santos de Jesus

Automation with Arduino Prototype for an Alarm Device based on Audiometric Sounds Pattern Control

All Articles

Automation

Never Buy A Garage Door Remote Again: Open Your Door With Your Android Phone (via Bluetooth)

27 Jul 2016 by raddevus

Steps for building a device you can add to your existing garage door, which implements an atmega328, bluetooth (hc-05) and relay module which will allow you to open your garage door from any paired Android device.

5 More Attributes of Highly Effective Programmers

15 Sep 2014 by Ben M Watson

Five more attributes of highly effective programmers

Hacking Alexa's Voice Recordings

7 Nov 2019 by Michael Haephrati

Now you can store your own voice recordings kept by Amazon but not made available to customers

Using C# .NET User Defined Functions (UDF) in Excel

13 Jun 2013 by Adam Tibi

Exposing .NET functions to be consumed as Excel functions, otherwise known in Excel as "User Defined Functions" . Those .NET exposed functions can be easily used from Excel's cells. This article presents two ways to achieve this and the pros and cons of each.

Word Automation using C#: Create a Word Table Programatically

13 Sep 2014 by koolprasad2003

This tip gives you an idea about how to create Word table using C# (Word automation)

Automating the SQL Database Mirroring Setup

30 Dec 2019 by Dathuraj Pasarge

Database mirroring setup without any DBA effort - on every new database creation

trying to add a excel worksheet

9 Jul 2012 by Volynsky Alex

Try to use something: Excel::_ApplicationPtr XL; .... Excel::_WorkbookPtr workbook = XL->Workbooks->Add(Excel::xlWorksheet); Excel::_WorksheetPtr worksheet = XL->ActiveSheet; worksheet->Name = "last page"; worksheet = XL->Worksheets->Add(); // adding...

Selenium Series Part 4: Killing Laying Around Browser Processes for More Consistent Selenium Testing

25 Jun 2018 by Sean Rand

This is an article to help you clean up browser processes during automated Selenium testing.

How to Install Let's Encrypt and Automate Renewal in Nginx

23 Jan 2018 by James Johnes

Do you want to secure your nginx server? Do you want to prevent Google Chrome from name shaming your non-SSL domain? Well, here a perfect yet easy to follow guide to help you.

Scheduling the Jenkins Job with CRON

6 May 2018 by Iqra Ali

CRON jobs and configuring Jenkins jobs using different CRON options

trying to add a excel worksheet

9 Jul 2012 by enhzflep

Rather than indexes into the Sheets collection, you need to supply the function valid worksheet objects.Firing up a new instance of excel and recording 2 macros, we get the following code:1. Sheet added between Sheet2 & Sheet3 (right-click sheet 3, add new worksheet) ...

How do you auto select words in a richtextbox?

2 Nov 2012 by fjdiewornncalwe

A really quick google search turned up this article: Search and Highlight Text in RichTextBox[^]. Maybe you can get a starting point from here.

How to take automatic backup daily?

27 Nov 2014 by OriginalGriff

Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...A very quick search using a chunk of your question as the search term gave nearly 3/4 of a million hits: Google "automatic backup of SQL database"[^]The top "non-ad"...

The Six Hat Send Mail Class (Easily Send Email Using VBA)

2 Jul 2016 by Six Hat Solutions

Easily Send Emails From Your Microsoft Applications Using VBA and the SendGrid API

Posting Externally Derived TFS Test Case Results

28 Jul 2017 by ergohack

This is an article on how to post automated test results to Microsoft's Test Manager Infrastructure from external sources (e.g. your home grown automated test harness).

Send Keys to background

18 Jan 2012 by Fapsterx

I am trying to send keys to a background application and I cannot seem to get it to work :(I can make my application send keys to another application, by making my application bring the other application to the front, but I can't seem to make is send it to a non active window. Could anyone...

Send Keys to background

19 Jan 2012 by johannesnestler

Hi Fapsterx,This should give you an idea. Your problem is: most times you can not send an input to the main window of an application. Most applications use some kind of child-window for editing (a TextBox, whatever).So you can only send input messages to those. But how to find them?...

Bookmarks problems - automating Microsoft Word with C#

2 Apr 2012 by OriginalGriff

I think perhaps you have mixed code from two sites: Word._Document.SaveAs takes 16 parameters: MSDN[^] (and so does the Word.Document.SaveAs which is the one I would expect to use).Go back to the site you got the code from, and look more closely - I think you have missed something! If...

How to download photos from facebook in own PC in windows Application

17 Oct 2012 by ridoy

Try Google first on your topic..Here are...

Server side mp3 to ogg process

26 Mar 2013 by Sergey Alexandrovich Kryukov

Both formats, and a lot more, are supported by FFmpeg or libavcodec, which are the best libraries I know. Please see:http://en.wikipedia.org/wiki/Ffmpeg[^],http://ffmpeg.org/[^],http://en.wikipedia.org/wiki/Libavcodec[^],http://libav.org/[^].You can use them on the server-side either...

Excel automation or ADO.NET for handling with excel files?

8 Apr 2013 by Zoltán Zörgő

It depends on what you need. But here is a really minimalistic comparison:- ADO will treat an Excel file as data source (no formatting available), but it is not resource saving- with interop you get full control, but you will have running Excel instances in the background, thus it is...

Update a Windows Forms Application

19 Nov 2013 by johannesnestler

How about ClickOnce: http://msdn.microsoft.com/en-us/library/vstudio/t71a733d.aspx[^]The easiest free solution I know - easy for you to setup and configure, easy for the users. Though I used it only in enterprise environments to deploy application inside of the company. So I just had to...

How to automatic select a opened window?

29 Sep 2014 by Sergey Alexandrovich Kryukov

André Name wrote:Ok, it's a Windows Form. I'm like new in C# but I know a bit about it already, I don't say that I am a pro in it now, but I know how some things to get to work already. You also started with no knowledge with C#, so me too now, that's why I can't know everything about it. But...

Using Template Bookmarks for Automating Microsoft Word Reports

31 May 2018 by Darryl Bryk

A C# method is discussed for using bookmarks in Microsoft Word templates to automate reports.

Login VPN through Cisco AnyConnect Secure Mobility Client with Single Click

28 Jun 2018 by RamanaReddy V

Login to your VPN through CISCO with single mouse click jump to your VPN system below 30 seconds..!

Automatically generate a word form

9 Jan 2022 by Richard MacCutchan

You can use VBA in a Word template to generate such a form. See word template vba - Google Search[^] for suggestions.

Automated Excel sheet with too long sheetname and oledb problem

4 Oct 2011 by ARBebopKid

Can you open the file using Microsoft.Office.Interop.Excel and cycle through the sheets to rename any sheets with long names before importing?

how to get IFRAME controls in Window forms using C#

10 Oct 2011 by Ganesan Senthilvel

You can try using the below code:ContentPlaceHolder holder = (ContentPlaceHolder)this.CurrentMaster.FindControl("xyzlogin");HtmlControl control1 = (HtmlControl)holder.FindControl("Email");HtmlControl control2 = (HtmlControl)holder.FindControl("Passwd");HtmlControl control3 =...

mshtml automation question

15 Dec 2011 by Smithers-Jones

If you have any question regarding an article, then use the forum under that article. The chances of the author reading your question here are pretty low.modified: I just saw, that Alexander's last contribution to Codeproject is from 2007 and the article you are commenting on is from 2003,...

.NET CSharp OLE Automation

5 Jan 2012 by 10der

Oh my...1) add attribute to parampublic int NewWithParams(int Fix, [In, MarshalAs(UnmanagedType.SafeArray, SafeArraySubType = VarEnum.VT_VARIANT)] params object[] args){ return Fix;}2)vbs calltest = net.NewWithParams(777, Array("Let", "me", "take", "you", "on",...

Selenium automates browsers: ComboBox fix using C#

7 Jan 2012 by Luciano Culacciatti

What you need to complete a form with tricky ComboBoxes.

C# Auto Login Application

15 Jan 2012 by Fapsterx

So Sendkeys.Sendwait worked!!! Is there anyway I can do this without the window being active? Like if the game is in the background?

TakeScreenShot Succeeds in Virtual Box COM API C++, How to Save Screen Shot?

25 Feb 2012 by Randor

Hi,Why have you neglected to do the research yourself on these Virtual Box API calls? I have never used the Virtual Box API but it took less than 10 seconds to find the SDK reference using my favorite search engine.Virtual Box IDisplay[^]I do realize that codeproject.com is the...

virtual-machine

trying to add a excel worksheet

23 Nov 2016 by zlazic

I have an OLE Autmation c++ project where i'm using #import statements to interact with an Excel application.I'm having trouble adding a new worksheet AFTER the current (active) worksheet.the following call will prepend a new tab:Add(vtMissing, vtMissing, (long)1,...

automata NFA and DFA questions...

15 Oct 2012 by Bitla Phanindra

FREE FORMAL LANGUAGES AND AUTOMATA THEORY [^] EBOOK.Hope that helps. Enjoy!

Find notepad's multiline text box using White UI automation framework

12 Nov 2012 by TRicK

Sorry guys, google rulit.. the answer might be interesting for others..http://social.msdn.microsoft.com/Forums/is/Vsexpressvb/thread/27c3bae8-41fe-4db4-8022-e27d333f714e[^]The main idea:Quote:Actuall this diag is not considered as an exception, it only display when you debug the Auto UI...

Automatically update web site (how?)

16 Dec 2012 by Christian Graus

You need an app on the phone that sends location data through a web service to your database. This app would let you upload pics as well.A web service is your way to get your phone app able to pass data through the web to your DB.

please find and tell me what kind of code it is?

2 Jan 2013 by Fernando E. Braz

i think that you need to look at PLC Programming (Programmable Logic Controller)Beckhoff PLC Training SeriesTwinCAT PLC programminga youtube video.. I hope that it will help you to start ...

How to automatic input a large amount of data into a public website

11 Jan 2013 by Sergey Alexandrovich Kryukov

This is not about HTML at all. Apparently, as this is a Web site, you have to follow HTTP protocol. You need to send HTTP request in exact same way you browser does, most likely using "POST" request method. This is not a problem, because you can always see what a Web page does (what is it, an...

Android API's for Home automation

25 Feb 2013 by Darren_vms

Can Android be used for home automation ?Sure, so can C#, php, basic and any other language. The question really is what hardware are you attempting to interface with ?You can as an example get a light bulb with built in blue tooth Yes you can[^] so as long as you can find out the specs...

please find and tell me what kind of code it is?

11 Mar 2013 by ibis21

It is a language defined as IEC-61131-3 for industrial controlers (PLCs, Servo controls etc.) More info can be found here:http://en.wikipedia.org/wiki/IEC_61131-3The #1 compiler used for this language is from Codesys:http://www.codesys.com/

Excel automation or ADO.NET for handling with excel files?

8 Apr 2013 by LaxmikantYadav

This might help you -> http://bytes.com/topic/c-sharp/answers/254784-excel-automation-vs-ado-net[^]

Excel automation or ADO.NET for handling with excel files?

8 Apr 2013 by Maciej Los

In case you'll ever want to use ADO.NET with Excel, follow below links:How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET[^] - know, its VB.NET, but contains many useful information.Using ADO.NET to work with Excel files[^]Import/export Excel...

WebBroser control - capture to image and simulate mouse clicks

21 Apr 2013 by Sergey Alexandrovich Kryukov

Sending Windows messages does not solve the problem in all cases. You could use a very different approach: simulation of mouse input on a low level. This can be done using Windows API SendInput:http://msdn.microsoft.com/en-us/library/windows/desktop/ms646310%28v=vs.85%29.aspx[^].As you...

WebBrowserControl

If I am using Firefox what kind of add-on are available which can find bugs in a website?

5 Jun 2013 by Prasad Khandekar

Hello,You can use Selenium IDE. This link also lists some other tools for finding security related issues and are worth considerations.Regards,

web_development

Select a row of datagrid using UI Automation

10 Jul 2013 by kasra515

Hi,I'm writing a UI automation software. I need to select a row in the datagrid and then click on the run button. I tried most of the example codes in the internet and they didn't work for me. For example for selecting a gridview row:When I write the following code:AutomationElement...

I need help to send an automatic message using Visual Basic .

19 Sep 2013 by ZurdoDev

Use the SMTP class and create a windows service so that it can be scheduled. This is the Quick Answers forum and since you did not provide any details it will be hard to give you any more than this. There are tons of examples online of how to send emails in VB.Net.

Update a Windows Forms Application

18 Nov 2013 by Rieth L

Hi,I want to know if has a way to my users to run a "patch" then it update the application from version x.0 to x.1 without remove - add...

How do I catch application's pop-up message box

11 Jul 2014 by pdoxtader

You'll have get a list of all the open windows on the machine, and wait for the message box to pop up and be in the list. Then you can select it and send an enter key to close it. Just try Googling "vb.net enumerate open windows" and you'll find many code examples.-Pete

construct finite automata consisting 2 a's or 2 b's

30 Oct 2014 by CPallini

Did you Google for[^]?

I want install multiple windows store apps through windows store

19 May 2016 by Richard MacCutchan

See Launch the Windows Store app[^].

How to recognize dynamically loaded controls in UI automation

8 Feb 2017 by Member 12786162

Hello,I am trying to implement an automated test for a WPF application using UI Automation framework.The problem is with the dynamic loaded controls. For example, the contents of a tab are not updated and UI automation can't find them. When you change the tab you selected, the controls...

How to get the list of pinned applications in taskbar using C#

23 May 2017 by OriginalGriff

Try this: string path = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), @"Microsoft\Internet Explorer\Quick Launch\User Pinned\TaskBar"); string[] files = Directory.GetFiles(path); foreach (string file in files) { ...

How to get the list of items in the start menu windows 8.1 C#

25 May 2017 by RickZeeland

See this article: C#: Get path of Start Menu programs (All USERS) - Programming (C#, C++, JAVA, VB, .NET etc.) - Neowin[^] class Program { [DllImport("shell32.dll")] static extern bool SHGetSpecialFolderPath(IntPtr hwndOwner, [Out] StringBuilder lpszPath, int nFolder, bool fCreate); const...

How to hide ribbon display in excel using C#

6 Jun 2017 by Maciej Los

Check this: VBA auto hide ribbon in Excel 2013 - Stack Overflow[^] A C# form may look like: excelApplication.CommandBars.ExecuteMso "HideRibbon" [EDIT] "HideRibbon" is the name of ribbon you have to change. To get list of IdMso, please see: Ribbon Examples files and Tips[^]

Office-Automation

How can I export my hyperv machines using C#?

16 Dec 2017 by joris.spriet

Hi, instead of rolling your own solution in C#, you might have a look at this: Full Backup of Hyper-V Virtual Machines - PowerShell Script (Update 3.7)[^] More info also here: Backing Up and Restoring Virtual Machines[^] and here: Exporting a Snapshot of a Virtual Machine (C#)[^]

Test Automation in Angular Applications

29 Dec 2017 by Nikola Breznjak

Intro to test automation in Angular apps, and some basic theory concepts about testing

Is it possible to find a window name in runtime or dynamically when coded ui is running

12 Feb 2018 by RickZeeland

See this CodeProject article: C# / VB.NET and WinAPI: How to Access Window of Other Application[^]

Google maps, maximum walking distance routes!

10 May 2018 by Christian Graus

First google hit: Overview | Directions API | Google Developers[^]

Unable to parse poms, failed to rename in jenkins

3 Jul 2018 by Richard MacCutchan

Quote: java.io.IOException: Failed to rename C:\Program Files (x86)\Jenkins\tools\hudson.tasks.Maven_MavenInstallation\TestMaven\apache-maven-3.5.3 to C:\Program Files (x86)\Jenkins\tools\hudson.tasks.Maven_MavenInstallation\TestMaven\apache-maven-3.5.3.__rename That location is protected so...

How can I create a script that run windows form application and creat a class in visuel studio

4 Jan 2020 by Richard MacCutchan

You can easily create your own project templates in Visual Studio. See Project and item template parameters - Visual Studio | Microsoft Docs[^].

I'd like to control imaging edge desktop (without a display)

27 Jul 2020 by Member 14900256

Hello, I am trying to automate Imaging Edge Desktop using pyautogui. I was able to get this to work using the attached code( see What have you tried). The problem is I'd like to have this program control my camera autonomously without a...

What is the simplest way to automate copying a set of files in visual studio 2019?

10 Feb 2021 by Richard MacCutchan

Try Project Properties and Build Events. You can add simple cmd commands to the pre-Build or Post-Build box. The Macros button on the event dialog provides simple shortcuts to the different input and output locations of the project, or you can...

What is the simplest way to automate copying a set of files in visual studio 2019?

12 Feb 2021 by Maciej Los

In ASP.NET Core you're able to quickly change between development and production versions. See: Use multiple environments in ASP.NET Core | Microsoft Docs[^] When you work with WinForms, you're able to achieve something like that with project's...

Need C# excel automation help for formulas using PI() or bogenmass()

26 Feb 2021 by Maciej Los

As @embar.k.adero mentioned, when you use local names of functions (in your nativve language), you have to use FormulaLocal[^], but when you want general solution (no matter of regional settings), you have to use Formula with English names and...

How to insert manual values inside cell in word file in C# using Microsoft interop

4 Aug 2022 by Richard MacCutchan

You just need a set of data (an array or collection) that you want to put in the cells. So replace (cell.RowIndex - 3 + cell.ColumnIndex).ToString() with each item of your data.

How to insert manual values inside cell in word file in C# using Microsoft interop

4 Aug 2022 by 0x01AA

One can address a specific cell directly by row/column index. E.g. like firstTable.Rows[1].Cells[1].Range.Text = "My Value for that Cell"; Note: Keep in mind that for office interop the index of a collection starts at '1' and ends at...

C# how to copy a specific message in Microsoft teams meeting chat to clipboard

16 Mar 2023 by OriginalGriff

So let me see if I understand you ... your teachers want to be sure that you are actually present in a lesson and not sleeping at your computer or goofing off playing games when you should be learning, and you need our help to cheat the system so...

Azure Automation Runbooks in 2024

25 Jan 2024 by Wessel Beulink

Azure spearheads cloud evolution, Azure Automation Runbooks manage hybrid/SOC environments effectively

How to Create a Continuous Integration Continuous Deployment (CI-CD) Solution for a Docker Project

31 Mar 2021 by Frank Boucher

How to build a continuous integration and continuous deployment solution for Docker

continuous-delivery

continuous-integration

Class does not support Automation or does not support expected interface with VB 6.0

14 Sep 2011 by Sanket H. Shah

Hi,I have developed one IE automation project and deployed in some different clients, everywhere its working fine but my one client end I am facing one issue. which creating an instance with Create Object is giving me error no 430, "Class does not support Automation or does not support...

Automated Excel sheet with too long sheetname and oledb problem

4 Oct 2011 by bjoernisemann

Hi,i got a problem with a machine generated excel file. I have no chance to alter any settings for the export and have to live with the files. The problem: the sheetname is longer than the allowed size of excel. When i try to import the excel data via oledb i get an error 22 exception of...

how to get IFRAME controls in Window forms using C#

10 Oct 2011 by abhishekJyoti

I am using the Webbrowser control(IE object) in VS 2008 C# Express to automate thenavigation of pages on a partner's web site. The first page containsan element:Within that frame I need to access these three elements:

Deleting Test Results in CruiseControl.Net

30 Nov 2011 by Member 8192163

Hi,I am not sure if questions related to CruiseControl.Net can be asked here but I am giving it a try.I have it setup for the automated unit testing for my projects. But, everytime it runs the test, the test results count keeps increasing and I have to manually delete the folders after a...

Selenium 2 with C# - dropdown value selection

13 Dec 2011 by Ashakoti

I have started automating HTML using Selenium 2 with NUnit and C#.I need help to access dropdown value.Html code which I have written returns count as 0 even though there are values.var driver2 = frame.FindElements ( By.Id ( "PageWizard_ddlAccounts" ) );driver2.count;

real life program of context free grammar

16 Dec 2011 by OriginalGriff

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Context free Grammar(CFG) program in c#

16 Dec 2011 by RaviRanjanKr

Try Parsing Expression Grammar Support for C# 3.0 Part 1 - PEG Lib and Parser Generator[^]read the thread from this question Is C# context-free? [^]from reference linkftp://ftp.research.microsoft.com/pub/tr/tr-2003-32.pdf[^]

time perti net verification

20 Dec 2011 by fresh_girl

I have a PN for an elevator and I'm using timed PN so that I can find out if the elevator can get to a certain point within certain period of time!is that correct ? I can make sure of the time condition , but doesn't time PN have algorithms to do so ?any reference you recommend about...

time perti net verification

20 Dec 2011 by Sergey Alexandrovich Kryukov

I'm sorry to say I know only the algorithm for non-timed 1-concervative Petri Net. This algorithm is based on linear algebra and all it can do is to determine reachability of any location from any other location. For example, if you identify one or more locations as a deadlock but can proof that...

Links to download some tutorials about Word Automation?

22 Dec 2011 by supernorb

The title says all what I need, could you suggest me some links???Or if possible, could you suggest other links to download code samples???Your help would be highly appreciated!

Links to download some tutorials about Word Automation?

22 Dec 2011 by #realJSOP

Go here [^]

Links to download some tutorials about Word Automation?

22 Dec 2011 by Wendelius

One place to start from: Word Object Model Overview[^]

Bullet and numbering with Word Automation, how to?

22 Dec 2011 by supernorb

Could you let me know how to add bullet and numbering in a word document using word automation?I looped through all properties of Range (Document.Range, Selection.Range, etc) without finding anything related to Bullet and numbering.Thank you!

The mapped Word Interop class to TextBox in MS Word?

22 Dec 2011 by supernorb

Word Interop library has many mapped classes to the corresponding objects in MS Word such as Paragraph, Table, Chart, Selection.But I don't find out the mapped class to TextBox, could you let me know its name and its location in Word Interop library?The term 'class' above in fact is...

Bullet and numbering with Word Automation, how to?

22 Dec 2011 by Neha Thanka

changing-bulle...

The mapped Word Interop class to TextBox in MS Word?

25 Dec 2011 by Sergey Alexandrovich Kryukov

First, many types of the Microsoft.Office.Interop.Word are technically the interfaces but are named not according to the naming conventions of interfaces. I just referenced and opened, out of curiosity, Microsoft.Office.Interop.Word v.12.0.0.0 and can confirm it. However, you should not be...

Automatically Pop up needs to be Closed

26 Dec 2011 by Testing_authority

Hello I just want to closed open confirmation message popup without clicking on it.Now i found a solution.thanks for your timeThanks,Testing Authority

Regular expressions in selenium webdriver

3 Jan 2012 by Ashakoti

Can anyone please tell me how to use regular expressions in selenium webdriver c#i have a Html element ID which has numbers in between like "WebDri123Ver"Number keeps changing everytime.. Thanks in advance

Read the calculated values from Excel using AddIn Formulas and Microsoft Object Library

3 Jan 2012 by Member 3150531

we are trying to retrieve a calculated value from a cell which has add-In (VBA) formulas in it. The sample add-in "myUtilityl.xla" is working properly in excel. It retrieves value for the addin function =ISOWEEKNUM(F9). But we are unable to retrieve the value in our application using C#...

.NET CSharp OLE Automation

5 Jan 2012 by 10der

Hi!I have simple OLE Automation code:[ComVisible(true)][ProgId("Olololo.Test")][ClassInterface(ClassInterfaceType.AutoDispatch)][Guid("a1dd5e0f-b9e7-470f-7777-77777e44188d")][skip...]public int NewWithParams(int Fix, params object[] args){ return Fix;}vbs...

No script is getting recorded or generated after I stop recording (Load Runner)

19 Jan 2012 by Testing_authority

Hello I am using VUGen 9.10(Load Runner) and recording a page on IE 8, O/S -Windows XP,SP3No script is getting recorded or generated after I stop recording. Can you'll please suggest a solution to fix this.Thanks,AJ

How we can use subscript and superscript function in QTP?

24 Jan 2012 by Testing_authority

Hello TeamI want to use subscript and superscript function in my QTP script then please tell me how?Thanks,AJ

Truncate table Automatically

5 Feb 2012 by Christian Graus

Your asp.net does not contain a table, your SQL Server does. As others have said, ASP.NET doesn't have any code that runs constantly. I would look at setting up jobs inside SQL Server, or you could write a windows service that responds to a timeout to perform your task.

VB.Net Auto-Fill File Upload Webform

5 Feb 2012 by Jyothikarthik_N

Hi,You can try this javascript idea:function funcAutofillUploadForm() { var uploadctrl = document.getElementById('MainContent_fuControl'); var inputCtrl = uploadctrl.outerHTML; }Now, inputCtrl would hold something like:

OLE Automation Error 438 when installing an XLL as a custom action

10 Feb 2012 by tagad

Hi, I would like to register an XLL while installing a project using MSI. I am using a VB.NET installer class to do this: Imports System.ComponentModelImports System.Configuration.InstallImports System.ArgumentExceptionImports Microsoft.Office.Interop Public Class...

Autocorrect text in Word with c#

16 Feb 2012 by toby31

I'm trying to use the spellCheck feature provided by word to correct a string that is not in English, the problem is that when i use the spellCheck function i get the Spelling and Grammar dialog which requires user input and i don't want that to happen.This is my code using...

Autocorrect text in Word with c#

16 Feb 2012 by toby31

I've solved it but it's really really slow, so any new ideas are welcomed.using Microsoft.Office.Interop.Word; class WordProofing { private Application _wordApp; private readonly Document _wordDoc; private static object _oEndOfDoc = "\\endofdoc"; ...

OLE Automation Error 438 when installing an XLL as a custom action

17 Feb 2012 by Maciej Los

Take a look at my code...I have created windows application.I have placed on the form:1) 1x textbox - Name: TxtExcelAddin2) 2x buttons: - a) CmdBrowse (browse for addin) b) CmdInstall (install addin)Public Class Form1 Private Sub CmdBrowse_Click(ByVal...

MS Access Excel automation "Select method of rane class failed?

23 Feb 2012 by avianrand

I've tried changing this around so many different ways based on what I've found online and just can't get it to work. The line "xlWkSht.Rows(Trim(Str(i)) & ":" & Trim(Str(i))).Select" is where the error occurs. Any help would be appreciated. Here's my code:Dim xlApp As Excel.ApplicationDim...

MS Access Excel automation "Select method of rane class failed?

23 Feb 2012 by ZurdoDev

Have you tried taking the Str off of Str(i)? If I add Str in VBA it errors but it works without it. The other thing you can try since you are only selecting 1 rows is to do Rows(i).Select