Programming

update links - source file open
Is there a way in VBA to detect if the source file for a specific link is open? ... 18 Mar 2010 15:31

Opened applications
Hello, Would it be possible to list all the opened applications/windows that a user sees in the taskbar? I know how to list the running processes, but two windows can have the same process. Thank you in advance for any suggestion. Regards ... 18 Mar 2010 16:39

show download progress to user
i have an excel file that needs to import an mdb file from a server to the users computer. I would like to give the user a Progress bar or window that shows the % complete or the blue boxes you get when you download a file from a web page. the purpose is to give the user a clear indication that a file downloa... 18 Mar 2010 16:39

need help writing a script Hiding a range when a cell with in is greater than 53..
Hello there I have made a worksheet where its calculate the wages etc containing 53 payslips. As you know there are 52 (+special 53 i.e 2~3 days) weeks in a year so when a user wants to calculate their wages say from WEEK 11 it calculates all the way down to week 63. I have named all the payslips as ps1,... 18 Mar 2010 13:01

appXL = CreateObject("Excel.Application")
Hi Both Excel 2003 and Excel 2007 are installed on a subset of machines How to control the object version open when this script line is executed ? Set appXL = CreateObject("Excel.Application") The test on two machines shows that it is the xcel 2003 (version 11.0) that is opened, the same one you get if you ... 18 Mar 2010 14:22

ActiveWorkbook.PivotCaches.Create in Excel 2007
Hello, We just upgraded to 2007 from 2003 and now my pivot tables don't get create. I get an error: Type mismatch when calling Create. Set pivotDataRange = dataSheet.UsedRange ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=pivotDataRange) Is there a change that no longer allows a ra... 18 Mar 2010 09:21

Pull data (sumif?) from an external workbook
I have a workbook "report". Col A has contains products. The number of products in column A may vary but each product features only once. eg: TOTAL SALES FOR JANUARY ColA ColB ItemX 4 ItemY 5 ItemZ 4 Another workbook "sales" contains the individual sales of these items in one... 18 Mar 2010 05:58

Create a list of pre-named tabs
Hi, Wondering how to create a list of pre-existing tabs in a workbook. I have a book that has appx 100 tabs and I want to create a list of those tabs on one sheet. Is there an easier way then doing this manually? The tab names keep changing every month and I need to get a quick inventory of what's in the bo... 17 Mar 2010 23:26

Create Hyperlink in VBA
Excel 2002 / 2003. I'm trying to create a hyperlink in cell A19 such that the result opens in a new window. I'm using Range("A19").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="c:\test.htm", NewWindow:=True, AddHistory:=True I'm getting Runtime Error 1004: Application defined or Object d... 18 Mar 2010 13:01

Filling right header/footer with barcode
I have an access 2000 app that generates an Excel report for my customer. everything works fine except the code i'm using to write the file name into the right header. the file name must be in both normal font and 3 of 9 Barcode. the file name in normal font is good but the barcode does not scan. i have pos... 17 Mar 2010 12:31