Programming

ping in excel
I would like to create an Excel macro to ping a list of numbers in Column A and put the result in the same row but in the active Column when the macro started Any Offers of help ? ... 22 Feb 2005 09:30

web components - msowc.dll
Two of my coworkers is running Office 2003. The rest are running Office 2000; we will be upgrading all to 2003 soon. One person running 2003 developed a spreadsheet with VB code. The macros didn't work on the other 2003 PC or our 2000 PC's. He told me to install "his" MSOWC.DLL. This caused the macros to wo... 20 Feb 2005 13:20

Changing a pivot table field items to current database
I recorded a macro that included showing a pivot field item. I have to run the macro on different databases that have a unique field item. There is only one field name in the field in a drop down box. How can I change the code below to show the field item that is established when creating the pivot table not the on... 22 Feb 2005 13:50

Application.GetOpenFilename
How do I get this code to look in a certain directory Application.GetOpenFilename Directory name ward5 Thanksin advance Greg ... 19 Feb 2005 21:23

MSHTML Objects
Dear Sirs, I am trying to download a csv file from the internet using the MSHTML model and can successfully obtain the data to a HTMLDocument variable using the following. Dim objMSHTML As New MSHTML.HTMLDocument Dim objDocument As MSHTML.HTMLDocument Set objDocument = objMSHTML.createDocu... 21 Feb 2005 04:40

Lost visual basic project in excel
When I open my workbook (excel 2002, windows xp), that contains several number of macros, I got the message "File not found" and the information in Log file is as follows: Microsoft Excel File Repair Log Errors were detected in file 'C:\Program Files\TerminalCheck\term_kalk.xls' The following is a list of rep... 18 Feb 2005 13:11

Excel was unable to load a necessary component
I'm receiving 2 different error messages that I cannot seem to find the source issue. 1. Excel was unable to load a necessary component. This component might have been damaged or deleted. Reinstall the client software or data source driver software for your database. 2. Problems obtaining data. I have un... 18 Feb 2005 11:39

VB Code or Excel macro to run Query/Import on Access file
Hello I'd like to be able to press a button on an Excel sheet and start the process of running the MSQUERY function. I tried just recording keystrokes as a macro, clicking the following while in record mode: Data/Import External Data/New Database Query/MS Access Database/Clicked on Database Name But noth... 22 Feb 2005 16:02

VBA Function
I am trying to create my own Excel function in my VBA editor and I need to know how to refer to the page numbers in any given sheet. Example: I want the variable PgNum to equal the page number of the cell that the function is in. In other words, if the function is located on page 7, I want PgNum to equal the... 18 Feb 2005 16:46

Pivot table custom formatting of group levels
Hi Danny Check out the PivotSelect method in Excel VBA help. Turn on the recorder and do it manually. It will give you a framework to modify. You'll need code something like this: ActiveSheet.PivotTables("PivotTable2").PivotSelect "CITY [All]", xlDataOnly With Selection.Interior .ColorIndex... 18 Feb 2005 02:53