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 gkittelson 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: johant1957
- Order by date
-
error 1004 runtime error
this is my code. I try to fill in a cell in the current excel-sheet. I work with two workbooks, one is the import-workbook, I have to do some calculations, and the "start"-workbook, where I have to fill in the results of the calculations. Set wbWeek = ActiveWorkbook intSheetNumber = 1 If...- johant1957
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Find files in directories
Hi, Here is the code: Dim dlgOpen As Dialog Set dlgOpen = Application.FileDialog(msoFileDialogOpen) dlgOpen.Show Kind regards, Johan- johant1957
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Find files in directories
Hi, Thanks, but I did try this, saw it in the help-files, used it in my code, but get errors. Then I get a message like "Type Mismatch". Johan- johant1957
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Find files in directories
Hi, I have entered the code for showing me a directory list when I want to import an excel file. But I can only see Maps, no files. Can anybody help me so I can see and select the files I want to use? CODE: Sub Show_BrowseDirectory_dialog() Dim dirInfo As BROWSEINFO Dim path As String Dim r...- johant1957
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
