Παρουσίαση με Ετικέτες

• API
• DragDrop
• DropHandler
• Excel
• Filenames
• Gotcha
• Posts
• Scripting
• Sheets
• Speadsheet
• Unicode
• Workaround
• Worksheets

Gotcha: VBScript DropHandler doesn’t support Unicode filenames
09 Σεπτεμβρίου 18 12:33 πμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

It seems VBScript (.vbs) script file’s DropHandler on Windows is broken regarding Unicode filenames, as described at https://stackoverflow.com/a/4366906/903783 A workaround suggested by user DG there (https://stackoverflow.com/a/13587850/903783) was to use a batch file to accept the dropped file, then pass the filename(s) to the VBScript script file (.vbs) as command-line parameters. If you just care about […]

Δημοσίευση στην κατηγορία: Posts, Excel, Gotcha, Unicode, VBScript, Filenames, DragDrop, DropHandler, Workaround

Gotcha: Worksheets property is read-only, Sheets is not – Excel Workbook
26 Ιανουαρίου 15 07:27 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

My contribution to: http://stackoverflow.com/questions/14109102/how-do-i-add-a-worksheet-after-all-existing-excel-worksheets   Seems Worksheets property is read-only Returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object. https://msdn.microsoft.com/en-us/library/office/ff835542(v=office.15).aspx whereas Sheets is the real thing where you can also add Sheets dynamically A collection of all the sheets in the specified or active workbook. https://msdn.microsoft.com/en-us/library/office/ff193217(v=office.15).aspx Tagged: API, […]

Δημοσίευση στην κατηγορία: Posts, Excel, Gotcha, API, Scripting, Sheets, VBScript, Speadsheet, Worksheets