Create a new Excel file

Help
1

Hi guys,

Can someone tell me what I am missing in my creation of an Excel file?
image

PathForBookingDocuments = "C:\Users\kbb\Desktop\Test"+ Now.ToString(“dd-MM-yyyy HH.mm”)

It should create a file in the location called this exact time like: 15-10-2019 13.30

2

write
“C:\Users\kbb\Desktop\Test”+ Now.ToString(“dd-MM-yyyy HH.mm”)+“.xlsx”
and make sure to check Create New

image

1 Like
3

Hi @ImPratham45

I have now adjusted accordingly to your suggestions.

I get the folowing Output:
Excel Application Scope: Exception from HRESULT: 0x800A03EC

(I do not have an Excel sheet open)

4

will you pls send me your xaml

5

path is the problem buddy
mention like this
“C:\Users\kbb\Desktop\Test”+ Now.ToString(“dd_MM_yyyy_HH_mm”)+“.xlsx”

Cheers @Karsten_Bertelsen

6

abc15-16.xlsx (7.8 KB) Sequence.xaml (5.0 KB)

7

I can see that the problem only occurs when my path is:

"C:\Users\kbb\Desktop\Test"+ NU+ “.xlsx”

NU = Date.Now.ToString(“dd-MM-yyyy HH.mm”)

How can i make it work with a variable that is determined before the Excel Application Scope like mentioned above?

It works when i replace the path with "C:\Users\kbb\Desktop\Test"+ “15-10-2019 14.00”+ “.xlsx”

@ImPratham45 Thanks for the xaml

8

Sequence.xaml (5.0 KB)

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.