Recent content by Colvic

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.