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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Recognize A Destination
Hi, This is a little part of my programm's code.When opening this workbook, excel openes another workbook and copies the data out of columns B and C into the first workbook. This works without any problems on my pc. As soon as I let this thing run on another pc in the network which has also...- John26
- Thread
- Replies: 0
- Forum: Microsoft: Access Queries and JET SQL
-
Import from Bloomberg
Hi, I am working with an excel tool, which imports numerical data from a Bloomberg terminal. Unfortunely it doesn t do it correctly anymore and I want to figure out why that is the case. For import, it uses an .xla which i don t know. The unfortunate thing is that I don t know what add-in is...- John26
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Data Transformation Services
-
QueryTable Code
Very smart of me to post the first request in German. Next try. Unfortunately, my VB skills are not very advanced, yet.So, I have the following problem: Private Sub CommandButton1_Click() Application.ScreenUpdating = False LPP03aktualisieren Sheets("tbl_Buy_RE").Activate...- John26
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
QueryTable Code
Hi, leider bin ich noch kein wirklich fortgeschrittener VBA-User. Daher flogendes Problem: Private Sub CommandButton1_Click() Application.ScreenUpdating = False LPP03aktualisieren Sheets("tbl_Buy_RE").Activate Sheets("tbl_Buy_RE").Range("B10").Select Selection.QueryTable.Refresh...- John26
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
