Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
How To
 | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|
- !Windows Commandline Tricks
- A Word or Phrase in the file search Not Working on XP
- Access to Hardware MP3 Player Device
- Admin Test
- AskYesNo with TimeOut
- Associate Extension to Run Winbatch File
- Autohide Taskbar Code
- Automate FireFox
- Automatically Answer a Dialog Box
- Automatically Clear Pause after EXE Launches
- Base64 encodeing a file
- Block New Program Installs
- BMP Color Change
- Brute Force Way to Convert an int64 that WinBatch Can Handle
- Calculate Text width and height
- Can WinBatch Associate Files
- Capture Control Break
- Change Cursor to Hourglass
- Change Cursor
- Change Explorer Favorites Location
- Change Ip Address
- Change Proportional to Fixed Fonts in Itembox
- Change Share Path
- Changing Default CDROM Drive
- Changing the Windows language
- Check for Multiple Instances of an Application
- Check If a File Is Locked
- Check if a Server is Available
- Check if Application is Installed
- Check if Application is Responsive
- Check if Computer is Locked or Idle
- Check If Extender Is Already Loaded
- Check if Program is Installed
- Check If Someone Is Logged In
- Check If Third Party Menu Item Is Checkmarked
- Check Systems for the MSBlaster Virus
- Check the Grayed-NonGrayed State of Buttons in Pull Down Menus
- Check Which Patches Are Installed
- Clipboard Input Blocked
- Close Child Windows
- Combining WB Scripts
- Command Line Stdin Stdout
- Communicate with a Third-Party Applications Windows-dialogs
- Compress Directory Attribute
- Configure a Workstation to Run HealthStar
- Control Compatibility Mode
- Controlling Citrix Web Client Using WinBatch
- Convert Hex to Ascii
- Convert Image to TIFF
- Convert Temperatures
- Convert TIF to JPG
- Convert Unicode to Big Endian Format File
- Convert Unicode to Big Endian
- Copy Protecting WinBatch Applications
- Create a PDF File
- Create a Shortcut to DUN
- Create a Template WBT file
- Create a Zero K file
- Create Editbox to Accept Formatted Data
- Create Hard Link
- Create Junction Points
- Create Single Byte Arrays and Structures
- Create Startup or Shutdown Script Policies
- Delete a Large Number of Files
- Delete Internet Cookies
- Detect Interact with Desktop
- Detect System Startup Complete
- Detect Version of Java
- Detecting a Locked Workstation
- Detecting Dual Monitors
- Determine Color Range
- Determine Current CD ROM WB is Running On
- Determine IE version installed
- Determine If Menu Bar Has Been Clicked
- Determine if RAS Connection
- Determine Process Start Time
- Determining If a Machine is a Domain Controller
- Disable a Device
- Disable CD Autorun
- Disable Device
- Disable Enable Network Card
- Display Graphical Directory Tree in a Message
- Displaying JPG Files Using Windows Viewer
- Displaying Text Messages on the Console
- DNS Suffix
- Easily Parse Log Files
- Easter finder
- Email HTML Form Data
- Enable or Disable Network Connections
- Enable or Disable Wireless Connection
- Enumerate Devices
- Even or Odd
- Excel Version
- Executing EXE on Remote Computer
- Exit if PC is Idle
- File Size On Disk
- File System Notification on Change
- Financial calculations
- Force Extender Dll Updates
- Format a disk on Windows 2000 or Windows XP
- FTPS Protocol
- Get Current Power Scheme
- Get Current Process ID
- Get Current User Remotely
- Get Data From Memory Address,txt
- Get Default Internet Connection
- Get Highlighted text from Any Window
- Get IE Cache history
- Get Info from a Pair of Directories
- Get Length of MPEG File
- Get line Count and Append if Necessary
- Get Menu String
- Get Microsoft Office Version
- Get Network Address Using IP Address and Subnet mask
- Get Persistent Drive Mappings
- Get Pixel Color
- Get Preferred Language
- Get Process Information from running WinBatch Scripts
- Get ProcessID Thread
- Get Program Files Directory
- Get Remote IP Addresses and Usernames to a List
- Get Unique Records in a List
- Get Version of Internet Explorer
- Get WinBatch Process Environment Block
- Get Windows API Documentation
- Getting WinBatch to Wait - Pause
- GINA Winlogon Desktop and Winbatch
- Grab System Information from MSINFO32
- Handle Errors Including UDFs
- Handling Asynchronous Notifications
- Hibernate
- Hide all the Icons on the Desktop
- Holding down a Key
- How To Call Windows API Functions
- How To Check if a File Handle is Closed
- How to clear event logs
- How to Count Items and Delimiters in a List and Extract Items
- How to Encrypt a Line of Text - Simple Explanation
- How to FTP
- How to Get Encrypted Attribute from a Directory
- How to Locate Functions In Helpfiles
- How to Locate functions in the help files
- How to push Microsoft hotfixes
- How To Read Large File in Multiple Parts
- How to Recurively Copy Files
- How to Retrieve Data from a Database File
- How to Set the AskDirectory Dialog Box Size
- HTML Form Submitted to Winbatch Script
- HTTP Authentication
- Icon Extractor
- Image Comparison
- Increment Through the Alphabet
- Inf Install
- Install a font
- Install AD Printer
- Install File and Print Sharing
- International Date Settings
- Internet Explorer Cache History Retrieval
- Internet time monitor
- Interprogram Communication
- ISO CD Image File
- Issues Interacting with FileMaker Pro
- Kill Predecessor
- Killing 16 bit apps in NT
- Last time ScanDisk and Defrag Performed
- Launch a program on the System Tray
- Launch a WBT File using Explorer SendTo
- Launch Script from SendTo
- Launch the file properties dialog for a file
- Launch WinBatch from Internet Explorer Context Menu
- Limit User Access to Computer
- List all Hotkeys
- List Applications Installed on Remote Machines
- List DVD Drives
- List Installed Modems
- Listing Files from within Zip Files
- Lock NT Server
- Loop Forever until SHIFT Key Pressed
- Lotus Notes - DllCall to change password
- Make a Multiline Input Box
- Make a Thumbdrive Read-Only
- Make Directory Listings
- Make Task Bar Blink
- Make WinBatch Delete Itself
- Making Bitmap files via GDI calls
- Manipulate screen or file data
- Map Ports to Services
- Microsoft Service Pack Checker
- MIME Utility for Email Messages
- Modify Internet Explorer Automatic Detect Setting
- Modify Local Group Policy
- Monitor for Windows Shutdown or Logoff
- Mouse Drag and Highlight - Display Image
- Msi Get File Version
- OCR Support
- Open File Search from StartMenu
- Open MultiUser Files on a Network
- Parse HTML
- Pass Memory Variables to VB
- Passing Parameters from Javascript
- Print Formatted Image Files
- Pushing Elevated WinBatch Scripts to Users
- Query Excel Status Bar Txt
- Random Alpha Numeric Number
- Read Hardware Video BIOS
- Read Quote in INI File
- Read Statusbar Text from Browser
- Recursive directory name search
- Reduce Shape Point List
- Refresh Policy
- Regular Expression Question
- Release LAN IP Settings
- Remove HTML Tags
- Rename a Username without Admin Rights
- Reset IE Settings
- Resize and Place Dialog boxes with 2nd wbt
- Retain Quotation Marks in WB Command Lines
- Run Explorer in a Different Security Context
- Run from Current Location - Webpage
- Run PowerShell Command
- Run WinBatch From Webpage
- RunWithLogon Return to Local User Account
- Save Screen to a BMP File
- Script Minimized When Launched from Lotus Notes Email
- Script Windows Component Install
- Scripting the Group Policy Management Console
- Search for Folder Existence
- Send Control Break to a Window
- Server Connectivity
- Set Disk Volume Name
- Set Modified Date for a Directory
- Set USB Drives To Read Only
- Set Volume
- Show Desktop
- Sorting START menu Alphabetically
- Specify a Script to Run on Startup Shutdown Logon Logoff
- Start Program Only at Windows Shutdown
- Store Image in WBT Script
- Strip out Variable from WBERRORHANDLER Line
- Switch with a Variable Name
- Test
- Thoughts on Writing Faster Code
- Track an Incoming Fax
- Transferring info between WB and other programs
- Translate ANSI Sequences
- Traversing Network Neighborhood using AskFileName
- Turn File Sharing Off on Win95
- Uninstalling Software
- Unlock Workstation Trick
- Use Contents of One AskItemList Box within Another
- Use Global Varaible to tell Errorhandler to Ignore Specific Errors
- Using MS System Agent to Run a WBT File
- Validate WIL Variable Name
- Validating Password
- Various Ways to Download a File
- Verify Calling Parent Process
- Wait until no Input
- WAN IP Address
- Web Scraping
- Winbatch Findstr Equivalent
- Working with RAR Files
- Write to USB Port
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Excel Version
Question:
I am looking for a code snippet that will accept an .XLS file as input and output the version of Excel that created it. I was wondering if the same could be accomplished with WB Binary functions?Answer:
The Microsoft Knowledge Base Article - 239653 gives you further more informations about determining excel file version.Give this code a try:
ifile="spreadsheet.xls" buf=binaryalloc(filesize(ifile)) binaryread(buf,ifile) ;build the search string str=strcat(num2char(6) ,num2char(5)) ;find it and move forward three spaces pos=binaryindex(buf,0,str,@FWDSCAN) + 3 ;here they are buildID=binarypeek2(buf,pos) buildYear=binarypeek2(buf,pos+2) binaryfree(buf)
I tried it on my oldest and newest spreadsheets, seems to work.
In the MS Excel SDK there exists an utility called BIFFVIEW.EXE that might play with the excel specific record types. I think the BIFFVIEW can read the recordtype BOF (ID = 0x0009 resp. 0x0209 ... resp. 0x0809) from all excel file versions. Once you have the BOF record isolated, the version number can be extracted from this record.
Another way can be the COM utility MSOFILE.DLL from Microsoft. Because this module looks for the file properties, it might not deliver results for each excel file. If there is no property embedded, then the COM module fails. But it is worth a try. See attachment.
;------------------------------------------------------------------------------------------------------------------------------------------
IntControl(73,2,0,0,0) ; Gosub the label :WBERRORHANDLER.
; The OLE Document Property Reader COM module.
sOLEDLL = "D:\TEMP\DSOFILE.DLL" ; <== Change path to your needs.
; Register the COM component.
iResult = DllCall(sOLEDLL,long:"DllRegisterServer")
If iResult Then Exit ; Terminate immediately.
; We work with a prepared list of excel filenames.
sFilename = "D:\TEMP\FileList.Excel.txt"
sList = ""
; Set size of internal FileRead buffer.
iLastFRSize = IntControl(65,4096*64,0,0,0)
hFR = FileOpen(sFilename,"READ")
oDSO = ObjectOpen("DSOleFile.PropertyReader.1")
While @TRUE
sLine = FileRead(hFR)
If (sLine=="*EOF*") Then Break
If (sLine=="") Then Continue
sVersion = "N/A"
iLastErrorMode = ErrorMode(@OFF)
oDocProp = oDSO.GetDocumentProperties(sLine)
iLastError = LastError()
If oDocProp
sVersion = oDocProp.Version
ObjectClose(oDocProp)
EndIf
sList = StrCat(sList,sVersion,"|",sLine,@LF)
EndWhile
ObjectClose(oDSO)
; Unregister the COM component.
iResult = DllCall(sOLEDLL,long:"DllUnregisterServer")
FileClose(hFR)
IntControl(63,100,200,900,700) ; Sets coordinates for AskFileText, AskItemList and AskTextBox windows.
AskItemList("Version",sList,@LF,@SORTED,@SINGLE)
Exit
;------------------------------------------------------------------------------------------------------------------------------------------
:WBERRORHANDLER
Return
;------------------------------------------------------------------------------------------------------------------------------------------
Article ID: W15973
File Created: 2004:03:30:15:42:06
Last Updated: 2004:03:30:15:42:06