This seems to be a common problem - lot of forums ask the question - not always an answer.
A couple of possible solutions:
OLEXP: "Send To" and E-mail Links Do Not Work Using Outlook Express as Default
http://support.microsoft.com/?kbid=306098
From another forum this post (marked as...
The Office 2000 installation could be the culprit. I recall some time ago here at work the PC/LAN support guys stressed that it was very important to first uninstall existing Word versions before upgrading to Word 2000. (this was using an automated mechanism on the network). The PC/Lan Support...
The buttons are easy
btnSave.Enabled = False
To "disable" cells you have to set the Locked property for each cell and then set the sheet to be Protected.
VBA terms to use are Locked, Protect and Unprotect
Range("A1").Locked = True
Sheet1.Protect
Sheet1.Unprotect
Spook :-j
If MS Query is not your style you could use the ActiveX objects as Skip suggested.
To open the workbook in the background:
Set XL = CreateObject("Excel.Application")
Set MasterWbk = XL.Workbooks.Open(FileName:="C:\Temp\MyMasterFile.xls")
FName = "C:\Temp\MyDataFile.xls"
Set Wbk =...
When you perform a SaveAs in Word or Excel it still "remembers" the original file - I could be wrong but I've had issues with this in the past. Maybe something to do with the temporary file in the background.
Since your using Excel you may be better off performing a SaveCopyAs then opening...
One thing to check is the UsedRange
Even blank cells in your UsedRange can take up storage/memory. Sometimes if you've delete/cleared a swag of cells or rows then the used range can still be large and artificially inflate the size of your file.
Perform a Ctl+Shift+End to see where the...
Try this formula in B1 on Sheet1
=IF(A1=Sheet2!A1,A1,"")
or
=IF(A1=Sheet2!A1,"Match","No Match")
You can then copy and paste the formula down column B and it will keep the relative references
eg. copying the formula to B4 will result in =IF(A4=Sheet2!A4,A4,"")
One possible solution is to put your hidden row above the filter row - that is, above the row with the filters dropdowns.
I'm assuming you have a header row in Row 1 of the sheet. So, if you unhide your Default Info row, cut it and insert paste it to Row 1 (then hide it again) all the...
The easiest way without a macro is to Copy the formula text and paste it...
1. Double click the cell with the formula you want (eg A3)
2. Select the formula text
3. Copy it (Ctl+C, or right-mouse click and copy)
4. Paste it to your destination cell (B3)
But if you really want to use...
Note sure why DIR doesn't work except on the first one.
You could use FileSystemObject to list files. See sample code below (new bits highlighted in red)
Note
- there's a check to make sure it's a Word document before opening it the Word application.
- For loop is used rather than While...
This all depends on the string in the first use of DIR.
The initial use of DIR should be for path only. Path and document name only returns that filename string and subsequent use of DIR returns nothing.
And make sure the FIRST use of DIR includes path only with "\" at the end of the string to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.