Microsoft Visual Basic Automation Error
Our take
I'm an intern in a MNC. I have to use a design calculator that is built in Excel (Idk we could do that). The calculator works for my senior employees who have shared me the same file they're using but it doesnt work for me.
please refer to the images here & here
It has all macro script, some VBA project.. I'm not aware with excel features.
we use the same excel version, same macro settings, I tried restarting my laptop, running solely the excel file, still it doesnt work.
I already rasied a ticket for the issue, but they dont seem to have a soln as well..
I'm stuck! My project is halted without the calculator working. Even my senior employees couldn't figure out whats wrong with it...
The calculator in the excel was built by employees of my organisation itself.. but i can't contact them anymore because they're no longer in the organisation.
When we hit 'Run Form', ideally it should run and a new dialogue window should pop up with input parameters and stuff.. but I get an error instead.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Visual Basic Error when using MacrosHello Community, we got some excel file with macros from an agency we work with. On domain users in our network it brings this error: Microsoft Visual Basic for Applications File not found: C:/users/(username)/appdata/local/temp/*.tmp Those files mostly begin with VB*.tmp This error doesn´t occur on local users / domain-admins I have already worked through all excel gpos regarding macros and safety. I have already marked the file as safe and also the network directory in which it is stored. It also will not work when saved locally with a domain-user (it only worked once) Maybe someone can help me. Thanks in advance! submitted by /u/Maleficent-School762 [link] [comments]
- Cant't use macros on some old excel program made for win 7Hi, before anything i want to clarify that the excel sheet that im trying to use is in spanish. The sheet makes use of macros to modify some values and simulate the action potential of a neuron, i have tried to interact with the macros on the sheet and haven't been able to, some of my friends and myself need that specific sheet for some school projects (teacher wont let us use other simulator kek). I'm using Windows 11 x64 and i've tried: - Using older versions of office (i think 2003 was the oldest) - Using 32 bit version of excel, along with the older versions. - I've allowed macros on the file and new ones i download to test - Allowed all macros from the excel menu thingy. I was going to try and install the virtualbox for Windows 7 and try that, but i have no idea on if it would work. The link to the sheet is: https://www.secf.es/index.php/docencia/simulaciones And is the one with the hyperlink that says "3. Programa POTAC en Excel (Windows 7)l" submitted by /u/UpbeatExplorer498 [link] [comments]