Search results for query: *

Workbook Connections retrieves data from the server, but this data will be prepared twice per hour with a fixed time. It takes two to five minutes. If Excel try and retrieve the data in this period, I get the following error message: A formula in this work sheet contains one or more invalid...

I want to save the result of this code in a variable instead of cell A1 Sheets("Sheet1").Range("A2").Formula = "=RoundUp(A1, 0)" Does anyone have a suggestion? Thanks in advance

Can some help me and create a macro that picks out sentences with a particular letter combination in Excel Macro. In column A it may be sentences that contain "IT" and I wants this sentence to be shown. Ex: "is the largest IT community Have gone so far: Selection.AutoFilter Field: = 2...

How can I put color on each row in a PivotTabel containing Total Sum?

How to convert "$B$21" address in Excel to ActiveCell.Offset format?

How do I get the filename of the current file opened in PowerPoint?

Hi, Can anyone tell me how I can read and write to Property.Title .Comments .Author in a Crystal Reports.rpt file with VBA? Thanks in advance.

Hi, can someone help me with this problem? In my "Record Selection" I have this sentence: {World.Land} like ["Sweeden", "Denmark", "USA"] This sentence work fine, but I will store the variable in a Formula Fields "varLand" like this: iLand := ["Sweeden", "Denmark", "USA"] and in "Record...

Hi, Does anyone have a solution to the problem mention by ssecca (Programmer) in this thread: thread705-1122446? I have the same problem.

Hi, Can anyone tell me how I can select text in Word with VBA. I will select text between a start word and a end word. Thanks in advance.

Hi, Can anyone tell me why this code is not working. I try to sett the Weight property on lines in a Excel Graph from Access. The Chart have up to 20 lines. It works until lines no 6, then I get a error message: Unable to set the Weight property of the Border class Here is the code: Counter =...

Hi, Can anyone tell me why this code is not working. I try to run this code. It send data to MS Word, but the second times I run it, I get a error message: ' The remote server machine does not exist or is unavailable (Error 462) It stops in this segment: .Rows(1).Select Thanks in...

I get an error on this code line: xlWs.Cells(2, 1).CopyFromRecordset(rst) The error is: An unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dll Additional information: No such interface supported Can someone help me? Thanks. Using : Microsoft...

I get an error on this code line: xlWs.Cells(2, 1).CopyFromRecordset(rst) The error is: An unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dll Additional information: No such interface supported Can someone help me? Thanks. Using : Microsoft...

He, I try to make a Graph in Excel with this VBA running from Access. It is OK the first time but the next I run the code I recive the error: Run-time error '1004': Metod 'Sheets' of object'_Global' Failed When I cancel the Code, and start it again then it is OK the first time but then I get...