I have several hundred documents that now show up with .SHS file extensions (scrap objects). When I open them, they open with Excel and I can easily view them. When I change the file extensi...
Is there a way to convert a string to an integer using VBA? I have written some nested If's inside of a loop in order to find the next available extension to use while creating a work breakdo...
This one should be easy. I need to select multiple cells in Excel. The macro recorder gives me:
Range("D11,D13,D23,D27").Select
However, I'm selecting in a loop and don't know the colu...
Excel 2003.
What I am trying to do is this. I have a spreadsheet with a header row. I know how to freeze the panes so that when I scroll down, my header row stays showing. What I need to...
Hi!
I installed Office 2003 SP3 on many PCs of my company.
When I launch Excel, the error "System Error &H80004005 (-2147467259). Unspecified Error" appears.
To close the error form I need ...
How do I delete a named range
I know in Exel 2003 you can switch worksheets with with CTRL+TAB shortcut. I have found in Excel 2007 that this is not a shortcut.
Has the shortcut changed or is my version of Excel just ac...
I need a function that will take an entire cell value in Excel and convert the value into its MD5 hash equivalent in a new cell. I have seen several comments about using VBA or other software....
Hi All-
I have a small vba script that opens and closes a workbook behind the scenes. I need to let the workbook stay open for a few seconds at most to allow for another workbook to update...
How do I with VBA copy of range of cell values to another sheet in the same workbook?
Thanks,
MV
In Excel
I have the following formula in a cell...
=IF(C5="","",(D4+B5-C5))
The basic idea is if cell C in a row is empty, then cell D will be empty also, otherwise it will fill in the form...
I have an excel document i had each sheet protected with a password, I have been succefully locking and unlock the sheet to make changes. However the last time I decide to share the workbook. ...
This is horrible if it's by design, so please let me know if there is a fix or if this is also what others are experiencing:
An Excel 2007 xlsx file is created. An Excel 2003 user, with th...
Hello,
I have an Excel spreadsheet that I need to convert into an ASCII text file where each column needs to be set at a specific width (column A is position 1-4, column B is position 5-6, co...
Using Excel 2002.
Have opened an excel spreadsheet that has on each page as a watermark in the centre of the page, "page 1", "page 2", "page 3" etc, that doesn't apear on Print preview or whe...
I have a spreadsheet that we download once a year from a source and then we go through and color code the sheet. I would like to develop code that based on a value in a cell at the end of the...
I need some code to remove any spaces in a string. I have a list of accounts in a column A and each cell has a bunch of numbers in it.
Example
Cell A1 100 00 0000 00
Cell A2 2222 2 22...
I'm not sure if I should be using the trend or forecast function in Excel or maybe even something different all together.
I have a data set for each week of 2005 and I would like to extrapo...
Hi: Can any one please tell me is there any way to stop the calculation. On every few minute i dont know what is that at bottom left start counting like:
10%, 20% upto 100% and it takes like ...
I need to make an excel macro vba to remove bad characters (special characters) in a string of text, such as (, commas, -, ;, :, !, \n, /n, etc, but I dont know the best way to handle&
I wan...
When I attempt to open two differenct Microsoft Excel files, I get an error message stating the the file format is not valid.
I am able to open these Excel files in Word.
I need to get t...
I am currently running Excel 2000 and I am sending off workbooks with simple vba codes that show userforms. Everyone who is running Excel 2000 in my company can view the workbook correctly. Th...
I have written the following vba macro to save a particular worksheet as a separate workbook.
Private Sub ExportRptCommandButton_Click()
Dim fName As String, FileNm As String
'GET THE...
I am trying to communicate with a device connected to my PC using an RS232 serial comm port. I am familiar with Visual Basic for Applications with Excel. I understand that a control (MSComm)...
Hi all,
I have an excel file, where I have some special characters (like
áí) which I want to export to CSV file.
For the export I am using vba with the code bellow. If I export the data, ...
