Any function to insert the ActiveWorkbook path on cell? I mean, any time you load the excel book an write automaticaly in the cel the new path activeworkbook.path
Do you know a way to create an alias for the username section of the file path. Similar to the path you extracted, my organization shows the individual usernames near the beginning of the string. I created a macro that will copy and paste data from a template into a new workbook and save the new workbook as a defined cell reference. It works perfectly for me but my coworker cannot run it on her machine.
You would need to add some error handling. How I would research the.problem is write a simple macro that checks for an Alias or username on their PC and prints it in A1. Then you will be able to isolate if the error is the alias. The other thing to check is permissions on the folder
I don't code. A former employee created a macro that imports orders from Amazon. I have opened that macro in my own PC but when I want to import data myself it tells me something about a path. I'm sorry for the vague wording and explanation to the issue. Anyway, how do I create the right path so I can continue using this system? Thank you
Hi,. thanks for the video. Can you please help me to detect the error that it is triggered in the last line: ThisWorkbook.SaveAs Filename:=nombreFichero Sub backAuto() RunTimer = Now + TimeValue("01:00:00") Application.OnTime RunTimer, "backAuto" 'nombreFichero = "c:\temp\Excel\" & Year(Date) & Month(Date) & Day(Date) & Hour(Time) & Minute(Time) & Second(Time) & ".xlsx" nombreFichero = "f:\davidtemp\" & Year(Date) & Month(Date) & Day(Date) & Hour(Time) & Minute(Time) & Second(Time) & ".xlsx" MsgBox nombreFichero ThisWorkbook.SaveAs Filename:=nombreFichero End Sub
Thanks a lot. It's great than other to me.
Thanks for this video. I wonder whether can I get the name of the WB which I have saved from?
Any function to insert the ActiveWorkbook path on cell? I mean, any time you load the excel book an write automaticaly in the cel the new path activeworkbook.path
Thank you!😀
So can i make an if statement to this? For if the the file path to my path then ill put msg box then close the. App
Yes within your for loop you will need and if statement and the code inside the if statement would be
If ...
Msgbix ...
Exit suc
End if
Great
Thank you
Do you know a way to create an alias for the username section of the file path. Similar to the path you extracted, my organization shows the individual usernames near the beginning of the string. I created a macro that will copy and paste data from a template into a new workbook and save the new workbook as a defined cell reference. It works perfectly for me but my coworker cannot run it on her machine.
The template file is saved in the same folder as the output file but our file paths are different due to our usernames.
You would need to add some error handling.
How I would research the.problem is write a simple macro that checks for an Alias or username on their PC and prints it in A1.
Then you will be able to isolate if the error is the alias.
The other thing to check is permissions on the folder
I don't code. A former employee created a macro that imports orders from Amazon. I have opened that macro in my own PC but when I want to import data myself it tells me something about a path.
I'm sorry for the vague wording and explanation to the issue. Anyway, how do I create the right path so I can continue using this system? Thank you
I would open up file explorer where the files are on your PC and replace the old path with the new path on your pc
Hi,. thanks for the video. Can you please help me to detect the error that it is triggered in the last line: ThisWorkbook.SaveAs Filename:=nombreFichero
Sub backAuto()
RunTimer = Now + TimeValue("01:00:00")
Application.OnTime RunTimer, "backAuto"
'nombreFichero = "c:\temp\Excel\" & Year(Date) & Month(Date) & Day(Date) & Hour(Time) & Minute(Time) & Second(Time) & ".xlsx"
nombreFichero = "f:\davidtemp\" & Year(Date) & Month(Date) & Day(Date) & Hour(Time) & Minute(Time) & Second(Time) & ".xlsx"
MsgBox nombreFichero
ThisWorkbook.SaveAs Filename:=nombreFichero
End Sub
Does the folder exist?
What is the specific error that you get?