TableTools: In the App_SheetChange handler, I am getting 1004, Method Undo' of object '_Application' failed, when you Undo to try and collect the oldname, for the automatic update of all Queries and Datamodel.Īctually, in this instance (but there have been frequent other instances), the 2nd error has been triggered by running the 1st tool. If I open the PQ Editor, it tells me "Expression.Synta圎rror: Invalid identifier." Hence `width1 & " " & width2` instead of `width1 & " " & width2` in the userform's Initialize event procedure.Ĭomment by: Thomas (14-4-2022 23:41:00) deeplink to this commentĪ couple of issues that I have been running into with your tools for a while:Ĭompare 2 Tables, on sheet:"Modified records", the query hangs with "ExternalData_1: Getting Data. On the contrary I'm referring to the need to insert the globally valid semicolon " " between the individual column width entries (which of course have to be entered with a decimal point in VBA code). Think you might have misunderstood my post: I do Not plead for an intermediate comma "," as column withs separator. Hi Jan Karel, thanks for prompt post (as well as any of your interesting articles) Perhaps you need to convert explicitly using the Str function to get US syntax or using Cstr to get the local stringĬomment by: TM (7-4-2022 21:11:00) deeplink to this comment Your code would return a string with the windows decimal separator due to the string conversion. I think you must make sure that the string contains valid decimal separator too. In Windows, use the list separator specified in the Regional Settings section of the Windows Control Panel to change this value."Ĭomment by: Jan Karel Pieterse (7-4-2022 20:17:00) deeplink to this comment "To separate column entries, use semicolons ( ) as list separators. MS Help reference (/en-us/office/vba/language/reference/user-interface-help/columnwidths-property) specifies: I have to correct my assumption of regional differences, as you have to use semicolons in any case and not commata. Width / 2.1` solved the issue in my case. Width / 2.1` to a string joined by a semicolon via `.ColumnWidths =. ~~>Ĭhanging for both ListBoxes from `.ColumnWidths =. Trying to show the UserForm, VBA raised a runtime error -213735271 (80020005). Showing last 8 comments of 378 in total ( Show All Comments):Ĭomment by: Jan Karel Pieterse (7-4-2022 10:39:00) deeplink to this commentĪs far as I know, the separator for the columnwidths property does not change for other countries?Ĭomment by: TM (7-4-2022 19:57:00) deeplink to this comment
0 Comments
Leave a Reply. |