Recent content by goncalo

well it depends on the entry time below ill post 2 images the first one is the block of information we paste onto the file before we run the macro and the second image is the output after the macro is ran(ill circle around a case where the leave time is not displayed correctly) As you can...

Hello everyone i recently got sent the following code Sub ENTRADAS_SAIDAS() Application.ScreenUpdating = False 'Beginning Range("A1").Select Rows("2:2").Select ActiveWindow.FreezePanes = True ActiveWindow.Zoom = 85 ActiveWindow.DisplayGridlines = False...

I ended up indexing alot of the fields and that fixed it! it went from needing to wait more than a minute to it basically being done instantly Thanks Minty,plog and Doc!

it could very well be a query issue but like, on that other workbook that im using to retrieve information i use almost the exact same queries (sometimes even more complex ones) and it takes around 2-3 seconds for the information to appear that database doesn't have as much information it...

by "this one" i meant the entire code block in general, not any specific query i was also comparing this code block to another block of code that i have in another workbook since the code that i have in the other workbook is also similar to this once although it retrieves information from...

thanks doc,ill give it a look!

Hello everyone I've been recently using this code to get information from some of the databases at the company im interning at. This is the code im currently using: Private Sub Worksheet_Change(ByVal Target As Range) Dim userInput As String Dim conn As Object Dim rs As Object...

well i asked it here because its been almost impossible to find any info on any other site,and since people here have been able to help me out alot with my problems thought i should try here :) I came across that site but i dunno why it doesn't let me create an account,always says "Server error"

Yep,and that does not help me at all If anything it makes me even more confused cuz like i said i have no idea how to use CATIA or how CATIA arguments are supposed to be made in VBA soo imaginary code doesn't really help me here XD Ill keep on trying to search for information about this topic though

Hello everyone Im currently writing the code below (there's more stuff upwards and down but its not relevant to this section of code) but now i've encountered an issue i don't know how to fix i want to make a piece of code that analyzes from I3- AL and finds me the max and min value in each row...

the error i get when running the code occurs on this line Dim face1 As HybridShapeFaceExplicit and the error is a "user-defined type not defined" error. Ill give those forums a look and see if anything can help me out

Hello everyone I am in need of assistance in making a macro for CATIA V5 i do not know almost anything about this program but i was asked to make a macro in VBA that when the user runs it will insert the biggest possible sphere inside of the model that was opened,regardless of what model it was...

a bit weird but hey its working now

well i guess i got it working the lock for project viewing was NOT selected,i selected it and put a password,deselected it and it then worked! Thanks Uncle Gizmo!

I tried doing this and yet the References button is still greyed out... Could it be that the CATIA license that the company i work for uses is blocking the workers from adding libraries to CATIA?