Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Why is the DatePicker control changing Sizes when I re-open File?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Why is the DatePicker control changing Sizes when I re-open File?
Dear Excel Expert. My datepicker control in my Excel App (=EMBED("MSComCtl2.DTPicker.2","") appears very large every time I open the file. I am using Excel 2003. When I go to design view and adjust it, it stays the correct size but when I re-open the Excel file it's very large again. ...

Excel Help Forum - Excel General: Automatic Goal Seek

Feed2Mail notification - new post on Excel Help Forum - Excel General
Automatic Goal Seek
Hello everyone, I was wondering if anyone could help me with my Goal Seek problem. I have to manually set goal seek by opening the menu and selecting the cells every time I want to set a down payment or backward calculate a profit rate from a specific installment value. This gets rather hectic...

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