Stack Overflow
Stack Overflow

Questions tagged [win32ole]

Object Linking and Embedding (OLE) is a proprietary interface to Microsoft applications. Most notably the Microsoft Office suite.

Object Linking and Embedding is an API provided by Microsoft to allow for control operations with Microsoft Applications.

Perl can make use of this API using the Win32::OLE module. Ruby also has a WIN32OLE class which does much the same.

However the primary scripting language is VBA, and Microsoft supply a variety of examples via MSDN

May be synonymous with the OLE tag, although anyone specifying Win32::OLE (or WIN32OLE) is probably specifically using Ruby or Perl.

Ref: Wikipedia:OLE

213 questions
0
votes
1 answer

Command Prompt error since i am using a generic path to open an excel file

Command Prompt its not working since i am using a generic path to open a excel file. Here is the error message: T:\PointOfSale\Projects\Automated Testing\TASWeb\TP\TP_Branch>ruby -rubygems Tes tTP_UK.rb TestTP_UK.rb:19:in 'method_missing': (in…
Sal
  • 89
  • 1
  • 9
0
votes
1 answer

How to access the data on a dropdown list in excel using WIN32OLE

I want to programatically choose one of the options available in a Excel Dropdownlist. To manipulate the worksheet I'm using win32ole on ruby. It works well until I try to change the value of the dropdownlist. I simply don't know how and google has…
Kenneth Ivan Rodriguez
  • 55
  • 8
0
votes
1 answer

how to wait till we work on opened excel and proceed ruby code once it is closed manually

I trying to achieve below thing in Ruby Open an Excel require 'win32ole' excel = WIN32OLE.new('Excel.Application') worksheet = application.Workbooks.Open("C:/testing.xlsx").Worksheets("Sheet1") excel.visible = true Make necessary changes to…
Pravin Mali
  • 37
  • 7
0
votes
1 answer

Perl using Win32::OLE Module Excel 2007- Not Able to Generate Chart

I am running following simple script on perl64 to generate chart on excel but I am getting following errors without generating any chart. It opens excel sheet, write data into sheet but no chart. Win32::OLE(0.1709) error 0x80020003: "Member not…
user2263994
  • 1
0
votes
1 answer

Trying to understand why Perl Win32 OLE Excel Server threw an exception

Trying to understand and diagnose what is wrong with my Excel setup on a MS server 2008. See MWE below. This works fine on my Win laptop but not so great on server. From clean login it runs ok the first time, but subsequent runs fail with error…
Chris
  • 538
  • 8
  • 19
0
votes
1 answer

ruby WIN32OLE c# dll custom event listening

I have found this nice tutorial on connecting to a c# dll from Ruby: Can Ruby import a .NET dll? This works great for Ruby=>C# but not for c#=>Ruby. Now I was thinking to work with some custom events to which Ruby can hook up. I followed example A…
KenGey
  • 406
  • 4
  • 15
0
votes
1 answer

perl and excel graph axes

I'm fiddling with excel graphs created in a perl script and trying to set minimum and maximum axes however I don't seem to be able to get my head around the VBA to Perl Conversion. Please can you help. I have tried this a few different ways, but…
MicrobicTiger
  • 577
  • 2
  • 5
  • 21
0
votes
1 answer

Confusion with Ruby to save the files with any extensions to the excel columns

I am creating a script to insert the files from folders to the Excel columns, but it seems I am doing wrong. Can any one help me for the same? updated Ruby Code: require 'fileutils' require 'win32ole' #Excel Application will be started from…
Arup Rakshit
  • 116,827
  • 30
  • 260
  • 317
0
votes
1 answer

Ruby eventmachine and WIN32OLE

I'm trying to use the WIN32OLE class in conjunction with the eventmachine library. The OLE library communicates fine with the program, but the minute I add the WIN32OLE_Event hook to the program, it doesn't. The events fire at unpredictable times…
Supy
  • 180
  • 2
  • 10
0
votes
1 answer

insert image in .doc using win32ole library of Ruby

As the Title suggests, i am trying to find how to insert image in MS Word(.doc file) using ruby Win32Ole api. I have tried the function InsertFile of Range Object but it seems, it is only made for inserting other doc file in our file in question.…
RubyDubee
  • 2,426
  • 2
  • 23
  • 34
0
votes
1 answer

Virtual file in memory

I'm adding encryption functionality to existing program (plain c console app). It takes few files as input parameter and my task is to make this files(sensitive data) secured. What I do now is that I encrypt the files first (simple XOR with external…
Adam Astar
  • 1
  • 2
0
votes
1 answer

executing win32ole script on remote windows machine through telnet

I am trying to create a word document on a remote windows machine. What I am trying is to telnet to the remote windows machine and run a perl script that creates word document through Win32::OLE. But it doesn't seem to work. Is this possible?…
Anand
  • 355
  • 1
  • 2
  • 12
0
votes
1 answer

Getting OLE Exception while closing document in Perl

I am getting following exception in perl. Also i am now to perl technology. Exception is : Win32::OLE<0.1709> error 0x800a1423 in METHOD/PROPERTYGET "Close" at getWordComments.pl line no 350 here is the sample code of getWordComments.pl…
user1338040
  • 39
  • 1
  • 8
-1
votes
2 answers

Issues reading Time value in Perl using win32:OLE

I am trying to read an Excel in Perl which have values in format --> "12:21:33 PM" I need to Compare the Values of two cells and then need to sort them our accordingly. But the issue is that when i tried to read the values and checked (by using…
Karan Sharma
  • 45
  • 6
-1
votes
1 answer

How to Drag files and folders from Win32 application and Drop in to explorer

am working in C++ Win32 Application and I implementing DragAndDrop operation, I can able to drag a files and folders from explorer to my application using WndProc calls with WM_DROPFILES, Now I trying for DragAndDrop files and folders from Win32…
Krish
  • 376
  • 3
  • 14
1 2 3
…
14
15