it's definitely the space in the name
(when i removed it the code worked fine).
So my question is what to change in the code to make it working for files with spaces in their name also.
Thanks in advance
it's definitely the space in the name
(when i removed it the code worked fine).
So my question is what to change in the code to make it working for files with spaces in their name also.
Thanks in advance
Made some changes to the code so I could put the file name between an extra pair of single quotes ' ' to deal with spaces and "-" in file names:
![]()
Private Sub CommandButton1_Click() Workbooks.Open ("\\Nw_edc_02\apps1\Starquery\Werkfolder\WR\xls\aantal picks.xls") Application.Run ("'aantal picks.xls'!Updbtn_Update") End Sub
Found here: http://stackoverflow.com/questions/2...ontains-spaces
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks