Launchbar copy number without commas12/11/2023 ![]() ![]() ![]() With little adjustments it solved my problem! I also posted the question in the portuguese speaking community of stackoverflow and got a very helpful answer. PS = As you can see I've tried to set the decimal separator to "," as suggested in this link: Pasting decimal numbers in excel / comma and point decimal separator but it didn't work either! MsgBox "The application, " & myShell & ", was not found", vbExclamation, "EES DDE" MsgBox "Unable to initiate connection to EES", vbExclamation, "EES DDE" The code is shown below: Private Sub cmdDDE_Click()ĬhNumber = Application.DDEInitiate(app:="ees", topic:="")Īpplication.DDEExecute ChannelNumber, ""Īpplication.Paste Destination:=Worksheets("Sheet1").Range("H2:O1440") However, when I set the code to perform this task numbers such as "15,47" are pasted in excel as "1,55E+12" or "1547421377050". The problem occurs when the data is pasted back in the excel spreadsheet: the code seems to be neglecting the decimal separator! Both my excel and EES are set to work with the comma as the decimal separator and when I manually copy the results from EES and paste then to excel the number is pasted normally, with the comma (also the numbers from excel are correctly pasted into ESS). Since I'm new to vba, I've used the example provided by EES (Executing EES Macro Commands from EXCEL) as a guideline. This data is then copied and pasted back in the excel file that contains the input data. Then an EES code is run to solve de table, generating columns of output data. The code aims to copy a set of columns of an excel table and paste it in a parametric table in the EES (Engineering Equation Solver) software. I'm trying to write a vba code using the DDE method. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |