Skip to content

Instantly share code, notes, and snippets.

@fornext1119
fornext1119 / gist:2964459
Created June 21, 2012 07:54
Perl で Access の Report を印刷する
use Win32::OLE;
use constant AcOutputReport => 3;
use constant AcViewPreview => 2;
use constant AcFormatXLS => "Microsoft Excel (*.xls)";
use constant AcFormatRTF => "Rich Text Format (*.rtf)";
use constant AcFormatSNP => "Snapshot Format (*.snp)";
use constant AcFormatHTML => "HTML (*.html)";
Win32::OLE::CreateObject("Access.Application", $acApp);
@fornext1119
fornext1119 / gist:2964381
Created June 21, 2012 07:24
Python で Access の Report を印刷する
# coding: Shift_JIS
import win32api, win32con, win32com, win32com.client, os, time, sys
acOutputReport = 3
acViewPreview = 2
acFormatXLS = "Microsoft Excel (*.xls)"
acFormatRTF = "Rich Text Format (*.rtf)"
acFormatSNP = "Snapshot Format (*.snp)"
acFormatHTML = "HTML (*.html)"
@fornext1119
fornext1119 / gist:2964315
Created June 21, 2012 07:00
Ruby で Access の Report を印刷する
require 'win32ole'
AcOutputReport = 3
AcViewPreview = 2
AcFormatXLS = "Microsoft Excel (*.xls)"
AcFormatRTF = "Rich Text Format (*.rtf)"
AcFormatSNP = "Snapshot Format (*.snp)"
AcFormatHTML = "HTML (*.html)"
acApp = WIN32OLE.new('Access.Application')
@fornext1119
fornext1119 / gist:2964196
Created June 21, 2012 06:22
VBScript で Access の Report を印刷する
Option Explicit
Const acOutputReport = 3
Const acViewPreview = 2
Const acFormatXLS = "Microsoft Excel (*.xls)"
Const acFormatRTF = "Rich Text Format (*.rtf)"
Const acFormatSNP = "Snapshot Format (*.snp)"
Const acFormatHTML = "HTML (*.html)"
Dim acApp: Set acApp = CreateObject("Access.Application")
@fornext1119
fornext1119 / gist:2958482
Created June 20, 2012 06:48
PowerShell で Internet Explorer を 制御
$ie = New-Object -ComObject internetexplorer.application
$ie.Visible = $true
$ie.Toolbar = $true
$ie.MenuBar = $true
$ie.AddressBar = $true
$ie.StatusBar = $true
#ログオン画面
$ie.Navigate('http://192.168.1.1/zzzz.asp')
while($ie.busy -or $ie.readystate -ne 4)
@fornext1119
fornext1119 / gist:2958331
Created June 20, 2012 05:48
JScript で Internet Explorer を 制御
var ie = WScript.CreateObject("InternetExplorer.Application");
ie.Visible = true;
ie.Toolbar = true;
ie.MenuBar = true;
ie.AddressBar = true;
ie.StatusBar = true;
//ログオン画面
ie.Navigate("http://192.168.1.1/zzzz.asp");
while (ie.Busy || ie.readystate != 4)
@fornext1119
fornext1119 / gist:2957763
Created June 20, 2012 02:12
Python で Internet Explorer を 制御
# coding: Shift_JIS
import win32api, win32con, win32com, win32com.client, os, time, sys
ie = win32com.client.Dispatch("InternetExplorer.Application")
ie.Visible = True
ie.ToolBar = True
ie.MenuBar = True
ie.AddressBar = True
ie.StatusBar = True
@fornext1119
fornext1119 / gist:2957761
Created June 20, 2012 02:11
Ruby で Internet Explorer を 制御
require 'win32ole'
ie = WIN32OLE.new('InternetExplorer.Application')
ie.Visible = true
ie.Toolbar = true
ie.MenuBar = true
ie.AddressBar = true
ie.StatusBar = true
#ログオン画面
@fornext1119
fornext1119 / gist:2957750
Created June 20, 2012 02:07
PHP で Internet Explorer を 制御
<?php
$ie = new COM('InternetExplorer.Application');
$ie->Visible = true;
$ie->ToolBar = true;
$ie->MenuBar = true;
$ie->AddressBar = true;
$ie->StatusBar = true;
#ログオン画面
@fornext1119
fornext1119 / gist:2957723
Created June 20, 2012 02:04
Perl で Internet Explorer を 制御
use strict;
use warnings;
use Win32::OLE;
my $ie = Win32::OLE->new('InternetExplorer.Application');
$ie->{Visible} = 1;
$ie->{ToolBar} = 1;
$ie->{MenuBar} = 1;
$ie->{AddressBar} = 1;