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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Path Name Nightmare
Help! Some bright spark is moving our server and we have to change any UNC references (//Server name/path.....) to 'drive letters' 'G:\Path.....'. I've inherited a suite of db's which have UNC's all over the place (modules, forms, you name it, its got it). Does anyone have a (relatively) easy...- Store300
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Delete Excel Links
Ok, this is getting desperate. Does anyone know of a way of deleting Excel Links between workbooks? Preferably through VBA but right now I'll settle for manually hunting the little darling down. All suggestions gratefully received. :( Store300 Store300@ftnetwork.com- Store300
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel Pivot Table Automation
I have a macro which automates the hiding of 'page' elements in a pivot table. The trouble is that the pivot table recalculates after each element is hidden rather than waiting until all the selected elements are hidden, slowing the whole process down considerably. Does anyone know of a way to...- Store300
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Building CSV's from Multiple Workbooks
I am trying to build a csv from 150 seperate excel workbooks (all identically formatted with an extraction range). Does anyone know of anyway to do this without actually opening the workbooks in question as its the slowest part of the process? I'm currently using a loop to enter a link into my...- Store300
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
