Upon discussion in chat as I suspected the error was not with Application.GetSaveAsFilename but something else.I would recommend seeing this thread which also addresses your problem.That being said click on Jobs List tab, and click on Update PO Tracking.
Provide details and share your research But avoid Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience. Not the answer youre looking for Browse other questions tagged excel vba macos or ask your own question. I have tried: Application.DefaultFilePath hqserversharedFinancePayroll ACH Files and Application.DefaultFilePath H:FinancePayroll ACH Files but neither seems to change the folder the GetOpenFilename looks in. For a better experience, please enable JavaScript in your browser before proceeding. Getopenfilename Default File Path In Code Below WhichI have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort. Im hoping someone will be able to point me in the right direction with a problem Im having with a SUMPRODUCT. I have a table of data that can be of varying lengths and widths. I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |