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!
-
Access/Excel question
Also, forgot to mention, why do I have to open Excel Data manually to refresh the data? The data in all sheets are not automatically refreshing unless I manually open it. Please help. Thanks, Sean- GTPSean
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access/Excel question
That works... Thank you SO much mate! Only thing is, I'd like to surpress the dialogue that states that the file already exists, replace? I wanna save it automatically. Any suggestions?- GTPSean
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access/Excel question
Private Sub Command33_Click() On Error GoTo Err_Command33_Click Dim xlApp As Excel.Application Dim xlWkbk As Excel.Workbook Dim xlSht As Excel.Worksheet Set xlApp = New Excel.Application xlApp.Visible = True Set xlWkbk = xlApp.Workbooks.Open("C:\Users\Desktop\Data Entry System.xls")...- GTPSean
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access/Excel question
Hello mates, Hope that all is well. I would like to ask for some assistance with this, because i've been pulling my hair out fighting with this. I'm writing a little database that involves both an Access Data Entry.mdb and Excel Data Entry.xls. Access Data Entry has a process where I am...- GTPSean
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
