Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ChanTheManCan
- Order by date
-
Some text formatting may have been changed in this file because the ma
Try using "Format Painter" to make the cells that have the exact cell format to reduce the # of font/colour scheme used. ie. if cell a1 and a2 are bold & green and you apply the format separately, Excel will count them as 2 formatting. If you format a1 then paintbrush it to a2, Excel counts it...- ChanTheManCan
- Post #9
- Forum: Microsoft: Office
-
Open an URL file using IE using VBA
Thanks PHV Pasted code and Got Run time error message : Method 'Run' of obj 'IWshShell3' failed I'll try again tomorrow.- ChanTheManCan
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Open an URL file using IE using VBA
I copied this via IE shortcut property's URL : https://intranet05.companyname.com/ibi_apps/WFServlet?IBIF_ex=ifsrload&R1=ifsl200%20&SCENARIO=2&LAUNCHED=N&COMPANY1=0019.... It's long..more than 1300 characters. Insert Hyperlink and object doesn't work bacause of 256 chars limitation. I tried...- ChanTheManCan
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Need Help with Automating Excel Spreadsheet
I hope this help...It works like a charm for me. From Bill Jelen's Learn Excel from Mr Excel...... "Copy Your Pivot Table For Every Customer Szilvia Juhasz of Los Angeles-based XSil Consulting passed along this excellent trick for pivot tables. Create a pivot table with customer as a page...- ChanTheManCan
- Post #7
- Forum: Microsoft: Office
