View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Spaces in folder name and file name

I wonder if there is an additional space (or something) that you are not
seeing in the path and filename.

Using the workbook with your code, in VBA open the immediate window (menu
item View-Immediate Window or Ctrl + G)

Open the required workbook and ensure that it is the active workbook.

Select the VBA window and in the Immediate Window insert the following and
then press Enter.

Debug.Print ActiveWorkbook.Path & "\" & ActiveWorkbook.Name

Copy the returned result and paste it into your code between the double
quotes in lieu of the path and name you have used.

--
Regards,

OssieMac