Excel VBA Command Button to get Data from User's Desktop

I have a model that requires user to get data from a saved file on their desktop. The saved file is "[login to view URL]" . This will be universal for every user. It will be saved on their desktop as "Statement".

I recorded a macro to get data from MY OWN desktop and it works once i press the command button but once it gets to another PC it returns error. I need a code in the form of possibly

spath = Environ("USERPROFILE")&"DESKTOP"

Check file to see example

Taidot: tietojenkäsittely, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic, Visual Basic for Apps

Näytä lisää: excel vba access sheet data, excel vba return xml data type, excel vba update imported data, vba code to open excel file from folder, how to save excel workbook to desktop regardless of user, vba save to desktop regardless of user, vba save to user desktop, excel vba browse for file path, current user desktop path vba, vba code to browse and open an excel file, excel vba open folder and select file, excel vba speed filling data, excel vba program network multi user, excel vba browse refresh data, excel vba chart show data table, excel vba change pivot data sources, excel vba insert csv data access database, excel vba refresh sheet data, excel vba compare columns data report, excel vba dashboard project data

Tietoa työnantajasta:
( 4 arvostelua ) Lagos, Nigeria

Projektin tunnus: #19440335

Myönnetty käyttäjälle:


Hello, yes this is common request and i believe i can help you. If you are interested in working with me, please message me and i will try to help you immediately. There are few different ways for getting the deskto Lisää

$10 USD 0 päivässä
(488 Arvostelua)

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi There, I am very much interested in doing this project. I am having a very rich experience in this field. Please give me a chance to work for you. You can check my previous project feedback/Review/Rating from cli Lisää

$50 USD 1 päivässä
(8 arvostelua)

Software engineer with a postgraduate in software development and I have extensive experience in the development of web and mobile software, I have worked with business intelligence projects based on Microsoft technolo Lisää

$45 USD 2 päivässä
(0 arvostelua)
$25 USD 1 päivässä
(0 arvostelua)