Is there something wrong with this macro? Im getting #REF error. I dont use vba and I got it from the internet. I believe the excel was done in Japan

Option Explicit Type GammaCY dNa As Double dRd As Double End Type Type PairEP dE As Double dP As Double End Type Dim GCY_ValArr(5) As Double Dim GammaCY_Arr(5, 13) As GammaCY ‘//0.5%, 1%, 2%, 4%,8% Sub InitModuleParams() GCY_ValArr(1) = 0.5 GCY_ValArr(2) = 1# GCY_ValArr(3) = 2# GCY_ValArr(4) = 4# GCY_ValArr(5) = 8# ‘//ƒÁcy = 0.5% … Read more

sql server – Exporting data to Excel with multiple worksheets from MS SQL Database through

My task is to import the data from the test_import table into multiple sheets of the same excel workbook. What I am trying to achieve is to fill up specific cells in the selected sheet with selected data columns that I have in my MS SQL database through VB.NET. I am currently undergoing my internship … Read more

excel – Using VBA in Userform, I have searched and found data, made changes, and now want to save the updated data back to the worksheet

I have VBA for a Userform that searches a worksheet, finds data via a combobox, and populates the controls. How do I save any updates to that data back to the worksheet? Also, my checkboxes aren’t working correctly. They don’t show what was previously checked or not checked. How do I fix that? I appreciate … Read more

excel – PowerQuery – How can i make my queries more compact or a better way to do show the same results?

Im wondering how i could make my queries be less queries. I have not created the queries inside Advanced Editor, but Ive started to look at this and try to use it more. I have a database called Source_VSLösenord, which has all tickets from a department, and another database called Source_Members which has both inactive … Read more

Contact from VS C++ to Excel VBA

May 10th, 2022, 01:00 PM #1 Contact from VS C++ to Excel VBA I’ve got an app written in Visual Studio C++ that deals with excel lines … Read more