Pages

Search

Excel IT Pro Discussions Forum: VBA: Related to Loading an .xlam file

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
VBA: Related to Loading an .xlam file

The following code works fine for office 2007 

Set objExcel = CreateObject("Excel.Application")


'This will pick the abc.xlam file irrespective of the Office as well as windows version.
objExcel.Workbooks.Open (objExcel.LibraryPath & "\abc.xlam")

--After this I will load an excel file.

But when i execute the same code in office 2010, the abc.xlam file is not getting loaded.
It has some custom worksheet functions, which are not getting displayed.

Any suggestions in this regard is highly appreciated.

Thanks,
Krishna

Excel Help Forum - Excel Programming / VBA / Macros: Error handling

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Error handling
Hi I am running a macro through a column to change the value to K or M depending on the cells value. Now I want an error handling if the conditions are not true. I want a msgbox to say that "Cell A3 don't contain a valid value" if for instance that A3 has a false value. Now ------------...

Excel Help Forum - Excel General: Problem with Record Count while in Filer Mode

Feed2Mail notification - new post on Excel Help Forum - Excel General
Problem with Record Count while in Filer Mode
Hello There, I got a small problem with filter mode. I am using excel 2003. I am in filter mode and the record count (When you filter a specific condition it shows the n of z records found at left hand side bottom) works fine for all except one condition. When I select the batch number 21...

Excel Help Forum - Excel Programming / VBA / Macros: using formula to generate values

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
using formula to generate values
I have a formula which is as follows: Code: --------- =12*NETWORKDAYS(B1,D1)-12+IF(NETWORKDAYS(D1,D1),MEDIAN(MOD(D1,1)*24,6,18),18)-MEDIAN(NETWORKDAYS(B1,B1)*MOD(B1,1)*24,6,18) --------- I want to copy this formula down my sheet until the last value in the D or B column however this makes...

Excel Help Forum - Excel General: Find criteria in range and mark the cellborders of found combination with color

Feed2Mail notification - new post on Excel Help Forum - Excel General
Find criteria in range and mark the cellborders of found combination with color
Hello, I need a solution for the following task: I have a range of numbers in a table D13:U54, the numbers in the table are 0,1,2,3,4 and appear random, e.g. D13=1 D14=1 D15=1 D16=2 D17=2

Excel Help Forum - Excel Programming / VBA / Macros: Internet Explorer Navigation

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Internet Explorer Navigation
Hi experts, It's my first time to create a module that will control/navigate an IE. Is there any tutorials or examples that I can ready/study? For example. I want to automatically input my username and password in a mail account. I have done it but I want a data validation, how can I...

Excel Help Forum - Excel General: Staining cells only text without any dates in Sheet1 itself, but taking a dat...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Staining cells only text without any dates in Sheet1 itself, but taking a date from the PC
Hi all, I have one for my very complex task imagine excel column A1: A10000: A1 to A10000 - have only text: A1 - something A2 - another thing and so on Now with my colleagues argue the following tasks and problems - he said I had (but lost it) only formula (at least in his own words) which...
Subscribe to: Posts (Atom)