This is an esoteric OOP concept and there’s a little more you need to do and understand to use a custom collection of shapes. You may first want to go through this answer to get a general understanding of classes and interfaces in VBA. Follow the below instructions First open Notepad and copy-paste the below …
Try using an X-Y Scatter graph with datetime formatted as YYYY-MM-DD HH:MM. This provides a reasonable graph for me (using Excel 2010).
There is an interesting project on github called Excel Builder (.js) that offers a client-side way of downloading Excel xlsx files and includes options for formatting the Excel spreadsheet. https://github.com/stephenliberty/excel-builder.js You may encounter both browser and Excel compatibility issues using this library, but under the right conditions, it may be quite useful. Another github project …
I would expect the error is to do with the macro you’re calling, try the following bit of code: Code import os, os.path import win32com.client if os.path.exists(“excelsheet.xlsm”): xl=win32com.client.Dispatch(“Excel.Application”) xl.Workbooks.Open(os.path.abspath(“excelsheet.xlsm”), ReadOnly=1) xl.Application.Run(“excelsheet.xlsm!modulename.macroname”) ## xl.Application.Save() # if you want to save then uncomment this line and change delete the “, ReadOnly=1” part from the open function. xl.Application.Quit() …
Try using Worksheet.Protect “Password”, UserInterfaceOnly := True If the UserInterfaceOnly parameter is set to true, VBA code can modify protected cells. Note however that this parameter does not stick. It needs to be reapplied each time the file is opened.
This question was answered well at Can you encode CR/LF in into CSV files?. Consider also reverse engineering multiple lines in Excel. To embed a newline in an Excel cell, press Alt+Enter. Then save the file as a .csv. You’ll see that the double-quotes start on one line and each new line in the file …
From other forums, I have learned that it is due to the MS Update and that a good fix is to simply delete the file MSForms.exd from any Temp subfolder in the user’s profile. For instance: C:\Users\[user.name]\AppData\Local\Temp\Excel8.0\MSForms.exd C:\Users\[user.name]\AppData\Local\Temp\VBE\MSForms.exd C:\Users\[user.name]\AppData\Local\Temp\Word8.0\MSForms.exd Of course the application (Excel, Word…) must be closed in order to delete this file.
No, but you can create a naive one simply enough by adding the following to a VBA module: Public Function printf(ByVal mask As String, ParamArray tokens()) As String Dim i As Long For i = 0 To ubound(tokens) mask = replace$(mask, “{” & i & “}”, tokens(i)) Next printf = mask End Function … =printf(“Some …
Unfortunately there is only the function setColumnWidth(int columnIndex, int width) from class Sheet; in which width is a number of characters in the standard font (first font in the workbook) if your fonts are changing you cannot use it. There is explained how to calculate the width in function of a font size. The formula …
XLSX files are just ZIP files, so unzip them using your favourite ZIP tool.