Search results for query: *

Hi, The data is prepared in a base on the server twice every hour (real time) and this takes about. two to five minutes. The data are not available in that period. Excel spreadsheet is located locally on my computer and retrieves the data using the Data / Connections. The parameters for...

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?

Sorry that this was posted on Microsoft: Access Modules (VBA Coding) and not VBA Visual Basic for Applications (Microsoft). Thanks for your reply. I try and calculate my way to different cells in a spreadsheet and retrieve data. I use this command and find out how large the data area are...

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, I found a source that read the information I nead from the file, but now I nead a information (Source) that can write the modified information back to the file. Can you help me? Type FileAttributes Name As String Size As String FileType As String DateModified As Date DateCreated As Date...

Sorry Golom, may be I am not clear. If I use File Explorer and view properties on any file, I can go to the tag Summary and read/change the Title, Comments, Author from there. That is what I want to do from Access. But have do I handle File Explorer from Access?

Thanks Golom, but I am going to use MS Access.

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 Madawc, thank you. It works. Sorry, the sentence should be {World.Land} like [{@varLand}] In the Formula Fields "varLand" the sentence is now: stringVar Array myArray := ["Sweeden", "Denmark", "USA"]; Join(myArray,",");

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.

Additional information. I will search for StartWord and EndWord and select all text between. I will make an macro (VBA) to do this. Do you have any code example for this?

Hi fumei. Thanks for answering. I want to select all text between a start word and a end word. And then i will make a tabel or change font ect. An example: StartWord This is an text I will mark, between the start word an end word. I have look in help, but I can not find what I look for...

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...