macro to open file

[drek1234]

Dear,

I got a button on my form when you click on it , it should check if the file already exist, when it exist it should open the file,
when it not exist it should make the file and open it.
the filename should include the weeknumber and the date, but it does not work

Please Login or Register  to view this content.

[AliGW]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(I have done it for you this time - next time you must do it yourself.)

[drek1234]

sorry did not see it, next time i will put it between quotes

[davsth]

Please Login or Register  to view this content.

then run the vba code using the function

Please Login or Register  to view this content.

[AliGW]

sorry did not see it, next time i will put it between quotes

No, not quotes - use code tags (# on the toolbar). Thanks.

[drek1234]

Thx buth if i paste the code in my sheet nothing happens if i click the button,
sorry i am not goog in this

Please Login or Register  to view this content.

[davsth]

Is the code linked to the button?

can you attach the file
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[drek1234]

i hope the attachment is include, we got 3 machines and we wanna know who use the machine and how much
so in first excel menu we click the button and in the directory of the machine we have to open a new excel
file where the user must fill in the data, for every weeknumber there must be a new sheet with weeknumber
and dateso if it exist then the button should open it, if a new week begin it should make a new sheet

[davsth]

It works for me, I assume your security levels allow macros to run?

[drek1234]

macro's are enabled so you can open a new file or create ? then going to check it again

[davsth]

Yes it runs fine!

[drek1234]

yes stupid me the msgbox file exist was gone so i thougt nothing happens
thx very much it works; is it possible to place a button on the new sheet
with a macro when the new file is load ?

[drek1234]

Ok im a found more things to make my sheet now i can put a button on the new opened worksheet what i dont find
is how i can click on the new button and close the new work sheet and save it with the new buttun "called" testbutton
I also can put data to a cell in the new open file, can someone help with that button ?
Thanks in advantage

Please Login or Register  to view this content.