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
2
votes
1 answer

win32ole gem for jruby

I'm trying to install jruby gem from http://github.com/bpmcd/win32ole . it seems that standard jruby -S gem install win32ole doesn't work. I'm ruby noobie, and so far I understand that this package is not a gem? Am I correct? Do I need to build…
rita
  • 21
  • 3
2
votes
2 answers

How to install win32ole for nodejs (i.e. making node-gyp work properly)

Sorry, I'm a newbie of nodejs. I'd like to try the package win32ole in nodejs under Windows7, but when I run the installation command npm install win32ole in a command prompt window opened as administrator, many errors pop up. My configuration…
mmj
  • 5,514
  • 2
  • 44
  • 51
2
votes
1 answer

node js win32ole installation error

I get an error when I'm trying to run this command "npm i win32ole". C:\NODE JS. EXPRESS\node_modules\win32ole\node_modules\ref>if not defined npm_co nfig_node_gyp (node "C:\Program…
Vladyslav Nikolaiev
  • 1,819
  • 3
  • 20
  • 39
2
votes
1 answer

How to access VBA library via win32ole in Ruby?

I am trying to access the VBA method 'RGB' via Ruby: The problem is this method belongs to the 'VBA' library not the 'Excel' library. To connect to the Excel library I would do something like this: require 'win32ole' xl =…
Nathan
  • 412
  • 6
  • 16
2
votes
1 answer

Requirements for .NET .dll to be accessible by Ruby WIN32OLE

My question is very similar to Calling a C# .dll from Ruby via COM I am a developer working in Ruby / WebDriver and have had a lot of success automating our web applications. I would like to send notifications via our email service and to do so,…
hardknocks
  • 155
  • 1
  • 7
2
votes
1 answer

Text Box control in Excel - how to reference in Perl

I have excel file, which has TextBox control at one of its sheets with the name TextBox1. And there's some text in this TextBox, that I need to extract. I'm trying to get this text with a help of Perl, however I have no idea how to reference…
MaterialGirl
  • 363
  • 2
  • 10
  • 22
2
votes
1 answer

Is it possible to move Outlook folders using Win32::OLE?

I have manage to add folders in Outlook, but can't work out how to move them. The code I have does not throw out any warnings and does not move the folder: #!/usr/bin/perl use strict; use warnings; use Win32::OLE; use Win32::OLE::Const 'Microsoft…
user3360439
  • 359
  • 1
  • 4
  • 13
2
votes
1 answer

Ruby win32ole MS Access: How to find all the records updated since last export?

I am using win32ole module/library to gain access to an Access database. But I can't find as I can in Rails the created_at or updated_at columns in any of the tables in the database. I was wondering how does one finds rows that are updated, then? So…
Nik So
  • 16,683
  • 21
  • 74
  • 108
2
votes
2 answers

Ruby script to read the last filled cell in a column

i need a ruby code to read the column a and find where does the last filled cell in the column ends.In the image uploaded the last filled data is i in cell "A21". i need to know this cell address through ruby code.
anurag
  • 145
  • 1
  • 1
  • 8
2
votes
1 answer

Ruby script to check if a worksheet is present in workbook

I need to know whether a sheet exists in the workbook or not using ruby. code excel = WIN32OLE.new('Excel.Application') excel.visible = false workbook = excel.Workbooks.Add(); worksheet = workbook.Worksheets.Add()…
anurag
  • 145
  • 1
  • 1
  • 8
2
votes
1 answer

Extract mail from Exchange and load into Mysql. Perl Win32::OLE or Perl Net::POP3, or try it in Ruby

My problem is this: I need determine the timestamp of the first and last email sent from an Exchange account for every day that mail exists for. Also, for each day I need to rank the words that appear in each email so that I can report trend words…
sam_pointer
  • 75
  • 1
  • 4
2
votes
1 answer

Retrieve excel cell background color using perl excel win32 ole

I need to retrieve the background color of an excel cell (set to red/green based on a conditional formatting in the sheet). Tried searching the forums but couldnt find anything to retrieve although setting the colors are there. Any help would be…
Siva
  • 294
  • 1
  • 9
  • 25
2
votes
2 answers

How do I set Excel formulas with Win32::OLE?

Can anybody tell me, why the ...->{FormulaR1C1} = '=SUMME( "R[-3]C:R[-1]C" )'; doesn't work. In the Cell where the result should appear I get "#Wert!" ( maybe "Value" in English ). With the WENN(IF)-formula I get what I expect. …
sid_com
  • 24,137
  • 26
  • 96
  • 187
2
votes
1 answer

How to Execute/ShellExecuteEx/InvokeCommand ITEMIDLIST pointing to Shell objects?

I'm building a kind of dock, and I struggle at finding how to save things like "Run", "Search", "Help", "Printers" and reopen them after that. I tried this : CComPtr pDF; SHGetDesktopFolder(&pDF); LPITEMIDLIST…
Emmanuel Caradec
  • 2,302
  • 1
  • 19
  • 38
2
votes
1 answer

How to instal win32ole for ruby

Does anyone know the command to install win32ole for ruby. gem install win32ole does not work I am trying to get require 'win32ole' to work
thedarkknight228
  • 535
  • 1
  • 5
  • 9
1 2 3
…
14 15