Skip to main content
525 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
-1 votes
1 answer
86 views

In the the image above, after I click the upload button, I want to store the file in my C drive. But by default it's saved in the Downloads folder. I need to store the file in a user defined folder ...
user25527959's user avatar
  • 17
-1 votes
1 answer
101 views

I am working on a VBA macro to open the Save As screen in Excel using an API call to F12 (the shortcut for the screen), and then populating the screen with the file name and location. The screen opens ...
Austin's user avatar
  • 1
0 votes
1 answer
81 views

I have been searching and searching for some codes that would do what I want, and I just can't seem to find the answer. I am creating macro-enabled templates for office use on a network server. Not ...
Jessica's user avatar
  • 3
2 votes
4 answers
151 views

I am trying to write a program that allows you to save a sheet in a workbook to a folder of your choosing. The issue is that when you run the macro and select the folder you want to save the sheet too,...
Teddy Hanna's user avatar
  • 41
1 vote
1 answer
73 views

Right now, the VBA Macro works great on 'my' PC be/c I have it saving as a specific file to my download folder. I need this to work on anyone else's PC that runs this Macro and have the same function. ...
Christian's user avatar
  • 33
0 votes
3 answers
129 views

I have two workbooks i use weekly. Workbook 1 is scheduling and other info. Workbook 2 is Pick ups. WB2 gets info from WB1 and then closes WB1. I like to see if there is a way to update a file ...
Rose Vittur's user avatar
  • 59
0 votes
0 answers
65 views

I have an excel macro which I use to strip formulas / delete sheets from a workbook, then open a save as dialog box with the desired file name pre-populated - this works fine on PC but falls over on ...
Chris M's user avatar
  • 23
1 vote
1 answer
4k views

Not long ago I could print a python notebook from Google Colab using File/Print/Save as PDF. Since about a week I noticed, that only the some part of the document (visible or around the actual cell) ...
Feleki's user avatar
  • 41
1 vote
0 answers
89 views

I need to have a read only Word macro File that makes the user save it first as what ever they choose the name to be as long as it doesn't override the read only file. It also doesn't matter if the ...
Matthew Redhouse's user avatar
  • 11
0 votes
0 answers
60 views

Im trying to SaveAs a file that is stored on a server in a different file format. The sub folders that the file is stored in on the server wont be consistent so I cant simply write the path in as a ...
Oliver Prevost's user avatar
  • 1
1 vote
2 answers
75 views

I am trying to do a loop to save a file with different names located in a column of cells. The code saves. How to get it to continue going down to "E5"? Private Sub Save_Click() Dim ...
MixtecIndio's user avatar
  • 11
0 votes
1 answer
120 views

I have made a model in QGIS graphical modeler builder that outputs multiple vector layers. Each vector layer has data i need in excel. I would like to put them all in preferably one excel file ( each ...
Mees's user avatar
  • 1
-1 votes
1 answer
52 views

With the code below, objwkb.close works for me, Set rs= currentDB. Openrecordset("dynamic_query", opensnapshot) Set objxl = CreateObject("Excel.Application") Set objwkb = objxl....
Kingsley Obeng's user avatar
  • 150
0 votes
1 answer
240 views

In Word 2007, I created a Macro-Enabled Template that uses Form Fields with various calculations/formulas. I am trying to automate the .SaveAs based on the input of a text box from a UserForm with a ...
tlw's user avatar
  • 7
0 votes
1 answer
49 views

I want to prompt the user with the SaveAs dialog when exporting a specific Selection of cells as a PDF. I found the method .SaveAs but I struggle to understand how to use it for a specific range of ...
Michele Cordini's user avatar
  • 117
0 votes
1 answer
150 views

I've created a macro in Excel to open a Word docx, swap out some content, and then I want to save as a new word docx as well as create a PDF. I have everything working except for the saving a new Word ...
GRANT SCOTT's user avatar
  • 1
1 vote
0 answers
522 views

I am creating a project in which i want to export notes of people(people edit it using novel.sh editor) to a pdf. I tried using a lot of pdf npm packages but nothing seemed to match my needs. What ...
Sabaris's user avatar
  • 41
1 vote
1 answer
125 views

I have run a Latent Class Analysis using the Stepmix package. 'model.fit(dataframe)' gives me a perfect output in the terminal. But I need to save it to a file, preferably an Excel file after ...
CORals's user avatar
  • 69
0 votes
2 answers
59 views

I have a workbook with a script which save an excel document with the filename on 2 different locations. I have tested and tried the script and it worked perfectly. Today I used the same script for 3 ...
DutchArjo's user avatar
  • 359
0 votes
1 answer
272 views

So I have an Excel VBA Macro that helps me save the workbook as a PDF...it is called like this... Application.ActivePrinter = FindPrinter("Microsoft Print to PDF") It will successfully open ...
Brian's user avatar
  • 73
2 votes
2 answers
735 views

I am trying to use SwiftUI's the .fileExporter modifier with an item that confirms to the Transferable protocol for multiple types like this: FileRepresentation(exportedContentType: .pdf) { (item: ...
Daniel's user avatar
  • 1,126
1 vote
2 answers
897 views

we have a xlsm file that processes some data and finally saves the file as xlsx in a different folder. earlier the save prompt when saving as non-macro workbook would have 3 options: "yes", &...
Martin's user avatar
  • 121
1 vote
0 answers
90 views

Observation / Issue Expected and desired: With a file open from a folder on a drive letter C: D: etc whether mapped or local, the "Save As..." function will open the save dialog in the same ...
Nate's user avatar
  • 248
0 votes
1 answer
473 views

Sorry if this is a very basic question. I’m learning Python and the task at hand is to try using the terminal to run a python script located on my desktop. I could only find tutorials on windows, ...
Seb's user avatar
  • 1
0 votes
1 answer
119 views

I`m trying to save all the worksheets from the workbook as one single pdf (all sheets combined in one pdf) except for two worksheets that are not needed in the pdf which have the names of "Raw&...
Josue Criollo's user avatar
  • 21
-2 votes
1 answer
150 views

Is it possible to create a download form data to local machine without writing it to a file one the server? I want to click export button on form and have "save as" file dialog popup, that ...
Nigel's user avatar
  • 145
1 vote
1 answer
171 views

I wrote code to highlight some keywords from a txt file and save the output in a docx file. The output is coming perfectly, however, when I tried to save the file, it showed some errors. The code is ...
rabby26's user avatar
  • 13
0 votes
2 answers
619 views

I’m trying to create a program that reads and analyzes an excel file(.xlsx), creates a summary table, then saves that table into a new .xlsx file. I’d like to have an input prompt ask me - “Filename?” ...
LearningPython48's user avatar
  • 1
0 votes
1 answer
427 views

I have created the following list of files: require(writexl) write_xlsx(mtcars, 'PQ_ele_com.xlsx') dir = c('com', 'set', 'rit') init = c('PQ', 'MG') inpst = c('_ele_', '_mel_', '_col_') for (i in dir) ...
12666727b9's user avatar
  • 1,147
0 votes
1 answer
2k views

I'm creating an Electron app where the user creates and works on a "project." I'm trying to implement a "Save" button so the user can save their progress. I think there are two ...
Andy's user avatar
  • 83
0 votes
0 answers
759 views

I'm trying to write a program using Selenium which can continually loop through a webpage, click on dropdown menu links based on the town, month and year which opens up a web-based pdf. From there, I ...
1ntrospective1's user avatar
  • 1
0 votes
1 answer
226 views

I have an excel workbook where there is continuosly created new worksheets. Sometimes some of the worksheets needs to be archived and ideally removed from the workbook. The worksheets also needs to be ...
Jens Peter's user avatar
  • 3
1 vote
0 answers
29 views

I am a GO beginner and need sone help. I am trying to implement a save as w32 function in my shopping list project that i am doing in my school. Is this even possible? When i choose the function in ...
kiko46's user avatar
  • 11
0 votes
1 answer
2k views

I run the code, it asks if I want to save the workbook to the location, I click yes, and then the code ends. I check the folder, the file isn't saved there. I am posting the relevant sections of code ...
DDGBjorn's user avatar
  • 3
0 votes
1 answer
689 views

I am trying to save data coming from XL sheet1 to a word document (embedded in this XL file on sheet1) and save this document on my desktop. The word document is only 8 pages. I would like to save ...
JLuc01's user avatar
  • 187
0 votes
0 answers
435 views

Background: An XML file is to be loaded* into a web app. Various parameters are changed there. The file is then downloaded again. Depending on the browser settings, the modified XML file is either ...
Frederick Bulsara's user avatar
  • 13
0 votes
1 answer
5k views

I am trying to build a macro that save excel file to sharepoint based on cell value. I have two cells that: *the sharepoint path is copied from Teams using copy link. "A1" = sharepoint path ...
MASS_PANIC's user avatar
  • 21
0 votes
0 answers
173 views

I have a macro, and I am struggeling with saving. The macro: opens second workbook from SharePoint unprotects it unprotects a sheet in the original workbook copies line(s) pastes those line(s) in the ...
Kristyna's user avatar
  • 1
0 votes
0 answers
47 views

I am having trouble with the .SaveAs and .Close methods. The code will produce a fileName and a directory, but I am unable to save. I receive a method fail pop-up. I would appreciate any help. Thank ...
Austin Eveland's user avatar
  • 5
0 votes
1 answer
99 views

I have an old program (15 years old?) that generates HTML attachments to emails. Basically, contract details get attached, along with signatures. The company wants to now send PDF attachments ...
GMamunes's user avatar
  • 1
0 votes
1 answer
3k views

I have used mail merge to pull data from excel into a word document, I have then used finish amd merge, edit individual docs, all. On the created doc I want to split this in to separate docs by page ...
Greg's user avatar
  • 3
0 votes
0 answers
319 views

I am new to web development so please be patient. I need to automate downloading a CSV file from an online location service every half hour. I am using Delphi 11.2 and WebView4Delphi. I can navigate ...
Gary Shelton's user avatar
  • 153
2 votes
0 answers
155 views

I have implemented a screen recording feature into our webrtc conferencing app. (Normal MediaRecorder API) I am using FileSaver.js to save the recordings. Everything is working just fine. I was ...
Exlord's user avatar
  • 5,439
1 vote
1 answer
509 views

I want to save my textbox1.text in a notepad of my computer. And after saving that, I will save the next textbox1.text again. But I want it to be added to the same notepad. Anyone can help me on the ...
Newbie TJ's user avatar
  • 35
1 vote
2 answers
613 views

I've written a spreadsheet for a small company, that has several useful functions including performing the shift rotation for their full- and part-time employees, generates a list of possibly ...
Masked Coder's user avatar
  • 280
0 votes
2 answers
330 views

I need to assign new macro to new Bottom in new File with VBA in Excel In other words, I want to create a new file on pressing a button (run a macro) that contains a button that will run a predefined ...
Iman FalizkaranYazdi's user avatar
  • 1
0 votes
1 answer
157 views

I have a project where I am opening Excel files and saving them in a different folder. All is well until SaveAs is called. I am able to save the file, but I am not able to SaveAs. I am calling ...
Barneke's user avatar
  • 1
-1 votes
1 answer
535 views

The code keeps producing this error seems to be this line " xlBook.SaveAs Filename:="Template 1", FileFormat:=xlOpenXMLTemplateMacroEnabled " trying to run an external VBS script ...
Yaki Just's user avatar
  • 1
1 vote
2 answers
3k views

I need to recover an entire sheet of all files in a folder. My macro goes through them one by one and picks it up. I have xlsm files that show me a warning pop up, because there are macros and "...
Akael's user avatar
  • 61
0 votes
0 answers
130 views

My code creates a new Excel file, and gathers data into it. Then it should save it into a specified folder (on the hard drive), with a specified name. The path - with the file name at the end - is ...
Alen's user avatar
  • 1

1
2 3 4 5
…
11