I am trying to put the number 20071109160737134001 into a cell in an Excel spreadsheet, but it keeps displaying it as 20071109160737100000. How can I format the cell so that it displays corre...
I have been entering data into a spreadsheet I use for the purpose of calculating montly sales commissions. Each horizontal line contains a column with sales and profit and then a column whic...
Hi,
What im trying to do is to do a sum at the last blank row of b column...My data starts from b3 onwards which can go upto b100 or b150 or anything more or less then that coz sometimes it...
Hi,
In Excel, I'd like to use the If function to create the following logic:
I can't seem to get this function to give back the proper results.
This is an IF statement that needs AND & OR...
08/12/07 09/12/07 10/12/07
Bill Withers ????
...
I have found many examples of data being transferred vide ADODB.Recordsets to MS Excel 2003, but suppose I have to work on the said transferred data on the worksheet, and I want to update that...
Hi,
I want a way to set the Excel>Properties> author name is there a way to do this.
Regards
SHarath
Is there a way to combine multiple workbooks, so that they can be emailed to someone and save them the trouble of opening each one individually. We're using Excel 2000.
I need to be able to save a Visio document from Excel.
Here is my code, which is not working correctly.
Dim VisioApp As Object, VisioDoc As Object
On Error Resume Next
S...
Hi Everyone.
How do I activate and display a userform when the user clicks on 'Sheet1' . I have code in place to close the userform so that the userform can navigate the sheets in the workb...
Hi Everyone,
I have a spreadsheet that has merged cells in it an I want to unmerge the cells and have the data expanded into the unmerge rows. To do this I have unmerged the cells and can ...
I have a pivot table that works great- until you hit refresh. Then it constantly says the "pivot table is not valid".
If I open the wizard and hit "back", the valid range is still selected...
I'm using Excel 2003. I've a cell with number format and i want to convert that number format into date.
For eg, i've 060507 should be converted to 06/05/07. How would i do this? I tried few ...
I have a rather large workbook with an immense number of calculations. At the moment, I have switched off the worksheet calculations in a majority of the sheets apart from two.
One workshee...
Hi,
How do I declare and add elements to a vba dynamic multidimensional array?
THANKS
I'm running into an error in Excel when trying to run any Jet Report. It's a popup error which states:
'No C/Front path in registry. Please remove and re-install C/Front'
Does anyon...
Hi
Would anyone have (or know the websites of) some good examples of Budget Templates.
Greg
Filed B3 contains a formula that has joined some text ( =A1&A2&A3)
B3 now contains text which i would like to be a formula...
Is there any way I can make this a formula now?
For 500pts, can you tell me what the best way to distribute macros to 20-30 networked workstations?
Criteria:
One person will be updating the macros.
The macro may not be stored in th...
I am getting an error with this code.
The error is
"Unable to set the Subtotals property of the PivotField class"
When I hit "PO" field. This field is a numeric.
The detail table has al...
Hi,
I wann to turn off Virus Scan when opening Excel files.
I have seen lots of solutions on this site that work for Norton Antivirus.
I dont have Norton Antivirus installed. I use AV...
Anyone know of a book or website link that has a good description (preferrably visual) of the Excel Object Model. I tried to refer my co-worker to MSDN, but he absolutely hates that site :-)
...
Hi all,
I have the macro below that reduces the size on an excel document, but at the moment i have to open the document first then run it. Can somebody amend the code to that it just poin...
Hi
I want to integrate a progress bar into my code but can't seem to figure out how to do it.
Here's the link to the progressbar source code...can any help?
(Its the 7th entry in the ...
Hi,
Kevin (zorvek) pointed out in another question that
ActiveWorkbook.FollowHyperlink "full\path\to\file.html", NewWindow:=True
will open a workbook.
And it does. But on my compu...
