debug

Hi i have the following error -2147418104 (80010008) automation error - the object invoked has disconnected from its clients ,but this error occurs very rarely after 70-100 data entries for few people and rest they don't encounter this problem, does anyone have solution for this ? please help...

Hello, I have the below code to extract data from a certain excel file (xlsx type) but I want to include two things in the macro. 1) The macro should directly open a certain folder directory for me to select the file from for example: "C\My Documents\" 2) And two if I press cancel instead of...

Hello there. Here I am again hoping to get some help with something you may consider a piece of cake :) The code below opens a windows with the suggested file name and format. If there is no file with the same name in the folder and the user clicks on "Save", then everything works great. If...

Hi everyone, I have written several macros to grab data from an external source and copy it to the open workbook but occasionally the exact same codes runs into the Run-time Error 1004. The setup is I have around 20 Workbooks each which have the below code within them referring to a single...

Hi, I need some help here. Previously it was working fine with the exact same code. And lately, it has been showing runtime error 1004 with the highlighted as per below. I have no idea what is wrong when there was no change from the previous. Please help.... Sub SaveInvWithNewName()...

After running the code, its shows "the remote server machine does not exist or is not available". Could anyone offer help on reviewing my code. Many thanks. Sub CopyFilterResult() ' This loop repeats for generate multiple word document by ID ' in the range Dim objWordApp As...

Hello everyone. First time post. I'm having trouble with VBA and the error that appears is 'Run-time error '6': Overflow. The place in the code that it highlights is in red below with commentary. Basically what this sheet is doing is taking production history from oil wells and organizing...

I am getting the "object does not support this property or method error" (Run Time error 438) in the bolded line below. Any reasons as to why this does not work? Dim rInitialDate As Range, rFinalDate As Range, rDateRange As Range, Calculation As Worksheet With Worksheets("Calculation")...

Hi - I'm old to programming but very new to VBA. I'm using Excel 2010 and have a pretty functional routine. Where I'm running into trouble with opening a 2nd file, copying a column, pasting the column to the original file (from which the code is being executed) and then closing the 2nd file...

I have a presentation filled with shapes that are the "wrong" kind of red (thanks Marketing) and need to make them the "right" kind of red. A few problems: 1) I don't know what the red value "3747998" means when, with the first shape for re-coloring selected debug.print...

I have a very basic code to copy "non-blank" data from one sheet and paste to another. The code is not complete yet - I am running in debug mode I get the above error. My code is as below. Sub SampleFind() Dim StrWord As String Dim Quantity As String Dim i As Long Call nrows For j = 2 To 2...

Hi, We've recently upgraded to Office 2010 and some locally stored macros are causing issues. This one is regarding a conditional formatting macro after importing data from an XML file. The code is below: Sub Macro3()' Range( _...

Hello fellow Excel friends, A co-worker of mine was helping me out with a piece of code and used the immediate window to quickly print out properties and evaluations of expressions without needing to use a msgbox. I am trying to figure out how to do just that. From what I know, all you are...

Hi All, I am trying to identify exactly what an existing macro is doing. The macro was initially written using the record function. Is there a way you can run VBA and the actual excel sheet simultaneously so that when I perform the debug (F8) I can see what impact each line of code actually has...

I am having problems getting my program to work. First, I cant get the FindMe function to work, i get the error Object doesn't support this property or method. I am not really sure whats wrong. My second problem is I have variables NB1 through NB8 defined in the main Sub and I want this...

I have taken over maintaining a legacy code base for an Excel product that uses the XLLPlus Excel addin and am having trouble figuring out how to debug into the C++ code that is contained in the xll file. The VBA project makes calls out to an xll file (compiled C++ similar to a dll file) and...

have some tables that give me information about different companies. When go to change catogry to see the other companies information it won't allow let me. It flashes up saying Run-Time Error 3024, couldn't find the file then gives me two options. to either Debug or End.<BR><BR>When i debug it...

have some tables that give me information about different companies. When go to change catogry to see the other companies information it won't allow let me. It flashes up saying Run-Time Error 3024, couldn't find the file then gives me two options. to either Debug or End. When i debug it brings...

Okay so its the vfirst time ive tried using developer tools but its been to no avail. I created a calender using the following code Private Sub Calendar1_Click() ActiveCell.Value = Calender1.Value Unload Me End Sub Private Sub cmdClose_Click() Unload Me End Sub Private Sub...

hi Everyone, Do you know how to list all the class module variables along with their "current" values during run-time? This is similar to lookup the variables on the watch panel during run-time, but I am trying to list all of them to a worksheet using VBA. Maybe I am not using a good enough...