11,322 questions
0
votes
1
answer
68
views
Script to copy google form data to new tab
I have no experience with scripts but found the following on here and it almost works for what I want.
function onSubmit(e) {
const range = e.range;
const srcSheet = range.getSheet();
const ...
1
vote
2
answers
59
views
Unable to copy sheet with VBA Excel under specified name
I would like to copy the Excel sheet under the specified name.
My code looks as follows:
Sub GetJoins()
Dim tws As Worksheet, jws As Worksheet, nws As Worksheet
Dim shnm As String
Set tws = ...
- 1,606
0
votes
1
answer
2k
views
VBA copy data from workbook to another based on criteria
I have 2 workbooks, one source workbook with data spread over different sheets, and one target workbook where this data needs to be copied to, on one single sheet, right below each other.
The copying ...
- 131
0
votes
1
answer
540
views
VBA Copy Paste without formatting from another workbook
I have this code which helps me to copy paste information from one workbook to another. The values get pasted with format and formulas, but I want to paste them as simple text. I have tried to add the ...
- 55
1
vote
1
answer
155
views
Copy an existing file at runtime using a relative path
I have a method which saves data into a binary file. I'm trying to unit test this method. That's why I made myself a controller binary file with the data I'm supposed to save using my method.
My ...
- 95
0
votes
1
answer
586
views
Copying CSV from adls to adls not working in adf pipeline
I want to copy the CSV files present in adlsfolder called source to another adls folder called destination through adf pipeline copy activity.
1st activity = GetMetadata
to get all the files from the ...
- 5
0
votes
0
answers
32
views
Powershell dies during "copy-item" when using rightclick->open with but is fine when opening the path manual in powershell
i got a powershell script that copies alot of files from a path with some filters.
The very odd behaviour:
When I open the powershell script using:
Rightclick->run with powershell (or doubleclick)
...
- 2,775
0
votes
0
answers
81
views
How can I solve Pandas SettingWithCopyWarning error while trying to copy a value of a column to another if other have a given value?
I have a large dataframe, and I needed to create a new columns using a formula that works with 3 different columns and assign the value of 2nd column to the 3rd if the 1st column have a given value. ...
- 1
0
votes
1
answer
232
views
Copying files from one folder to multiple other folders (all within one main folder) based on file name
I'm relatively new to python and although I can understand code (for the most part), I have trouble with starting to write code, so any help is appreciated. This is also my first time posting on ...
- 1
-2
votes
1
answer
164
views
Need latest timestamp on destination file if the source file is identical using ansible copy module
Is it possible to reflect the latest timestamp of the copy if the source and destination files are identical?
Timestamp before copy for destination and source:
destination:
[wluser@myhost7 ~]$ ls -ltr ...
- 3,195
0
votes
1
answer
78
views
I'm trying to add a fixed value in the method copy
I'm trying to add a fixed value in the method copy.
There is a csv file, but in addition to the data from it, I want to add a fixed value to the table.
In vertica there is column‑as‑expression.
create ...
- 5
0
votes
0
answers
94
views
Async folder copy with progress bar
I searched on net and have found c# code to copy file async with progress bar which is working perfectly. Now I am trying to copy a folder having multiple files. I have added an extra progress bar, ...
- 1
0
votes
1
answer
86
views
Bash script for multiple copy 1 file and rename to new name
I want to create bash script for make multiple copy of 1 file in source directory to Destination directory and rename it with specific running number based on my config file.
example :Source directory ...
- 37
0
votes
1
answer
131
views
How do I copy certain cells from one sheet to another conditional on the cell value in both sheets?
I have a range of non-contiguous cells that I want to copy across from one sheet (wseDNA1) to a second sheet (wsElog1). I only want to copy if the value in wseDNA1 is not "NR", and if the ...
- 47
0
votes
1
answer
99
views
Every time I reference a newly created workbook, Excel creates another
I'm trying to do what should be very simple. Copy data from one sheet in an existing workbook, create a new workbook, paste that new data there, and then save and close the new workbook. However, ...
- 75
0
votes
1
answer
89
views
How to automatically copy to a specific physical usb port
Hi so I am wondering if there is a way to copy files to any usb connected without a idv nor idp,
Also I am wondering if there is a way to assign the above only to a specific usb port so that other ...
- 1
0
votes
1
answer
31
views
How should I deal with the running Apache IoTDB server when I need to copy storage groups to another IoTDB server?
I want to copy several storage groups from the running Apache IoTDB server to load into another IoTDB server. I want to know do I need to stop the current running IoTDB during the copy progress? Any ...
- 290
0
votes
1
answer
2k
views
Azure Synapse Pipeline Lookup / Copy activity, how to use variable for Query in place of table name
In Azure Synapse Pipeline Lookup or Copy activity's Query setting, I am testing to use a variable for my table name so this activity can be used inside of another ForEach loop. But I keep getting this ...
- 25
0
votes
2
answers
131
views
Search bar missing when copying test cases in Azure DevOps
When I copy a test case in DevOps, a popup opens to select a test plan. When you click the dropdown to select a test plan, there used to be a search bar to filter down the list. Now that search bar ...
- 1
0
votes
1
answer
254
views
Excel Macro Runtime error '-2147417848 (80010108)': Method 'Copy' of 'Range' failed
I have a macro that I am currently running on two different workbooks, however it is giving me the above error on one workbook only. Through trial and error, I'm learning that it's working when I am ...
- 47
0
votes
1
answer
84
views
Shutil copy2 says it copied the files, but I can't actually see them in Windows explorer
def do_it():
global files_to_move
global copymove
for file_dict in files_to_move.values():
if check_path(file_dict['new_path']) == False:
return
if (...
- 2,198
0
votes
1
answer
62
views
Copy & Delete Sheet Based on Cell Value
I've got assistance from user name @Ike to copy and delete cell. When I click the button based on images, few new sheet will be created named (based on cell value it indicate into the cell) - Example: ...
- 23
0
votes
3
answers
155
views
Copying stored procedures and changing database reference
I have a stored procedure that copies all the stored procedures in one database to another, changing the database reference. However, it currently has to be run on the destination db, whereas I would ...
- 3
1
vote
1
answer
83
views
Match & copy & paste mails from folder as attachment to another mail
Dear All I am suffering a code which match, copy and paste outlook mails as attachment from a given subfolder to an empty mail.
This subfolder located in my inbox which is not the default folder of ...
- 27
0
votes
2
answers
120
views
copy paste formatted text from another document without table cell
I am copy/pasting a formatted text from another document. The text is in the table of that document. when I remove the last character it removes the formatting for the last paragraph. however if I add ...
- 826