Hello,
I am working on creating a makro for excel. I want it to check if a specific other Excel workbook is already existing. If so I wanted it to be opend and a few specific fields to be automatically filled from the first workbook. If it does not exist already I would like excel to create the new workbook based on a specific format and be filled from the inital one.
Now to my problem:
So far I tried it with a simple code, which was lost again... So I´m slightly out of my depth, since it has been a few years since I actually coded anything.
I wanted the check to take place in a certain folder and the additional workbooks to be created in the same one as well.
I know it is a lot to ask, however could anybody help me?
Sub Onepage()
If Dir("C:\\stuff\x.xls") <> "" Then
'I can not find the command I used here
Else
'not sure what I used here
End If
End Sub
Thank you!
I am working on creating a makro for excel. I want it to check if a specific other Excel workbook is already existing. If so I wanted it to be opend and a few specific fields to be automatically filled from the first workbook. If it does not exist already I would like excel to create the new workbook based on a specific format and be filled from the inital one.
Now to my problem:
So far I tried it with a simple code, which was lost again... So I´m slightly out of my depth, since it has been a few years since I actually coded anything.
I wanted the check to take place in a certain folder and the additional workbooks to be created in the same one as well.
I know it is a lot to ask, however could anybody help me?
Sub Onepage()
If Dir("C:\\stuff\x.xls") <> "" Then
'I can not find the command I used here
Else
'not sure what I used here
End If
End Sub
Thank you!
