macro error

Can anyone help me to solve this syntax of of adding file path to TEXTBOX This is my UI form

When I change my data and try and hit the refresh button to update my tables, I keep getting a can't open PivotTable source file error. Then it asks me to debug and shows me this? How do I get my table to work again?

My macros are enabled and working fine, but everytime I open the formulas or data tab for the first time I get this message "because of your security settings macros have been disabled. to run macros, you need to reopen this workbook, and then choose to enable macros, for more information about...

My old boss has retired and I had a document cotrol sheet that opened files (any format including PDF's) from folders with the same name as the tab. since i have now been forced to use excel 2013 it does not work. Please can someone help me!!! The code is below: (I think it is somthing to do...

I am trying to use the below macro to copy HTML into IE10 and paste back into excel in a rich text format The error message is 'Run-time error '438' Object doesn't support this property or method. When I debug it appears to be something wrong with the copy line? Sub Sample() Dim Ie As...

Hi Team, I have the below code to delete these particular workbooks for example, however, in the case the user runs the below macro again & the file(s) have been deleted already, I would like to learn how one could stop the macro and then have a message displaying something like "Files have...

I keep getting this error when I run my macro.... "Cannot change part of a merged cell" I've checked my sheets and I have no merged cells..... is this a bogus error or does it really mean something else?

Hi all, i have some difficulty in understanding the purpose of both types of variables in excel macro. Furthermore, i have a problem in my codes right now, Dim TotalRow As Integer Set TotalRow = ActiveSheet.Rows.Count ActiveCell.Copy For i = 1 To TotalRow...

A question, if I may: my data, and a chart of the data, is in sheet 7 of a workbook. I have a macro that redraws the chart as the data changes. (I set some cells to generate random numbers on 'calculate' command in the macro) . The macro references sheet 7 and the data. For viewing purposes...

Hi Excelperts I have a little macro to clear the autofilter on my page. But if the filter is ALREADY clear, it gives me an error. I have to get it to just do nothing if its already clear to stop this error from popping up (as its going to be distributed to others) This is my code: Sub...

Hi all, :) <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> When my users open or close files I create for them they get the following Macro Error Box. (Some users do not get the Error Box)<o:p></o:p> <o:p></o:p> Macro error at cell: <o:p></o:p>...