Pages

Search

Excel IT Pro Discussions Forum: microsoft excel can't open

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
microsoft excel can't open

hey guys

can you assit please this is the error message i get when opening an excel file

Excel cannot open the file "VEESHAL.XLSX because the file format or file extension is not valid .Verify that the file has not been corrupted and the file extension matches the format of the file .

please assist

veeshal Annatooah

Excel Help Forum - Excel Programming / VBA / Macros: problem with converting numbers to TEXT format and applying comma style

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
problem with converting numbers to TEXT format and applying comma style
Hi all, I have a column "U" with numbers. I had to change the format of cells from NUMBER to TEXT (because the next step is moving the data to Word) and apply comma style. I managed to change the format to TEXT and then apply the comma style by using this code: Code: --------- '...

Excel Help Forum - Excel General: FIFO Inventory method balance tracking

Feed2Mail notification - new post on Excel Help Forum - Excel General
FIFO Inventory method balance tracking
I am happy to read a previous thread on the same topic and got the FIFO sample.xls file. However, I encountered a problem that when I post entries in the sold column, it is accepting any number of entries whereas it should show negative figures where the quantity is exceeding the Purchase...

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...
Subscribe to: Posts (Atom)